This section explains how you can test your custom ODBC driver in Linux, Unix, and macOS platforms.
The utilities iodbctest and iodbctestw are included with the iODBC driver manager installation. You can use one these utilities to establish a test connection with your driver and your DSN. Use iodbctest to test how your driver works with an ANSI application, and use iodbctestw to test how your driver works with a Unicode application.
For more information on how to use this utility, see www.iodbc.org. For an example of how to use iODBCTest, see the section Connect to the Data Source in the Linux or macOS version of the 5 Day Guides at http://www.simba.com/resources/sdk/documentation/.
To Test Your Custom ODBC Driver with iODBCTest or iODBCTestW:
There are 32-bit and 64-bit installations of the iODBC driver manager available. If you have only one version of the driver manager installed, you will have the appropriate version of iodbctest (or iodbctestw). However, if you have both 32-bit and 64-bit versions installed, you will need to ensure that you are running the version from the correct installation directory.
?if you do not remember the name of your DSN. Your ODBC connect string has the following format:
DSN=<your_DSN_name>;UID=<user_id> (if applicable);PWD=<your password> (if applicable)
iSql is a utility that is included with the UnixODBC driver manager installation. You can use this utility to test a connection with your driver and your DSN.
For more information on how to use this utility, see www.iodbc.org.
./isql <DSN> <UID (if applicable)> <PWD (if applicable)> <options (if applicable)>
Connect to the Data Source in the Linux or macOS version of the 5 Day Guides at http://www.simba.com/resources/sdk/documentation/