Re: RPG - MsSQL Connection

... 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.