Hi,
I tried to create the linked server to get the oracle data in sql server 2005.So I created server as follows.
right clicked on the linked servers-> new linked server
and the details are
linked server name-> OrclDB
server type-> other data source
provider->Oracle Provider for OLE DB
product name-> oracle
data source->pasdb
provider string->microsoft oledb
and it's get conected (test connection)

And when I tried to query the following

select * from
[OrclDB].oracle.pasdb.[dbo.t_cmd_codn]

(linked_servername.catalog.schema.object_name)


But I am getting the error as

OLE DB provider "MSDAORA" for linked server "OrclDB" 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 "OrclDB" 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 "OrclDB".


It will of very great help if any can provide the cause for this error and query to checkout the table.

Thanks in Advance,
Sowmya