MS Sql Linked server error - 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 2005 Forums

Transact-SQL (2005)

MS Sql Linked server error

Author

Topic

carumuga
Posting Yak Master

174 Posts

Posted - 2008-09-29 : 10:43:55

i am joining with a native table in sql server with the output received from openquery.
the query is as follows
SELECT Col1
FROM OPENQUERY(XXX,'
select Col1,col2
FROM Table1') a, temp1 where A.col1 = temp1.col1
Where temp1 is a Sqlserver table, XXX IS MY LINKED SERVER which connects to DB2
BUT I am getting the following error when i execute this

OLE DB provider "MSDASQL" for linked server "xxx" returned message "[NEON][SCOD32.DLL]Host communication failed".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "xxx".

temp1 is having only 200 records
Any help is higly appreciated

CodesMyBusiness
Starting Member

9 Posts

Posted - 2008-09-30 : 08:55:29

From my experiences, when your doing an OPENQUERY, you need to have the right drivers on that machine, as opposed to using Linked Server, where you only need the drivers on the server box. Trying installing the Db2 interface drivers, then re running the query.

Or, find a machine that administrates a Db2 server, where you'll know they have the drivers loaded (for the db management software), and load some query tool on it (SQL buddy for instance), and try it.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-30 : 09:31:30

quote:
Originally posted by CodesMyBusiness

From my experiences, when your doing an OPENQUERY, you need to have the right drivers on that machine, as opposed to using Linked Server, where you only need the drivers on the server box. Trying installing the Db2 interface drivers, then re running the query.

Or, find a machine that administrates a Db2 server, where you'll know they have the drivers loaded (for the db management software), and load some query tool on it (SQL buddy for instance), and try it.

They both use linked server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources