Problems while trying switch DSNs
-
- Posts: 1
- Joined: Tue Oct 10, 2017 12:44 pm
Problems while trying switch DSNs
I am trying to make a copy of a report so I can use a different database but each time I link the report to the new DSN I get the following error message :-____DB Access: [Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified____I have loads of reports to switch and it would take a very long time to re-write them. ____Can anyone help please?____thanks____Gary
=> Problems while trying switch DSNs
In your c:windows
sw.ini file add a section called____Database__(note that this entry needs to be surrounded in square brackets but the forum software strips these out when you try to enter them)____and in this section add a line that says:____UseQEConnect=1____Save the file, re-start R&R and the problem will hopefully disappear.____Kathleen__R&R Support