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:
28th October 2008
Revision:
2

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?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.