Database Connection Problem
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.
I am facing a problem when executing the crystal report on different computers.
I am using an Oracle database 184.108.40.206 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.