Why do I get "Data source not found and no default driver" message when I am sure I have defined the ODBC-ODBC Bridge DSN in my odbc.ini
file?
If you get this error and are sure that a DSN exists with the same name as the one you specified, check for the following:
- The section for the DSN in the odbc.ini file needs to contain the following entry:
Driver = ODBC-ODBC Bridge
–Or–
Driver = ODBC-ODBC Bridge_r
for the thread-safe Easysoft ODBC-ODBC Bridge client.
- The
odbcinst.ini
file needs to contain an entry for the ODBC-ODBC Bridge client. The entry looks similar to this:[ODBC-ODBC Bridge] Description = Easysoft ODBC-ODBC Bridge Driver = /usr/local/easysoft/oob/client/libesoobclient.so.1 Setup = /usr/local/easysoft/oob/client/libesoobsetup.so UsageCount = 1
–Or–
[ODBC-ODBC Bridge_r] Description = Easysoft ODBC-ODBC Bridge (MT) Driver = /usr/local/easysoft/oob/client/libesoobclient_r.so.1 Setup = /usr/local/easysoft/oob/client/libesoobsetup.so UsageCount = 1
for the thread-safe driver.
If the entry is missing, refer to Post installation steps for non-root installations in the Installing on UNIX section of the ODBC-ODBC Bridge manual for instructions on how to add it.