linked servers on 64bit - 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

General SQL Server Forums

New to SQL Server Administration

linked servers on 64bit

Author

Topic

FrancoMo
Starting Member

2 Posts

Posted - 2012-06-18 : 10:42:12

hi, I have a problem with SQL2012 on windows 2088 64bit: I linked few database as "linked server", I can see the table catalog for each of them, but if I try to select using OPENQUERY I obtain the error:

Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "TRIAL".

can You help me?

thanks

FrancoMo
Starting Member

2 Posts

Posted - 2012-06-18 : 11:11:27

sorry, I mean windows server 2008 64bit

Sachin.Nand

2937 Posts

Posted - 2012-06-19 : 04:19:08

Is there anything logged in the sql server error logs ?

Only free men can negotiate..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources