I'm still working on it for connectivity to PostGreSql. Needless to say, OTS is rather worthless on the subject. They'll help you with the configuration, etc of the service. Beyond that your on your own. I'd recommend he look into the transparent gateway product. OTS is much more helpful there. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Andreas.Haunschmidt@xxxxxxxxxxxxxxx [mailto:Andreas.Haunschmidt@xxxxxxxxxxxxxxx]=20 Sent: Friday, November 19, 2004 6:05 AM To: oracle-l@xxxxxxxxxxxxx Subject: Oracle heterogeneous services - Experiences anyone? Dear List Members! A collegue of mine not having access to this list=3D20 needs to exchange data between an Oracle 9 and a Microsoft SQL-Server = =3D database.=3D20 As far as I know he needs only to access SQL-Server data from Oracle. He would like to know about the experiences people made using Oracle heterogeneous services for that purpose. I would be thankful if anyone liked to share his/her experiences, and knowledge about reliability, performance,pitfalls and other =3D "special"=3D20 features in a production environment. Thanks in advance -- Andreas Haunschmidt voestalpine Informationstechnologie GmbH / Linz Abt. TWI VOEST-ALPINE-Str. 3, Postfach 3, 4031 Linz, =3DD6sterreich Tel.: +43-732-6585-3386 Fax: +43-732-6980-9411 E-Mail: andreas.haunschmidt@xxxxxxxxxxxxxxx http://www.voestalpine.com/informationstechnologie =3D20 =3D20 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l