Re: Accessing MSSQL with SQLCLI

Joe

You can't - Microsoft has not given us the equivalent of an ODBC driver for SQL Server.

And although SQL/CLI says it is using the same standard as ODBC, it isn't ODBC.

Eric mentioned JDBC - and that could be a good solution.

<verndor responst>
We have a product called RPG2SQL that lets you talk to any SQL-ish RDBMS from your RPGLE programs using function calls - these calls are somewhat like those of SQL/CLI - this is not embedded SQL. If interested in a quick demo, call us at RJS Software at 888.rjs.soft and ask for Vern - that's me!! Or email me - or look at our site at www.rjssoftware.com
</verndor response>

There is also a good article by Kent Milligan, which mentions several approaches, including JDBC. Also mentions our product, but is primarily focused toward IBM's solution - Kent does work for IBM, after all! The link to it is Heterogeneous Data Access for i5/OS Applications

HTH
Vern
-------------- Original message --------------
From: "Joe Giusto II" <midrange@xxxxxxxxxxxx>

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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.