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