Connect Oracle 8i with Sybase 12 Databases

[mregalado]

Hi...

I want to know if it possible to create a database link between Oracle 8i and Sybase 12, and if not i want to know how connect these two databases.

Thanks..

[jperusco]

Oracle have transparent gateway software to link other db's like db2, sybase etc. Below is the certification info from metalink for W2K, I haven't user the sybase version but I have used the same software to share information between DB2 and Oracle and it works a treat.

HTH
John

Certify - Additional Info Oracle Transparent Gateway for SYBASE Version 9.0.1 On Microsoft Windows 2000

--------------------------------------------------------------------------------

Operating System: Microsoft Windows 2000 Version 2000
Oracle Transparent Gateway for SYBASE Version 9.0.1
Oracle Server - Enterprise Edition V8 Version 8.1.7 (8i)
Status: Certified

Product Version Note:
None available for this product.

Certification Note:


Oracle Transparent Gateway for SYBASE v9.0.1 is certified against Oracle 8.1.7 (8i) and Sybase version 11.9.2 and 12.0.
NOTE: If the Sybase Server is not on the same machine as the 9.0.1 Gateway, then Sybase Open Client Library certified for the Sybase Server is required.

[ales]

Hi,
another option is using the Generic Connectivity feature.

See http://forums.dbasupport.com/forums/...threadid=30469

It's for free ...