SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 linked servers on 64bit		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

FrancoMo
Starting Member

Italy
2 Posts
Posted - 06/18/2012 :  10:42:12  Show Profile  Reply with Quote
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

Italy
2 Posts
Posted - 06/18/2012 :  11:11:27  Show Profile  Reply with Quote
sorry, I mean windows server 2008 64bit
Go to Top of Page

Sachin.Nand
Flowing Fount of Yak Knowledge

2937 Posts
Posted - 06/19/2012 :  04:19:08  Show Profile  Reply with Quote
Is there anything logged in the sql server error logs ?

Only free men can negotiate..
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000