RE: Oracle heterogeneous services - Experiences anyone?

If you so a search on the archives for Oracle -l you will see my woes.....

I would open two connections instead of going down this route instead IF your SQL Server isn't very reliable..... We have actually staled and brought down our Oracle doing this. BUT our sql server app is not stable.
Try to push stuff via DTS or sqlldr as well.

We paid 8.000 for data direct drivers to do this and I am happy to say we are off of this in less than one year.

We also experience memory leaks. If a connection hangs between the two, kill it off on the sql server end.

As you see .... I am not a fan.

My 3 cents worth.

Kathy
-----Original Message-----

From: Andreas.Haunschmidt_at_voestalpine.com [mailto:Andreas.Haunschmidt_at_voestalpine.com] Sent: Friday, November 19, 2004 5:05 AM
To: oracle-l_at_freelists.org
Subject: Oracle heterogeneous services - Experiences anyone?

Dear List Members!

A collegue of mine not having access to this list=20 needs to exchange data between an Oracle 9 and a Microsoft SQL-Server = database.=20
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 = "special"=20
features in a production environment.

Thanks in advance

--

Andreas Haunschmidt
voestalpine Informationstechnologie GmbH / Linz Abt. TWI
VOEST-ALPINE-Str. 3, Postfach 3, 4031 Linz, =D6sterreich Tel.: +43-732-6585-3386
Fax: +43-732-6980-9411
E-Mail: andreas.haunschmidt_at_voestalpine.com http://www.voestalpine.com/informationstechnologie =20
=20
--

http://www.freelists.org/webpage/oracle-l

This transmission contains information solely for intended recipient and may be privileged, confidential and/or otherwise protect from disclosure. If you are not the intended recipient, please contact the sender and delete all copies of this transmission. This message and/or the materials contained herein are not an offer to sell, or a solicitation of an offer to buy, any securities or other instruments. The information has been obtained or derived from sources believed by us to be reliable, but we do not represent that it is accurate or complete. Any opinions or estimates contained in this information constitute our judgment as of this date and are subject to change without notice. Any information you share with us will be used in the operation of our business, and we do not request and do not want any material, nonpublic information. Absent an express prior written agreement, we are not agreeing to treat any information confidentially and will use any and all information and reserve the right to publish or disclose any information you share with us.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 19 2004 - 08:41:42 CST