Re: RPG - MsSQL Connection

[Alan Campin <alan0307d@xxxxxxxxx>]

Or use Scott JDBC API's.

On Thu, Sep 9, 2010 at 7:37 AM, Dieter Bender <dieter.bender@xxxxxxxxxxxx>wrote:

> 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.
>
> --
> mfG
>
> Dieter Bender
>
>
> DV-Beratung Dieter Bender
> Wetzlarerstr. 25
> 35435 Wettenberg
> Tel. +49 641 9805855
> Fax +49 641 9805856
> www.bender-dv.de
> eMail dBender@xxxxxxxxxxxx
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.