DB link for nonoracle databases
Hi All !! I have a DBA question. Can we make a DB link for nonoracle databases ! The answer is 'YES' , I know. But How. The documentation says you will have to use Oracle hetrogeneous services. There is no explaination any further. I want my Oracle database to gather data from a SQL server . Both are on NT. Thanks in Advance. Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: DB link for nonoracle databases
You have to setup heterogeous services. Check in the Net8 guide under Configuring connections to non-Oracle Databases Services. Here what I've done to have a dblink between Oracle 816/Solaris and SQLServer 6.5 via ODBC MERANT. Modify listener.ora to listen to hsodbc. Add en entry in tnsnames.ora to point on hsodbc. Create a dblink on hsodbc. I was able to read/write on tables on SQLServer. Even if it's not support, I was able to run a stored proc on SQLServer with dbms_hs_passthrough.execute_immediate. The only bad thing is that all processes were frozen on SQLServer until I log out. --- Deepender Kr Gupta <[EMAIL PROTECTED]> a écrit : > Hi All !! > > I have a DBA question. Can we make a DB link for > nonoracle databases ! The > answer is > 'YES' , I know. But How. > > The documentation says you will have to use Oracle > hetrogeneous services. There is no explaination any > further. > > > I want my Oracle database to gather data from a SQL > server . Both are on NT. > > Thanks in Advance. > > Deepender > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Deepender Kr Gupta > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: DB link for nonoracle databases
'Oracle heterogeneous services' are purchased separately. They are services that run on the target systems that allow Oracle to talk to them through Net*8. We use an Oracle gateway to talk to our AS400s. For the most part, this works well. Call your rep. Todd Carlson Oracle 8i Certified DBA Bunge Corporation "Deepender Kr Gupta" To: Multiple recipients of list ORACLE-L wipro.com> cc: Sent by: Subject: DB link for nonoracle databases [EMAIL PROTECTED] 05/02/2001 12:05 AM Please respond to ORACLE-L Hi All !! I have a DBA question. Can we make a DB link for nonoracle databases ! The answer is 'YES' , I know. But How. The documentation says you will have to use Oracle hetrogeneous services. There is no explaination any further. I want my Oracle database to gather data from a SQL server . Both are on NT. Thanks in Advance. Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: DB link for nonoracle databases
Deepender Kr Gupta schrieb: > > Hi All !! > > I have a DBA question. Can we make a DB link for nonoracle databases ! The > answer is > 'YES' , I know. But How. > > The documentation says you will have to use Oracle > hetrogeneous services. There is no explaination any > further. > > I want my Oracle database to gather data from a SQL > server . Both are on NT. > > Thanks in Advance. > > Deepender > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deepender Kr Gupta > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > --- > This Mail has been checked for Viruses > Attention: Encrypted Mails can NOT be checked ! > > *** > > Diese Mail wurde auf Viren ueberprueft > Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! > Hi, check the following documentation set: Oracle8i Distributed Database Systems Part III Heterogeneous Services Concepts and Administration You have to distinguish 2 kinds of Heterogenous Services: Transparent Gateway and Generic Connectivity. Transparent Gateway has to be purchased seperately and offers 2 services: SQL access to non-Oracle data sources (like DB2 e.g.) and transaction services, meaning that e.g. DB2 tables might be included in Oracle transactions. Generic Connectivity comes with Oracle Server (at least the EE). It allows you to connect to ODBC and OLE DB data sources (like Excel Sheets or e.g. DB2 through ODBC). Oracle has to be run on NT/2000. Connecting to other databases via the ODBC/OLE DB gateway gives you the ability of accessing external data like tables. We tried it, it works fine and is in my opinion a good and cheap solution for data transfers (unless you have any high volume / online needs). -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: DB link for nonoracle databases
Hi, 2 Metalink notes you might find useful: 114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic Connectivity using ODBC" 109730.1 - How to setup generic connectivity (Heterogeneous Services) for Windows NT Also, as far as I know, Heterogeneous Services only works with 8.1.6 and above. Regards, Bruce Reardon mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, 3 May 2001 23:46 Deepender Kr Gupta schrieb: > > Hi All !! > > I have a DBA question. Can we make a DB link for nonoracle databases ! The > answer is > 'YES' , I know. But How. > > The documentation says you will have to use Oracle > hetrogeneous services. There is no explaination any > further. > > I want my Oracle database to gather data from a SQL > server . Both are on NT. > > Thanks in Advance. > > Deepender Hi, check the following documentation set: Oracle8i Distributed Database Systems Part III Heterogeneous Services Concepts and Administration You have to distinguish 2 kinds of Heterogenous Services: Transparent Gateway and Generic Connectivity. Transparent Gateway has to be purchased seperately and offers 2 services: SQL access to non-Oracle data sources (like DB2 e.g.) and transaction services, meaning that e.g. DB2 tables might be included in Oracle transactions. Generic Connectivity comes with Oracle Server (at least the EE). It allows you to connect to ODBC and OLE DB data sources (like Excel Sheets or e.g. DB2 through ODBC). Oracle has to be run on NT/2000. Connecting to other databases via the ODBC/OLE DB gateway gives you the ability of accessing external data like tables. We tried it, it works fine and is in my opinion a good and cheap solution for data transfers (unless you have any high volume / online needs). -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).