RE: Accessing MSSQL with SQLCLI

Richard,

Perhaps this is the product that former(?)-list-member John Brandt Sr. had available....

http://archive.midrange.com/midrange-l/200310/msg01146.html

I have not seen any posts from John for some time, but his product always intrigued me.

Eric DeLong
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Richard Schoen
Sent: Thursday, July 17, 2008 8:09 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Accessing MSSQL with SQLCLI


Hi Mike,

Thanks for the nice mention.

Can you clarify this statement ?

"we are actually using a JDBC solution in production."

Did you wrap your own JDBC calls or implement ProData's product ?

Their site makes it sound like their product is NOT JDBC based.

Thanks.

Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT


-----Original Message-----
-------------- Original message --------------
From: "Mike Eovino" <meovino@xxxxxxxxx>

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 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.