Page 1 of 1
R&R Sql Data Source Name not Found
Posted: Tue Nov 16, 2004 10:57 am
by Chris_Ransom_(Guest)
Hi,____I^m setting up R&R on a PC that hasn^t previously run it and keep getting Data Source Name not Found errors on reports that have been tried and tested on other machines. I^ve checked the ODBC driver set-up and it looks OK. What else could be causing this?____Chris.
=> R&R Sql Data Source Name not Found
Posted: Tue Nov 16, 2004 10:53 pm
by kfleming
What version of R&R and is this SQL Server? Are you using a DataSource override in the runtime control file or are you indeed using the saved data source?____Kathleen__R&R Support
==> R&R Sql Data Source Name not Found
Posted: Thu Nov 18, 2004 7:05 am
by Chris_Ransom_(Guest)
It^s R&R Ver 9.0 SQL Server version. I^m not using anything pre-set or saved in the report - I can select the data source when I open the report but it then tells me it doesn^t exist.
==> R&R Sql Data Source Name not Found
Posted: Thu Nov 18, 2004 8:06 am
by Chris_Ransom_(Guest)
In your RSW.INI add a section named Database. And in that section add a line that says:__UseQEconnect=1____That should take care of the problem.____Kathleen__R&R Support
===> R&R Sql Data Source Name not Found
Posted: Thu Nov 18, 2004 8:08 am
by kfleming
Thanks Kathleen - that worked perfectly.____>In your RSW.INI add a section named Database. And in that __>section add a line that says: __>UseQEconnect=1 __>__>That should take care of the problem. __>__>Kathleen __>R&R Support __
====> R&R Sql Data Source Name not Found
Posted: Thu Nov 18, 2004 11:59 am
by Chris_Ransom_(Guest)
Interestingly the same ODBC driver setup did work OK when I tried to import data into Excel as a test.