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 21. ODBC Data Source Administrator screen

  2. Click Configure.

    The system displays the following screen:

    Figure 22. Data source name screen

  3. Click Advanced.

    The system displays the following screen:

    Figure 23. Advanced Information Screen

  4. Click More.

    The system displays the following screen:

    Figure 24. 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