ODBC Check Driver Utility (Magic xpa 3.x)
MGCHCKDRV.EXE
The ODBC Check Driver utility is included with the ODBC driver. Running this program tests the ODBC data source and prints a list of functions that are produced by the driver. The test will let you know whether the driver can be used with the Database Gateway for ODBC.
If you installed the ODBC gateway when you installed Magic xpa, you will find the mgchkdrv.exe file in the Gateways folder of the Magic xpa directory.
The MGCHKDRV utility was built to check information for any ODBC driver.
Follow these steps to execute an SQL statement using the ODBC utility. The first part of each step, shown in italics, indicates the option that you can activate from the ODBC Test utility menu.
|
1.
|
Connect\Full Connect - connect to the database
|
|
2.
|
Statement\AllocStmt - allocate a statement handle
|
|
3.
|
Statement\SQLExecDirect - execute the SQL statement you want
|
|
4.
|
Results\SQLGetData All - get all the retrieved data
|
|
5.
|
Statement\FreeStmt - free the statement
|
|
6.
|
Connect\Full Disconnect - disconnect from the database
|
The Check Driver utility retrieves information about the following eight categories:
Driver and DBMS Product Information
Data Source Information
SQL Statements Supported by the Data Source
SQL Limits
DBMS Type Support
SQL Keywords
SQL Functions
Syntax of DML Commands
