Your ODBC driver must include the following functions:
* all Core ODBC driver functions
* the Level 1 function SQLColumns
* the Level 1 function SQLTables
Depending on the method of record locking you choose, your driver may also need to support some of the following function calls (please see the description for A-ODBC-LOCK-METHOD in the ODBC: Configuration File Variables ):
* SQLSetStmtOption
* SQLSetScrollOptions
* SQLExtendedFetch
* SQLSetPos
To test the capabilities of your ODBC driver, we have included a driver test program on your Acu4GL for ODBC installation disks. You can also consult your driver documentation to ensure that it meets these requirements.
ODBC Driver Test
Acu4GL for ODBC includes a driver test program designed to test your ODBC driver for compatibility with Acu4GL for ODBC. The driver test also lists all the tables/columns for the driver selected. This can help design COBOL FD statements for existing tables. To initiate the program, select the DRVTST32.EXE (32-bit version) icon in the program group where Acu4GL for ODBC has been installed.
User interaction for this program is minimal. The only time you need to interact with the program is when it first initiates and you are asked for the name of the ODBC driver to connect to. You will see a dialog box very similar to the ODBC setup dialog box, asking you to select a data source.
Once you have selected a data source, you may be asked to log on to the data source (this depends on the data source you select). Enter your login and password, if necessary.
After that, the program queries the ODBC driver, and creates a file called ACUCOBOL.RPT in the current directory. This file is filled with information about the driver you chose, but is in a format that is most useful to Acucorp Technical Support. When you are finished running the driver test program, send the ACUCOBOL.RPT file to Acucorp Technical Support, and they can help you determine the compatibility level of your driver.
If you execute this program multiple times, information will be appended to the original ACUCOBOL.RPT file.