Setting a driver keyword

You can set driver keywords using the following methods, or a combination of the following:

Using the ODBC connection string

To specify a setting using an ODBC connection string, code the keyword in your program, as shown in the following example:

rc = SQLDriver Connect (hdbc, NULL, (u_char far *)
   "NOAS=no;"
   "UID=ai00xyz;PWD=abcdef;"
   "PORT=1200;HOST=129.4.0.160;"
   "LGID=dan;"
   "DSN=Tuld;"

Using the ODBC.INI File

The following example shows how to set a keyword value using the ODBC.INI file:

Driver=C:\WINDOWS\SYSTEM\scodbc.dll
Description=Sample Shadow Direct Driver
APPL=ODBC
LINK=TCPIP
LGID=ita
UID=ai00xyz
PWD=abcdef
HOST=129.4.0.160

Using the ODBC datasource administrator

Keywords can also be set using the MAS ODBC Datasource Administrator. This method can be used after the MAS ODBC driver has been installed and configured. To use this method:

  1. Open the Control Panel, and double-click the ODBC icon.

    The system displays the following screen:

    Figure 24. ODBC Data Source Administrator screen


  2. Click Configure.

    The system displays the following screen:

    Figure 25. Data source name screen


  3. Click Advanced.

    The system displays the following screen:

    Figure 26. Advanced Information Screen


  4. Click More.

    The system displays the following screen:

    Figure 27. Optional Information Screen


  5. Select the Keyword, in this example it is LKES. You can change the setting from Yes to No.

Copyright IBM Corp. 1997, 2003