× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Dieter,

Just wondering how to handle the need to join a remote table to a local
table? As an example, perhaps I need to retrieve rows from a MS-SQL
Server, then update a local table to match the remote. If using
ARDgate, would I need to connect to the remote, then make a copy into a
local temp table, then connect to the local DB2 to process the update
statement? I understand that DB2 Multisystem could handle concurrent
access (federated DB), but otherwise is not supported on IBM i.

-Eric DeLong

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dieter Bender
Sent: Thursday, September 09, 2010 8:37 AM
To: RPG programming on the IBM i / System i
Subject: 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(Unkn
own
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.