Re: RPG - MsSQL Connection

Hi,

looks like a problem with the MS SQL Server Configuration, did you activate
the TCP IP listener? check with netstat -a at the windows box with MS SQL
Server, if there is a listener at 1433

BTW: why don't you use ArdGate, its more easy to use embedded SQL over making
calls to java methods from RPG - and you don't have multiple JVMs on your
AS/400.

D*B

Am Donnerstag 09 September 2010 14:09 schrieb Chamara Withanachchi:

Dear All,

I'm tryiong to connect a MS SQL database from RPG buy I'm getting following
error when it tries to make the connection

com.microsoft.sqlserver.jdbc.SQLServerException: : Unrecoverable error

at java.lang.Throwable.<init>(Throwable.java:195)

at java.sql.SQLException.<init>(SQLException.java:40)

at com.microsoft.sqlserver.jdbc.SQLServerException.<init>(Unknown
Source)

at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.build70Logon(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown
Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
Source)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
Source)

bellow is the my code extracted from Scott Klement article

prop = JDBC_Properties();
JDBC_setProp(prop: 'userName' : 'sa');
JDBC_setProp(prop: 'password' : 'sdb#123');
JDBC_setProp(prop: 'databaseName' : 'testDB');

conn =
JDBC_ConnProp('com.microsoft.sqlserver.jdbc.SQLServerDriver'

:'jdbc:sqlserver://10.100.19.36:1433'
: prop );

JDBC_freeProp(prop);

bellow is my CLASSPATH

ADDENVVAR ENVVAR(CLASSPATH) VALUE('/mobbnk/java/sqljdbc.jar')

Im on V5R4, JRE 1.4 and using MS SQL Server JDBC Driver 1.0


Can some one guide me on this


--
Regards,

Chamara Withanachchi
IBM Certified Power System Expert
RPG Programmer
(owner of www.rpgiv.info)

WWW.RPGIV.INFO
Mob: +94 77 1678646
chamaraw@xxxxxxxxxx

i want to be future ready. i want control. i want an i.