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.