Print Page | Close Window

Problem with Linked SQL Server

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=866
Printed Date: 14 May 2024 at 9:44am


Topic: Problem with Linked SQL Server
Posted By: Mitesh
Subject: Problem with Linked SQL Server
Date Posted: 17 Jun 2007 at 7:35am
Hi all,
 
I am using VS 2003. I am trying to load a report based on view but i am getting  "Failed to open a rowset" error description [DBNETLIB][ConnectionRead(WrapperRead()).] General network error. Check your network documentation.
 
I know the problem and would really appreciate if anyone could point me in right direction.
 
The problem is in the View, it is accessing table from a remote SQL server joined by a linked server. If i remove the reference to remote table from the view i dont get the error message, but otherwise i get above error.
 
 
 
Mitesh


Replies:
Posted By: BrianBischof
Date Posted: 17 Jun 2007 at 9:35am
I can't answer the question, but I wonder if it has to do with a .NET 2003 limitation. I know for CR 10, XI they did a lot of work on the data source libraries and made them more robust for working with complex joins and disconnected joins. I would be curious if this worked better with .NET 2005 b/c it uses the newer drivers. That may not be an option for you (otherwise you would have already upgraded), but that is the only thing that comes to mind.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: Mitesh
Date Posted: 18 Jun 2007 at 2:37am
Thanks Brian for you response and you are right i cant move the application to .Net 2005 as of yet.
 
Any other suggesstions?
 

Posted By: hilfy
Date Posted: 21 Jun 2007 at 4:37pm
What database driver are you using for the report?  ODBC, native MS SQL, or something else?
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window