Data source name not found error

[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.

[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

[JBillard]

That did the trick.____Thank you very much.____PS: What exactly does that entry do?____Jim B.__

[kfleming]

It modifies the way that internal ODBC calls are made.____Kathleen__R&R Support