RE: Oracle Gateway to SqlServer
- From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 May 2005 10:06:53 +1000
Tom,
What OS is your Oracle DB on?
Can you get an ODBC driver for SQL Server for that OS.
If you can and if HSODBC is available for that Oracle platform then that =
is an option - it is free but it does have limitations.
Some relevant Metalink notes are 107227.1 and 109730.1 plus some =
previous postings on this list, eg:
Michael Thomas list of issues with Generic Connectivity:
http://www.orafaq.com/maillist/oracle-l/2004/06/23/1750.htm
Or a posting by myself at =
http://www.orafaq.com/maillist/oracle-l/2004/05/04/0234.htm that talks =
about some parameters to add if you use GC and have global_names =3D =
TRUE
Cheers,
Bruce Reardon
-----Original Message-----
From: Mercadante, Thomas F
Sent: Monday, 9 May 2005 10:34 PM
We have a new requirement where an Oracle database application will need
recurring data from a SqlServer database. By recurring data I mean that
every day, there will be new data placed into a sqlserver database, and
that this data will need to be available from the Oracle database.
Has anyone used the Oracle Gateway to SqlServer product? Does it work
well? Is this a better option than an export, sql Loader, and PL/SQL
process option? Any obvious problems using this product?
Tom
NOTICE
This e-mail and any attachments are private and confidential and may =
contain privileged information. If you are not an authorised recipient, =
the copying or distribution of this e-mail and any attachments is =
prohibited and you must not read, print or act in reliance on this =
e-mail or attachments.
This notice should not be removed.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
