ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
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:
1. Go to IIS and Application Pools in the left menu.
2. Click the project name in the listing.
3. Click the Set Application Pool Defaults.
4. In General Tab, make the Enable 32 Bit Application entry to "True"
Now it works.
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:
1. Go to IIS and Application Pools in the left menu.
2. Click the project name in the listing.
3. Click the Set Application Pool Defaults.
4. In General Tab, make the Enable 32 Bit Application entry to "True"
Now it works.