Hi,
I am using Crystal reports XI and oracle as the database.
I have developed a crystal reports in develpment environment. Now I want to deploy/move this report to another environment.
When I go to Database Extpert - Set Datasource Location and try to to update the datasource (which is an oracle stored procedure in my case)
I get an error:
Data object cannot be opened/accessed.
I am using Microsoft OLE DB Provider for Oracle driver to connect to Oracle database.
The Set Data source Location command provides a simple way to indicate the new name or location of database files. This is especially useful if someone sends you a report that uses a database that has a different location on your system, or if you have changed the directory or disk location of a database. or moving the report from one environment to another environment In addition, the Set Data source Location command automatically converts your database driver to the data source you have chosen. For example, you can automatically convert a direct access data source to an ODBC data source using the Set Location command.
Go to Database menu | Set Datasource Location | Set Datasource Location window appears.
Change the location of the data source by selecting the current database (or table) and choosing the data base (or table) to replace with it . then click update.
Click Close to close the Set Datasource Location window.
Please ensure that you need to Verify Database immediately after setting datasource location for the report. In order to do Verify Database from Crystal Reports, please follow the steps given below:
Go to Database menu | Verify Database
A message stating Database is up to date would appear. Let me know if you are facing error messages during this process.
Check with database admin, do u have all the rights to access the diffrent environment database or not . if you are having try to create a sample report from the datasource.
Also compare the strored procedure with old database.
I think I have the necessary access rights.
If I can a seperate reports in these environments. i.e. I can create report using the both the stored procedures (the one which I want to replace and the one which I am going to replace)
Can you please tell me what access rights and on which database objects is required so that I can update the datasource.
Ensure that the version of MDAC you are using should be 2.8 (Minimum). To do this, the procedure is as follows:
1.Click the ‘Start’ button, and then click ‘Run’.
2.Type ‘regedit’ (without quotes), and press ENTER. The Registry Editor appears.
3.Expand the HKEY_LOCAL_MACHINE subtree to the following registry subkey:
4.In the right pane, right-click the Version entry and select ‘Modify’. Check the version in the ‘Value Data’ text box
5.Click ‘OK’ and close the Registry Editor.
On the other hand, to know the version, check the MDACReadme.htm" or use Microsoft’s MDAC Component Checker. For more information, check the following link:
update the MDAC version of your system from the below given link:
I tried to install the MDAC 2.8. It gives me message “MDAC 2.8 is incompatible with this version of windows. All its required features are installed with this version of windows”
It should work with MDAC2.8 onlly so contact your system admin to install the MDAC2.8 in your machine , might be if u install any patch for that windows it wil allow u to install MDAC 2.8 ,
Meanwhile I would suggest you to check the OLE DB connection to your database from outside of Crystal Reports.
Please download the QTADO testing tool from the following URL:
The issue is with Crystal reports driver and oracle drivers are compatible that u r using ,
Please confirm that you are using CR data direct driver that is recommended one , try with that and let me know.
I have downloaded the Datadirect driver and installed it on my local machine.
I was successfull in creating reports and overcome my issues regarding connectivity.
However when tried to deploy the report on the crystal report server,
I got an error
“failed to open connection Database Vendor Code: 12154”
I installed the driver on the crystal report server machine.
Creatde a DSN through Administrative tools.
Deployed the report (created on my local machine) through publishing wizard on the crystal report server.
Through CMC, i changed the database driver information to oracle.I also tried keeping the original settings and also gave the same name which i created DSN with.
but still could not generate the report.
Can u please tell me how to setup the Datadirect driver through CMS or any other way?
