RE: SQL CLI & MS-SQL Server

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Tom,

Sorry, but IBM uses DRDA, which is not natively supported by M$.  I
understand that products exist to add DRDA services to SqlServer, but I
can't give you any recommendations.  A potential alternative,  I understand
that V5R1 supports RPG calls to Java methods, so possibly you could write a
JDBC interface for RPG.

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: Tom Daly [mailto:Tdaly@sddsystems.com]
Sent: Wednesday, November 28, 2001 12:26 PM
To: 'rpg400-l@midrange.com'
Subject: SQL CLI & MS-SQL Server


Hi,

Is it possible to use the CLI api's to access an MS-SQL server or am I just
wasting my time?  I've been tinkering around with the example program from
the "sorcerer's guide" and consistently get a communications error.  I did a
netstat on the NT machine and see the 400 connecting.  In the failing
program the SQLCODE is -30080 and SQLSTATE is 08001.  My joblog shows
CPF9176 - DDM communications ended abnormally...   What's this DDM
business???  Do I need to install some DDM Server software on the NT box?

Any ideas/help/insight appreciated.


Tom
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.