Troubleshooting > Troubleshooting DataConnect > Data source name not found and no default driver specified
Was this helpful?
Data source name not found and no default driver specified
 
Error Code
19
Error Message
Error 19 connecting to 'Actian Vector': From Connect (driver): SQL state IM002, message: [Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified.
Description
This error is usually displayed for connectors like Actian Vector when the map has user defined dataset with macros in it.
Cause/Solution
 
Cause: This error is usually displayed when the map has user defined dataset with macros in it.
Solution: Do the following:
1. Go to source or target connection.
2. Paste macros again.
3. Run the transformation.
OR
1. Click the Configuration tab.
2. Expand Macros section.
3. Click Edit and add the required macroset.
Related Information
Last modified date: 12/03/2024