Changing ODBC DB

[dtrumbower]

Is there any easy way to change a couple hundred reports's database connections?

Currently the reports are using an odbc connection to a test db, when its time to go to prod, the odbc name will change.

Also, I will be using eportfolio. Don't know if this might to the connection for me.

Thanks

 

[DiggerDog]

Hi

I copied thie following from Crystal reports online help (provided with Crystal Reports) - I hope it's what your' looking for

Changing the ODBC data source accessed by a report
Tip: Another way to change a data source is to use the Convert Database Driver option found on the Database menu.

Choose Set Location from the Database menu.
The Set Location dialog box appears with a list of table aliases for the tables displayed in the report and will display the locations and logon information for the table you select below the list of tables.



Highlight the first table in this list box.
Click Set Location.
Choose the original ODBC data source to log on if you are not logged on already. You must log on to the old data source before you can modify a report to use a new data source. Since you must be logged on to the old data source, the old data source must be available on the local machine.
If the machine is no longer connected to the old server, you can install an ODBC data source with the name of the old data source and have it point to the new database server. Log on to this data source as you would log on to the "old" data source.
If you are using the same data source name to connect to a new server, you must configure that data source in the ODBC Data Source Administrator (found in the Control Panel), and make it point to the new server.
After you log on to the old data source, double-click it so the list of tables appears in the Data Explorer dialog box.

Choose the new data source within the Data Explorer dialog box to log on.
You should now be logged on to both the old and the new data sources.

Double-click the new data source to display its tables, then select the appropriate table from this list. The table you choose should correspond to the first table you selected in the Set Location dialog box.
After clicking Set the program prompts you to change the location of all tables in the report to the location you specified for the first table.


Click Yes to set the location of all tables in the report to the same database.
Close the Set Location dialog box, and choose Verify Database from the Database menu to refresh the table definitions in the report.
Log off the old data source.
Save the report.

 

[SFLLC]

If you don't mind a third party utility, our new .rpt Inspector 2 Professional Suite now comes in two editions. One that supports CR5.x-CR8.5 and one that supports CR9.x. Everything else in the two editions is the same. Including support of a new "data source / database conversion and migration wizard" which allows you to select one or more reports and select multiple sources to a destination for set location, convert driver, verify database. And we support ODBC / OLE DB / Native DB2 / Native Informix / Native Oracle / Native SQL Server / Native Sybase.

Both editions are now available for a FREE 30-day trial download.

Software Forces, LLC

http://www.softwareforces.com

===> two editions released: ".rpt Inspector 2 Professional Suite (for CR5.x-CR8.5)" and ".rpt Inspector 2 Professional Suite (for CR9.x)"
=====> download your FREE 30-day trial today!

proud makers of ".rpt Inspector" brand for Crystal Reports,
"SPL (Smart Pick Lists)" for Crystal Enterprise, and "SmartObjects" for Seagate Info & Crystal Enterprise.

Coming soon ".rpt Inspector 3 Enterprise Suite" for Crystal Enterprise