Easysoft
ODBC Drivers for Oracle, SQL Server, Firebird, ISAM, InterBase, Sybase, MS Access & more.

Easysoft ODBC-ODBC Bridge

Why does SQLDataSources list a data source which returns the Data source name not found message when I connect to it?

Article : 00065
Last Reviewed : 19th July 2005
Revision : 1

If you are using the unixODBC driver manager (included in the Easysoft ODBC-ODBC Bridge (OOB) distribution) then SQLDataSources (or DBI->data_sources if you are using Perl) will return the data sources found in the odbc.ini file (it does not check the validity of each data source). However, if any of these data sources are missing the Driver attribute or have a Driver attribute for which there is no corresponding driver in the odbcinst.ini file then unixODBC will return:

IM002, Data source name not found, and no default driver specified.

If your application is linked directly with OOB (no driver manager) then although the OOB client supports SQLDataSources it is limited support and you are better using a driver manager.

Applies To

Knowledge Base Feedback

* Did this content help you?
Yes
No
Maybe
 
* Please select one option based on your first choice:
I'm very satisfied
I think it will help, but I haven't tried it yet
It is helpful, but I need more information
It is helpful, but hard to understand
Seemed relevant in search results, but didn't help me
The information is incorrect
The page contains one or more broken links
 
  Suggest new content or let us know how we can improve this content:

 
  (* Required Fields)   



© 1993 - 2008 Easysoft Limited. All rights reserved.