Salesforce

ODBC Check Driver Utility (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

ODBC Check Driver Utility (Magic xpa 4.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:

Reference
Attachment 
Attachment