executing the created linked server-Err

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

executing the created linked server-Err

Author

Topic

sowmyav
Starting Member

34 Posts

Posted - 2009-02-26 : 01:22:30

Hi,
I created a new linked server named TEST_SQL.And the properties are as follows
In the General Tab
Linked server-> TEST_SQL
SErver type-> Other data source
Provider-> Oracle Provider for OLE DB
Product Name -> Oracle
Datasource -> PASDW
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 [TEST_SQL].[ASUP_HDD].[dbo].[t_scsi_cmd_checkCondition]

ERR:
OLE DB provider "OraOLEDB.Oracle" for linked server "TEST_SQL" returned message "ORA-01017: invalid username/password; logon denied".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TEST_SQL".

AS I am new to sql server, I am not able to make out the Err cause.Could anyone please help me on the same.

Thanks,
Sowmya

ashishashish
Constraint Violating Yak Guru

408 Posts

Posted - 2009-02-26 : 01:56:36

May Be This Will Help You...........

I Dunn Understand wat u exactly want But May Br This Will Help You......

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117557

sowmyav
Starting Member

34 Posts

Posted - 2009-02-26 : 02:16:20

Thanks!
I looked the same.It was helpful.
I created the Linked server through the GUI instead of EXec....statements
anyway it is created as TEST_SQL
Now I wanted to fetch the data in the oracle db through linked server.
as select * from openquery (TEST_SQL,'select * from [ASUP_HDD].[dbo].[t_scsi_cmd_checkCondition]')
but I am getting the error msg

OLE DB provider "OraOLEDB.Oracle" for linked server "TEST_SQL" returned message "ORA-01017: invalid username/password; logon denied".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TEST_SQL".

please let me know what should be done now?

sowmyav
Starting Member

34 Posts

Posted - 2009-02-26 : 03:41:18

Hi, I Checked out the Err.
And i tried by creating another linked server for which I got the Err msg for the query as

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

It could me helpful for me if somebody help to fetch the needed table through linked server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources