Page 1 of 1
Data Source Name
Posted: Mon May 12, 2014 8:45 pm
by 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
=> RE: Data Source Name
Posted: Wed May 14, 2014 12:27 pm
by 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\__
==> RE: Data Source Name
Posted: Thu May 15, 2014 6:01 pm
by AaronRer
Thanks, I^ll give that a go! ____