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.

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
statement:
rc = SQLConnect(hdbc :
szDSN :
cbDSN :
szUID :
cbUID :
szAuthStr :
cbAuthStr);

cbDSN = SQL_NTS
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 mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact