CONNX ODBC example

Edis, Bob bob.edis@fleetpride.com
Wed, 3 Jan 2001 13:45:29 -0600


G'day all

The following syntax is working for me for both CONNX and HiT/400 ODBC
drivers (RMS and DB/400 files respectively).

DATABASE test TYPE ODBC                          &
  DESCRIPTION "ODBC database accessed via"   &
              "CONNX ODBC driver"          &
  OPEN ODBC_Test USERID "logonid" PASSWORD "password" &
  NULL VALUES ALLOWED

Note that 'ODBC_Test' is set up in my Windows NT ODBC connections 'System
DSN' tab on the same machine as PH is running on.  The USERID and PASSWORD
parameters require quotes around the values.

The RMS files are on various AlphaServer OpenVMS machines and the DB/400
files are on an AS/400 OS/400 machine.

Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.