Linked Server problem - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Linked Server problem

Author

Topic

Kutty
Starting Member

3 Posts

Posted - 2004-07-09 : 12:45:02

I am facing some problem in accessing the tables in linked server.

I have a linked server, which is Oracle, and i have configured the TNSNames.ORA file and it is working fine in SQLPLUS.

When i try to fire query against the linked server it is showing error.

Is any one has any idea about this problem.

chadmat
The Chadinator

1974 Posts

Posted - 2004-07-09 : 13:01:09

The error would help.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

Kristen
Test

22859 Posts

Posted - 2004-07-09 : 13:05:32

I know very little about it, but in case it helps the queries we do to PULL data from Oracle into SQL are along the lines of


SELECT @strSQL = 
'SELECT *
FROM	OPENQUERY(MyOracleLinkedServer, 
''
SELECT	*
FROM	OracleDatabase.OracleTable
'')'
EXEC (@strSQL)

Kutty
Starting Member

3 Posts

Posted - 2004-07-09 : 14:16:03

Error: 7399 OLEDB Provider 'MSDAORA' Reported an Error.
- When i click on Security ->Linked servers-->servername-->Tables

Kutty
Starting Member

3 Posts

Posted - 2004-07-09 : 14:18:35

I have the same configuration working in other environment such as Testing or Production. Only problem in one server.

I am using the Same TNSNAMES.ORA file from production server but still iam getting error. So what may be the cause.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources