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"
Now it works.
