Menu
Simba Technologies
Simba Technologies

SimbaEngine X SDK 10.1.3
Developing Drivers for Data Stores Without SQL

SimbaEngine X SDK Documentation > Testing and Troubleshooting > Testing On Linux, Unix, and MacOS

Testing On Linux, Unix, and MacOS

This section explains how you can test your custom ODBC driver in Linux, Unix, and macOS platforms.

iODBCTest and iODBCTestW

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:

  1. Use the following command to run iodbctest or iodbctestw:

    ./iodbctest

    Or, ./iodbctestw

    Note:

    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.

  2. The program will ask you to enter an ODBC connect string. Type ? 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)

  3. If you have successfully connected, the prompt SQL> appears.
  4. Test out some simple SELECT queries to see if your data is being retrieved properly from your data source.

UnixODBC

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.

  1. Run iSql:

    ./isql <DSN> <UID (if applicable)> <PWD (if applicable)> <options (if applicable)>

  2. If you have successfully connected, the prompt SQL> appears.
  3. Test out some simple SELECT queries to see if your data is being retrieved properly from your data source.

 

Related Links

Connect to the Data Source in the Linux or macOS version of the 5 Day Guides at http://www.simba.com/resources/sdk/documentation/