ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
5.00/5 (7 votes)
While using Microsoft Text Driver to read CSV data to DataSet in C# in your 64 bit machine
While you are trying to read a CSV file and trying to get the data in a
DataSet using Microsoft Text Driver in your 64 bit machine, you will be shown an error message as:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Try the solution as I do. It worked for me:
- Go to IIS and Application Pools in the left menu.
- Click the project name in the listing.
- Click the Set Application Pool Defaults.
- In General Tab, make the Enable 32 Bit Application entry to "
True"