Reports remembering old DSN !

[huckfinn19]

Hi! I am using Crystal Report 9 and I am having some problems with the DSN I am using.

I've got different computers in my LAN running different MySQL databases. So I need to be able to gather data from different sources with my reports. I am using a User DSN to do this, but I am having a hard time making the reports recognize the new DSN source... Is there an option in the reports that could make them connect to the new DSN every time they are refreshed or something like that? Or is there a better way to gather the data?

thanks...

Simon

 

[pgtek]

hi
if your using a network why not create a system DSN for a user DSN can only be use on the computer that created the report.

cheers

pgtek