Data Source Name

[AaronRer]

Hi, ____we have a large number of rsw report files and even some older report libraries and want to change the Data Source Name in every report. ____Is there a tool or a way to do this as a batch. Opening every report is a less than desirable solution :D ____thanks

[cstrasser]

You should be able to do this by editing the RSW.INI file and changing the default datasource entry:____[Defaults]__DefaultDataSource=MyDSN__NewReportAlwaysUseSameDS=1__ReadReportAlwaysUseSameDS=0______There will probably be other things in the file under defaults. I^m just showing the basics.____To be safe, make sure the old DSN is renamed or deleted so that the reports can^t find it and have to use the new default.____Also, you might need to look for the file in the "virtual store" instead of the %WINDIR% folder. The virtual store is located at:____%USERPROFILE%Local SettingsVirtualStoreWindows\__

[AaronRer]

Thanks, I^ll give that a go! ____