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
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page

petek
Posting Yak Master

192 Posts

Posted - 2009-01-02 : 09:50:55
on the sql box

Kind Regards

Pete.
Go to Top of Page

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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 10:02:07
quote:
Originally posted by petek

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

Kind Regards

Pete.



then it seems like its problem with oracle provider.Try installing latest oracle network component
Go to Top of Page

petek
Posting Yak Master

192 Posts

Posted - 2009-01-02 : 10:10:32
sorry to be a pain but is it downloadable from oracle


Kind Regards

Pete.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 10:15:10
quote:
Originally posted by petek

sorry to be a pain but is it downloadable from oracle


Kind Regards

Pete.


try this out

http://blogs.conchango.com/jamiethomson/archive/2006/09/19/OLE-DB_3A00_-Cannot-connect-using-Microsoft-OLE-DB-Provider-for-Oracle.aspx
Go to Top of Page

petek
Posting Yak Master

192 Posts

Posted - 2009-01-02 : 10:17:32
thanks visakh16 will take a look

Kind Regards

Pete.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 10:21:36
Welcome
let us know how you got on
Go to Top of Page
   

- Advertisement -