Linked server to Oracle on Unix problem

[Tom]

I am trying to add a linked server to an Oracle Database on Unix.

I have been able to transfer data to the Oracle database in Unix using Dts. NO problem. But when I set up a linked server I get a 7399: OLE DB provider MSDAORA; reported and error. Can someone help me out please. Here is how I am setting up my linked server

USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver
@server = 'Dev1',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'Dev1'
GO
I then use sp_addlinkedsrvlogin
EXEC sp_addlinkedsrvlogin 'sa, 'false', NULL, 'tom', 'tom'

I have done this several times for 6.5 servers and excel spread sheets.

Can someone help me out.

Thanks

Tom

[Rayna]

I had the same problem. I had to install SQL*NET on the machine and used the Oracle Config to set up a net service name. Then in the data source would be the net service name. SQL*NET is only available on the Oracle installation CD or you can download a it from Oracle (however it's a 400+ Meg file to download.)


------------
Tom at 6/4/99 8:50:16 AM

I am trying to add a linked server to an Oracle Database on Unix.

I have been able to transfer data to the Oracle database in Unix using Dts. NO problem. But when I set up a linked server I get a 7399: OLE DB provider MSDAORA; reported and error. Can someone help me out please. Here is how I am setting up my linked server

USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver
@server = 'Dev1',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'Dev1'
GO
I then use sp_addlinkedsrvlogin
EXEC sp_addlinkedsrvlogin 'sa, 'false', NULL, 'tom', 'tom'

I have done this several times for 6.5 servers and excel spread sheets.

Can someone help me out.

Thanks

Tom

[tom]

Did you have to have sql net installed on the server or on your local machine?
I was able to transfer using DTS so this makes me think that it is already installed on the server

Thanks


------------
Rayna at 6/4/99 1:40:20 PM

I had the same problem. I had to install SQL*NET on the machine and used the Oracle Config to set up a net service name. Then in the data source would be the net service name. SQL*NET is only available on the Oracle installation CD or you can download a it from Oracle (however it's a 400+ Meg file to download.)


------------
Tom at 6/4/99 8:50:16 AM

I am trying to add a linked server to an Oracle Database on Unix.

I have been able to transfer data to the Oracle database in Unix using Dts. NO problem. But when I set up a linked server I get a 7399: OLE DB provider MSDAORA; reported and error. Can someone help me out please. Here is how I am setting up my linked server

USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver
@server = 'Dev1',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'Dev1'
GO
I then use sp_addlinkedsrvlogin
EXEC sp_addlinkedsrvlogin 'sa, 'false', NULL, 'tom', 'tom'

I have done this several times for 6.5 servers and excel spread sheets.

Can someone help me out.

Thanks

Tom

[Rayna]

I had to install it on the SQL Server. I didn't try it with DTS however.

------------
tom at 6/6/99 4:37:09 PM

Did you have to have sql net installed on the server or on your local machine?
I was able to transfer using DTS so this makes me think that it is already installed on the server

Thanks


------------
Rayna at 6/4/99 1:40:20 PM

I had the same problem. I had to install SQL*NET on the machine and used the Oracle Config to set up a net service name. Then in the data source would be the net service name. SQL*NET is only available on the Oracle installation CD or you can download a it from Oracle (however it's a 400+ Meg file to download.)


------------
Tom at 6/4/99 8:50:16 AM

I am trying to add a linked server to an Oracle Database on Unix.

I have been able to transfer data to the Oracle database in Unix using Dts. NO problem. But when I set up a linked server I get a 7399: OLE DB provider MSDAORA; reported and error. Can someone help me out please. Here is how I am setting up my linked server

USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver
@server = 'Dev1',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'Dev1'
GO
I then use sp_addlinkedsrvlogin
EXEC sp_addlinkedsrvlogin 'sa, 'false', NULL, 'tom', 'tom'

I have done this several times for 6.5 servers and excel spread sheets.

Can someone help me out.

Thanks

Tom