Page 1 of 1

SQL Data Sources - R&R SQL 10+

Posted: Thu Feb 19, 2004 2:16 pm
by RKLawton
For a client/server platform, is there a way to specify a SQL connection string in the R&R INI files? ____Or does each workstation need a system data source name (DSN) for R&R to determine the report data source?____Roger

=> SQL Data Sources - R&R SQL 10+

Posted: Fri Feb 20, 2004 8:14 am
by kfleming
The data source is saved with the report.__You can use runtime to override the saved data source with one that existing on the client machine.____Kathleen__R&R Support

==> RE: SQL Data Sources - R&R SQL 10+

Posted: Fri Feb 20, 2004 9:19 am
by RKLawton
So when distributing reports, the client workstations which print the reports do not have to have a DSN?____The report will use the data source stored with the report?____Roger

===> RE: SQL Data Sources - R&R SQL 10+

Posted: Sun Feb 22, 2004 8:28 am
by kfleming
The client machine will need to have a configured data source whose name matches the one saved in the report.__The data source exists externally to R&R. R&R simply remembers its name and information about the tables it contains.____Kathleen__R&R Support