Error LinkServer SQLServer To Oracle

Hi,

I have setup a linked server that crashes.

It connects to an Oracle 9i Database on an application client for Oracle
(Toad). My tnsnames.ora file is correct does periodically work

I am not sure what triggers it but it crashes and gives the following error:

Error 7399: OLE DB provider 'MSDAORA' reported an error. The provider did
not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: The provider did not give any information about the
error.].

Can anyone help with this please ?

Which is the correct configuration in terms of drivers to use and vendor.
Are there any registry settings that need changing?

I'm trying to connect to Oracle 10g database for Linux

My configuration script:

sp_addlinkedserver @server='DESA',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'ORALDES1'

sp_addlinkedsrvlogin @rmtsrvname='DESA',
@useself='false',
@locallogin='channel-estandar',
@rmtuser='cif_exp',
@rmtpassword='cif_exp'


Thanks you,
Omar

Es dificil saber donde está el problema debido a que el driver no le brinda
información detallada del problema. Le recomiendo que revise cuidadosamente
los pasois de configuración, use estos artículos:

How to set up and troubleshoot a linked server to an Oracle database in SQL
Server
http://support.microsoft.com/kb/280106

Setting Up an Oracle Linked Server
http://www.sqlmag.com/Articles/Arti....html?Ad=1

Gustavo Larriera, Microsoft MVP
https://mvp.support.microsoft.com/p...o.larriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Omar" wrote:

> Hi,
>
> I have setup a linked server that crashes.
>
> It connects to an Oracle 9i Database on an application client for Oracle
> (Toad). My tnsnames.ora file is correct does periodically work
>
> I am not sure what triggers it but it crashes and gives the following error:
>
> Error 7399: OLE DB provider 'MSDAORA' reported an error. The provider did
> not give any information about the error.
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005: The provider did not give any information about the
> error.].
>
> Can anyone help with this please ?
>
> Which is the correct configuration in terms of drivers to use and vendor.
> Are there any registry settings that need changing?
>
> I'm trying to connect to Oracle 10g database for Linux
>
> My configuration script:
>
> sp_addlinkedserver @server='DESA',
> @srvproduct = 'Oracle',
> @provider = 'MSDAORA',
> @datasrc = 'ORALDES1'
>
> sp_addlinkedsrvlogin @rmtsrvname='DESA',
> @useself='false',
> @locallogin='channel-estandar',
> @rmtuser='cif_exp',
> @rmtpassword='cif_exp'
>
>
> Thanks you,
> Omar
>