-
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]')
-
Re
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?
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
|
|