Data Source Name

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
AaronRer
Posts: 2
Joined: Fri Feb 09, 2018 11:21 pm

Data Source Name

Post by AaronRer » Mon May 12, 2014 8:45 pm

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

User avatar
cstrasser
Posts: 155
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Data Source Name

Post by cstrasser » Wed May 14, 2014 12:27 pm

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\__
Chris Strasser
Liveware Publishing, Inc.
Work bigger.

AaronRer
Posts: 2
Joined: Fri Feb 09, 2018 11:21 pm

==> RE: Data Source Name

Post by AaronRer » Thu May 15, 2014 6:01 pm

Thanks, I^ll give that a go! ____

Post Reply