How i do to change a database in the crystal 8 ? 1

[apimenta]

All right guys? I have been try to changed the database of my reports. The original database is the same of a new database i want to use. But, when add the new database, and refresh, verify database and etc.. my reports return errors: " No rowset was returned for this table, query or procedure" and famous error "Error detected by database DLL"
What is it wrong? How i do to change a database in a report without have troubles? Please , help me! I need a answer urgent!

 

[jflmeing]

How are you connecting the database to the report?

To change databases, you will have to go to the Database/Set Location menu. Locate the connection method and point to the new database.

 

[boxster87]

What type of database is it (Access, SQL Server, dbase, etc.)?

Re: the "Error detected by database dll" error - you might need to download the database driver update from Crystal. It resolved an issue I was having with the same error message in relation to a dbase table used in my report.

You can download the update here:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/dbexdrvr.zip.asp

These error messages can also occur if you're using a MS Excel spreadsheet as the data source and the Excel file was moved or renamed.

If all else fails, try renaming the database, reset the location and see if that resolves the issue. If it does work and you need the database to have the original name, change it back, reset the location, etc.

Good luck!

 

[apimenta]

I using SQL Server 2000 database

 

[chumki]

The problem may be due to Crystal Report data buffering with the SQL server stored procedure returned data.

Crystal Report logs the errors that it encounters during the run of a stored proc. in a file "SQLSvr.err" in C:\WINNT\Crystal folder (may be different for different installation), You can look into the error and get the idea to rectify the stored proc accordingly. It may happen that the stored proc is running smooth in Query Analyzer without logging even any warning, but crystal report may log any particular error (for e.g. int field is getting NULL value, or Case structure etc.) in case it cannot handle any specific point. In that case we need to take necessary action in the stored proc according to the logged error in SQLSvr.err.

In addition to this you should follow the proper process of changing the database.
Go to Database->setLocation->Press set location tab->More Data Sources->Microsoft SQLServer->Enter Server, User Id, password and choose the database->select the SP you want->click Set->click Done

Best of luck!

 

[apimenta]

Here i am using:

Visual Basic 6(SP5), Crystal Reports 8 and SQL Server 2000
Have 4 databases in 2 servers(2 databases in each server)
Only a database happens this troubles.

The database source and set location have already been configured correctly. In the crystal reports designer, the report runs without troubles. But, when it runs in VB6
by project, happen this errors. The report has 2 sub reports. This report received data from a temporary table and not using stored procedure.
Thanks for all msgs, and continue trying to find a answer.

 

[NNR]

I have been try to changed the database of my reports. The original database is the same of a new database i want to use. But, when add the new database, and refresh, verify database and etc.. my reports return errors: " No rowset was returned for this table, query or procedure" and famous error "Error detected by database DLL"
What is it wrong? How i do to change a database in a report without have troubles? Please , help me! I need a answer urgent!