Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2004, 01:38 AM
Registered User
 
Join Date: Jul 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Connection Problem

Hi,

Could some one from this forum please have a look on my problem?
I will greatly appreciate if I get the solution for my problem.

Problem:

I am facing a problem when executing the crystal report on different computers.
I am using an Oracle database 8.1.7.0 with the crystal report version 9 (standard).
I am using different computers, all of these computers have windows 2000 server installed.

With regards to database connection, I am using OLE DB (ADO) as a data source, and then I select the provider (Oracle Provider for OLE DB), then on OLE DB (ADO) tab, I provide the connection information like (Data source > ORA, User Id > SYSTEM, Password> Manager), then I click the next button here I found “Advance Information”, I didn’t change any information here and then click finish in order to establish the database connection.
Then I enter my query via Add command in order to get the particular information.

My Query For Example:
Select empno ,ename, sal,job from scott.emp;

I am getting the correct information when I run the crystal report on the computer where I created this report.

In order to run this report on different computers and get the correct information, I was trying to make some changes in the report.

To do that, I go to Database tab, then go to set data source location. Here we can set the current location which is the location of the computer that I created the report initially that is “ORA”.
 This can then be replaced with the location I have on different computers.

But when I want to replace a location which was “ORA” with new one for example “ORCL” on different computer, I receive a following Error:
“Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables.”

I think I should not save any database connection information with the report as this will be different on every system.

How should we do that so the report which I created with the single sql script can run on different computers and give the correct information.

I will be thankful to you if someone gives me the solution.




Yours sincerely,

Wolfgang Benvort.







Similar Threads
Thread Thread Starter Forum Replies Last Post
[?] A database connection problem Aritra ASP.NET 1.0 and 1.1 Basics 3 August 26th, 2008 02:19 AM
Database Connection Problem vinyl-junkie Classic ASP Databases 2 June 2nd, 2008 03:18 AM
Database Connection Problem murali_vijaya JSP Basics 1 August 5th, 2006 10:10 AM
access database connection problem shaileshk ADO.NET 6 July 5th, 2005 03:30 AM
database connection problem farsfar2 BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 1 March 14th, 2005 06:52 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.