OraFAQ Forum: Networking and Gateways » Using Linked Server from sql server client to oracle

Home » RDBMS Server » Networking and Gateways » Using Linked Server from sql server client to oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using Linked Server from sql server client to oracle [message #66973]

Mon, 05 May 2003 10:09

Bhagwan Singh
Messages: 23
Registered: December 2001

Junior Member

Hi,
Iam trying to access an oracle table remotedly using sql server client..
sql server has something like sp_addlinkedserver system procedures.But when I try to access it I get the following error..

OLE DB provider 'MSDAORA' reported an error.
[[OLE/DB provider returned message: ORA-12640: Authentication adapter initialization failed
]]

Can someone please send me step by step approach?
Its urgent..
Bhagwan

Report message to a moderator

Re: Using Linked Server from sql server client to oracle [message #67665 is a reply to message #66973]

Sun, 19 December 2004 04:04

WAEL
Messages: 3
Registered: January 2004

Junior Member

Hi,
Iam trying to access an oracle table remotedly using sql server client..
sql server has something like sp_addlinkedserver system procedures.But when I try to access it I get the following error..
OLE DB provider 'MSDAORA' reported an error.
[[OLE/DB provider returned message: ORA-12640: Authentication adapter initialization failed
]]

Can someone please send me step by step approach?

Report message to a moderator

Previous Topic:	Connectivity problem from vb6 using msdaora
Next Topic:	failover configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 12:36:59 CDT 2024