Re: Accessing MSSQL with SQLCLI

Joe,

Just to throw my 0.02 in, we are actually using a JDBC solution in
production. We looked at packages and rolling our own solution, and
we went with ProData's RDB connect, but it was basically a coin flip
between that and the product from RJS. We already have a relationship
with ProData (DBU) and that won the day. Works nicely. But I've seen
RJS's product demoed and it seems to work well as well.

Mike E.

On Tue, Jul 15, 2008 at 6:07 PM, Joe Giusto II <midrange@xxxxxxxxxxxx> wrote:

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.