Forums Últimos mensajes - Powered by IBM
 
Tags Palabras claves

Error LinkServer SQLServer To Oracle

13/05/2008 - 16:44 por Omar | Informe spam
Ayuda Hacer una pregunta
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
email Siga el debateRespuesta 2 respuestasRespuesta Tengo una respuesta
DRAGON AGE™: INQUISITION – Matadragones
 

Leer las respuestas

#1 Gux (MVP)
13/05/2008 - 16:51 | Informe spam
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

Preguntas similares

 

Busqueda sugerida :