Community in read only mode June 18 & 19
This community will be set in READ ONLY mode for a while on Tuesday June 18 into Wednesday June 19 while we import content and users from our Micro Focus Forums community site. MORE INFORMATION

How do I resolve error, "(IM002) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" ?

How do I resolve error, "(IM002) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" ?

[ ] *** Error: (IM002) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This error is typically thrown because the code is specifying a DSN that does not exist.

[ ] STRING sConnectString = "DSN=Test;DBQ=C:\example.xls"

The DSN must already exist or be one that you created yourself. If you reference a DSN that does not exist you will see this error:

Make sure you are referencing a DSN that has been created.

  • To see your existing DSN"s go to Control Panel - Data Sources (ODBC).

  • Your ODBC Data Source Administrator will open. Here make sure your DNS exists (under user DSN"s).

  • If it does not then create one (See Resolution 20830).

Old KB# 21312

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Comments

Hello,

I am Using DSN created in System DSN. As per you should I require to create in User DSN?

Thanks

Shon

Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:19
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.