Click here to Skip to main content
15,867,835 members
Articles / Programming Languages / C#
Tip/Trick

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Rate me:
Please Sign up or sign in to vote.
5.00/5 (7 votes)
4 Feb 2012CPOL 109.4K   3   7
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:

  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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Comments and Discussions

 
QuestionERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Pin
Member 1482876111-May-20 6:30
Member 1482876111-May-20 6:30 
GeneralMy vote of 5 Pin
captonmike7-Nov-19 12:39
captonmike7-Nov-19 12:39 
QuestionTY Pin
damianrodriguez88@gmail.com18-Jul-14 5:01
damianrodriguez88@gmail.com18-Jul-14 5:01 
QuestionRROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Pin
Member 105753845-Feb-14 20:31
Member 105753845-Feb-14 20:31 
Questionweb service Pin
Abdul Rahman El Habboub9-May-13 23:13
Abdul Rahman El Habboub9-May-13 23:13 
QuestionThanks. Pin
Mannava Siva Aditya16-Dec-12 18:30
Mannava Siva Aditya16-Dec-12 18:30 
QuestionKeep it up.. Pin
tulasiram397517-Aug-12 2:38
tulasiram397517-Aug-12 2:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.