Page 1 of 1
Data source name not found error
Posted: Mon Apr 07, 2003 12:08 pm
by JBillard
I have written many RRSQL reports for a customer that went against a MS SQL 6.5 database. They have recently upgraded the base application and as a result also upgraded from MS SQL 6.5 to MS SQL 7. Now when they try to run reports against the new SQL 7 database they get the "Data source name not found and no default driver specified" error message.____Is there some conversion needed to get the reports to run against the new database?____Any help on this will be greatly appreciated as I really don^t want to have to rewrite all these reports.____RRSQL is version 9.
=> Data source name not found error
Posted: Mon Apr 07, 2003 4:53 pm
by kfleming
In your c:windowsRSW.INI file add a section named Database.__(It will be a line with an open square bracket Database close square bracket. The forum software will not let me enter this though...)____Within that section add a line that says:__UseQEConnect=1____Save the file, restart R&R and see if it helps.____Kathleen__R&R Support
==> RE: Data source name not found err
Posted: Mon Apr 07, 2003 7:06 pm
by JBillard
That did the trick.____Thank you very much.____PS: What exactly does that entry do?____Jim B.__
===> RE: Data source name not found err
Posted: Tue Apr 08, 2003 8:16 am
by kfleming
It modifies the way that internal ODBC calls are made.____Kathleen__R&R Support