Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: LOV on Forms 6i to be populated with data from SQL Server 2000 ta

RE: LOV on Forms 6i to be populated with data from SQL Server 2000 ta

From: Mandar A. Ghosalkar <>
Date: Thu, 29 May 2003 14:14:51 -0800
Message-ID: <>

use heterogeneous services + odbc/oledb and you could create a synonym for a sqlserver table.  

no need for any gateway product.    

 -----Original Message-----
Sent: Thursday, May 29, 2003 2:21 PM
To: Multiple recipients of list ORACLE-L ta

Hi Gurus  

I 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 regard  

Thanks in advance


Shiva Baswannappa
Life Sciences Business Unit
Digital Consulting & Software Services, Inc._šJ Phone: 281.243.2658
Fax: 281.243.2504
Web: <>

If 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.  


Please see the official ORACLE-L FAQ:

Author: Mandar A. Ghosalkar

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 29 2003 - 17:14:51 CDT

Original text of this message