Re: RPG - MsSQL Connection

[Dieter Bender <dieter.bender@xxxxxxxxxxxx>]

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.