SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Linked Server

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Linked Server
Author Message
sowmyav



Joined: 27 Feb 2009
Posts: 1
Country: India

Post Linked Server Reply with quote
Hi,
I created a linked server.
And facing the Err as follows when I tried to query the table from oracle DB thorugh the linked server.
Could be of very great help .....if you provide me some suggestion which avoids err and fetches the table as needed.

EXEC sp_addlinkedserver
'TEST_LNK_SRV', 'Oracle',
'MSDAORA', 'oracleDW'

EXEC sp_addlinkedsrvlogin 'TEST_LNK_SRV', false,
'sowv', 'RDATA', 'pwd'

till her..it executed and created the linked server named TEST_LNK
And When I tried the below qry

select * from openquery(TEST_LNK_SRV,'select * from ASUP_HDD.dbo.t_checkCondition')

ERR:
OLE DB provider "MSDAORA" for linked server "TEST_LNK_SRV" returned message "ORA-01004: default username feature not supported; logon denied
".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDAORA" for linked server "TEST_LNK_SRV" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "TEST_LNK_SRV".



Thanks in advance,
Sowmya
Fri Feb 27, 2009 7:08 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Reply with quote
And what does it have to do with SQL Assistant product?
Fri Feb 27, 2009 10:02 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.