Set DSN at Runtime

[groasa]

Help! In need of ideas!!

I've searched through some past threads and have only found info on passing the database location through a front end.

Is it possible to indicate different ODBC DSN's through an INI file?

Maybe you might have other ideas if you see the scenario. We are converting our old Btrieve files to ODBC-compliant Pervasive.SQL. Previously, we set up our report database location as "Same as report". Different databases are held in separate directories, thus the same reports were duplicated in each directory. In some archival cases, whole directories (including the reports) are copied to new directories. Now, we will be converting the reports to CR 8.5 using ODBC. All the different directories will have different DSN's. Is there some way to get the reports to point to the correct DSN? Are we going to have to set up a front end? If so, what would be the easiest/least painful way?

Any ideas would be greatly appreciated!!!

 

[dgillz]

I beleive the only way to do this is through VB. If there is a way to prompt for the DSN or location and then execute the report I would love to know it.
Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[bburnell]

Hi,
dgillz is right. VB is the easiest way. I do it all the time. It's not the only way though. You can also do it through the other languages (C++, Java, Javascript, etc...) CR supports also. I hope this helps!
Brett (smsforce) E-mail me at smsforce@smsforce.com

Please visit my websites!

http://www.smsforce.com

http://geocities.com/emushoppe