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



Another solution might be to use a stored procedures and do the join in the
stored procedure. You can join between tables on two different systems on
the SQL Server pretty easily. Not sure what you are doing or what you are
trying to accomplish but writing a stored procedure in SQL Server and
calling to it from the AS/400. A lot simpler.

On Thu, Sep 9, 2010 at 11:09 AM, DeLong, Eric <EDeLong@xxxxxxxxxxxxxxx>wrote:

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.

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



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



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.