I think to use DB2/CLI from the i to access a MS Sequel Server, you must have a DRDA acces provider installed. This is notoriouly difficult to do, as there do not seem to many products that can provide this support. Generally, the standard alternative approach is to use a Java based JDBC driver (type 3?) to connect to the remote server. Scott Klement has published several articles covering this.

Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Joe Giusto II
Sent: Tuesday, July 15, 2008 5:08 PM
To: Midrange-L
Subject: Accessing MSSQL with SQLCLI

can anyone help me with the connection parameters to access the MSSQL data
base using SQLCLI?

i have been searching all day and the only example i found for SQLCLI was
for attaching to another AS400 data base.

in the example i have been trying to work with, i have the following connect
rc = SQLConnect(hdbc :
szDSN :
cbDSN :
szUID :
cbUID :
szAuthStr :

i have changed szDSN to the name of the data base (which i am able to access
via ms access odbc driver) but i do not know how to tell it the location (ip
address) of the server that the MSSQL data base resides on.

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page