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

Tried this?

select * from openquery (TEST_LNK,'select * from [t_scsi_cmd_checkCondition]')

Hi,
When I tried , I got the Err as

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".


Actually, I don't understand the prob.
I am not able to fetch the oracle tables through the created linked server, which i Need.....
It would be of very great help if you can provide some suggestion for the same.

Thanks,
Sowmya

I created a new linked server name TEST_LNK_SRV,
That why I changed the query as
select * from openquery (TEST_LNK_SRV,'select * from [t_scsi_cmd_checkCondition]') .....
which gave me the error as stated above...
Thnks,
Sowmya

What's linked server name? You use different name in your query?