Re: RPG - MsSQL Connection

[Dieter Bender <dieter.bender@xxxxxxxxxxxx>]

... the better is the enemy of the good, why starting a JVM in every Job 
needing access to a remote database, why writing cumbersom embedded Java in 
RPG, when embedded SQL is supported, as it works with every remote database?

just my five cents

Dieter

Am Donnerstag 09 September 2010 18:30 schrieb Alan Campin:
> 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(Unkno
> > wn
> >
> > > 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.