Funny
you should ask as we are in the process of implementing something very similar
here. Selecting from SQL Server tables from within an Oracle database that is.
It can
be done relatively inexpensively (about $4k per cpu for the ODBC
driver)
You
need to look into "Oracle Heterogeneous Services" and install them on
the Oracle DB Server
This
requires a 3rd party ODBC driver. We chose the SQL Server Wire Protocol
ODBC driver from DataDirect. Once you have configured the Hetero Services
and the ODBC driver all you do is create a database link! Then you can select
form the SQL Server table as if it was a remote Oracle table. (with limits as
SQL Server is not as powerful an engine as Oracle)
Initial installation took about 1/2 day, including the trial software
downloads.
Pretty
sweet solution for small tables!
Kevin
-----Original Message-----
From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 5:21 PM
To: Multiple recipients of list ORACLE-L
Subject: LOV on Forms 6i to be populated with data from SQL Server 2000 taHi GurusI have a unusual request from one of new clients. I have an application that is 100% Oracle forms 6i, and reports 6i and DB 8.1.7 running on W2K platform. Clients wants to know whether he can populate a LOV on Oracle form with data from one of the columns of a table in SQL Server 2000.Is there a way to achieve this with something like database link, dynamic link, etc. ..........Appreciate any help or lead or direction to documentation in regardThanks in advanceRegards
Shiva Baswannappa
Life Sciences Business Unit
Digital Consulting & Software Services, Inc._↗
Phone: 281.243.2658
Fax: 281.243.2504
Web: http://www.dcss.comIf the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
