FAQ
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-----
Sent: Thursday, May 29, 2003 5:21 PM
To: Multiple recipients of list ORACLE-L

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

Regards

Shiva Baswannappa
Life Sciences Business Unit
Digital Consulting & Software Services, Inc._?
Phone: 281.243.2658
Fax: 281.243.2504
Web: http://www.dcss.com <http://www.dcss.com/>

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: http://www.orafaq.net
--
Author: Kevin Toepke
INET: ktoepke_at_rlcarriers.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Search Discussions

  • Seefelt, Beth at May 30, 2003 at 4:56 am
    We do it with Microsoft's ODBC driver. Its free and we've had no problems.


    HTH.


    -----Original Message-----
    Sent: Thursday, May 29, 2003 5:51 PM
    To: Multiple recipients of list ORACLE-L
    200

    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-----
    Sent: Thursday, May 29, 2003 5: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

    Regards

    Shiva Baswannappa
    Life Sciences Business Unit
    Digital Consulting & Software Services, Inc._¨J
    Phone: 281.243.2658
    Fax: 281.243.2504
    Web: http://www.dcss.com <http://www.dcss.com/>

    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: http://www.orafaq.net
    --
    Author: Seefelt, Beth
    INET: Beth.Seefelt_at_TetleyUSA.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 29, '03 at 9:51p
activeMay 30, '03 at 4:56a
posts2
users2
websiteoracle.com

2 users in discussion

Seefelt, Beth: 1 post Kevin Toepke: 1 post

People

Translate

site design / logo © 2022 Grokbase