We've realized a connection to a remote OracleDB
when ARS is running on Oracle. We used Oracle SQL-Net
and Oracle DB-Link for this.

But it's possible to access data when the remote database server
is from a different vendor.
But for this it's neccessary to use a databse gateway product allowing
a database from one vendor to connect a database of a different vendor.

Please ask Oracle and Sybase if there's a gateway available (maybe third
party?).

HTH





TERRY_WOODWARD@HP-ANDOVER-OM2.OM.HP.COM on 01.09.99 15:13:38

Bitte antworten an "Action Request System discussion list(ARSList)"


An: ARSLIST@LISTSERV.VISTAIT.COM
Kopie: (Blindkopie: Ruediger Tams/Hamburg/PCM AG)
Thema: Direct SQL from Sybase to Oracle




Can anyone tell me if it the below senario is possible:

In an Active Link on a PC Client, with a Remedy 3.2.1 Server running
on HP-UX 10.20 on top of Sybase 11.0.3.2, access a remote Oracle 7.3
Database (Non-Remedy) and retrieve a few values to be presented in
a Dialog Box or a Query List window?

thanks in advance,

Terry



--
Mit freundlichen Gruessen / Best regards
Ruediger Tams

ZUHD Hamburg
Tel. 040 / 27 87 3 - 333
Fax. 040 7 2787 3 - 299
Mobile: 0173 / 95 44 98 3
E-Mail: RTAMS@debis.com

------------%<-------------

> But it's possible to access data when the remote database server
> is from a different vendor.
> But for this it's neccessary to use a databse gateway product allowing
> a database from one vendor to connect a database of a different vendor.
>
> Please ask Oracle and Sybase if there's a gateway available (maybe third
> party?).

Oracle have a product called Transparent Gateway. With it you can access 20+
different databases.
http://www.oracle.com/gateways/html/transparent.html




--
Jarl Groneng
jgroneng@online.no
Merkantildata ASA