Updating Database connections in Crystal 8.0 1

[MarcusLeBlanc]

Does anyone know how to update database connections in all your reports that you develop locally and move them to another location, that hits another database, without having to reopen them, and reset the connection?

 

[LV]

If you used ODBC connection then create a DSN with the same name on the "move to" machine. It should pick it.

 

[kenhamady]

Sounds like you are not launching reports from VB. In VB you could override the connection info. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[MarcusLeBlanc]

The problem that we have found is that even though we create the same DSN on the new machine, the original report still has the original server name in it when you view the Database connection properties. If we were using VB, we could change it, however, we are using the WCS from Crystal.

Any further suggestions would be great.