-
linked server-fetching the table
Hi ,
I created the linked server through GUI in sql server 2005 as
Linked server-> TEST_LNK
SErver type-> Other data source
Provider-> Oracle Provider for OLE DB
Product Name -> Oracle
Datasource -> PASDW/oracle Express Edition
Provider string ->Microsoft OLE DB
And Security Tab
details are given for local login/ Remoteruser/pwd and the be madeusing the
login's current security context
and the SErver options tab
the first 5 are set to true and last 2 are set to 0.
And When I tried to EXEC the same as follows, I am getting the Error
select * from openquery (TEST_LNK,'select * from [ASUP_HDD].[dbo].[t_scsi_cmd_checkCondition]')
ERR:
OLE DB provider "MSDAORA" for linked server "TEST_LNK" returned message "ORA-12154: TNS:could not resolve the connect identifier specified
".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "TEST_LNK".
Waiting for the reply as I am new to sql server.I need to check out the table which is oracle db through the linked server,whetehr it's posible?
And whether i need to give any username/pwd to map the orcle db?
Please le tme know...
Thanks and REgards,
Sowmya
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|