Link SQL to Oracle 10g - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Link SQL to Oracle 10g

Author

Topic

petek
Posting Yak Master

192 Posts

Posted - 2009-01-02 : 09:27:10

Hi all,

I am hoping this is a qucik one....But does anybody know how to link a MSSQL 2K to Oracle 10g server??

I read somewhere i need to create a Linked server. but i am not sure of the syntax or the Provider string....

Kind Regards

Pete.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 09:31:41

use
1.Export import wizard
2. OPENROWSET or
3. add as a linked server and use four part naming convention server.db.schema.object or OPENQUERY

petek
Posting Yak Master

192 Posts

Posted - 2009-01-02 : 09:44:08

Hi visakh16,

Thank you for your reply and happy new year.

I tried the Import and Export Wizard and got the following error:

Test connect failed because of an errro in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are insatlled.

What components do i need to install, do they come with oracle??

Kind Regards

Pete.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 09:47:47

quote:
Originally posted by petek

Hi visakh16,

Thank you for your reply and happy new year.

I tried the Import and Export Wizard and got the following error:

Test connect failed because of an errro in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are insatlled.

What components do i need to install, do they come with oracle??

Kind Regards

Pete.

were you trying to run export/import wizard in sql box or oracle box.

petek
Posting Yak Master

192 Posts

Posted - 2009-01-02 : 09:50:55

on the sql box

Kind Regards

Pete.

petek
Posting Yak Master

192 Posts

Posted - 2009-01-02 : 09:53:29

I am using the Microsoft OLE DB Provider for Oracle driver if that helps

Kind Regards

Pete.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 10:02:07