changing ODBC n DB Name

[vincx]

Hi,

I've quite a number of CR 7 that I developed for use use my VB 6 app. The ODBC n DB Name that I currently use is different from where I'll be deploying my app. Is there a "shorter" way of making the changes so that my reports points to the correct ODBC n DB instead of cnaging it for every report ?


TIA
vincx

 

[StevenK]

I use Delphi to prepare Crystal Reports. You can pass the Crystal Report Database Tables the ODBC-Connection-Name, server-name, user-name + password through the 'SetLogOnInfo' procedure against the tables. My reports run successfully on a number of servers, against differently named databases.
Hope this helps
Steve