Problems while trying switch DSNs

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Gary_Loftus
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Problems while trying switch DSNs

Post by Gary_Loftus » Thu Jul 11, 2002 7:39 am

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

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Problems while trying switch DSNs

Post by kfleming » Thu Jul 11, 2002 11:55 am

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

Post Reply