R&R SQL Edition ODBC Error

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

R&R SQL Edition ODBC Error

Post by jstiegler » Sun Jul 27, 2008 9:14 am

While my report runs fine in R&R SQL designer, I receive an error when I try to run the report in Visual Basic 6.____The error I receive is:____"DB access[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"____Any help would be appreciated. We are using R&R SQL Edition v11.

jstiegler
Posts: 23
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: R&R SQL Edition ODBC Error

Post by jstiegler » Mon Jul 28, 2008 9:13 am

Yes. The report runs fine when I use either rsw.exe or rswrun.exe.____If I use the latter I must manually select the Access Database. If I use rsw.exe then I don^t have to select the Access Database.____Might RSWSQL.ini be the source of the problem?__

jstiegler
Posts: 23
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: R&R SQL Edition ODBC Error

Post by jstiegler » Mon Jul 28, 2008 9:13 am

If the datasource has been set up to point to the MDB file, you should not need to select it when you run the report using rswrun.exe.____I just tried two test reports using access data sources and as long as the mdb was selected when the data source was configured in the ODBC manager, it works fine for me.____What you can try is adding a section called DATABASE to your c:windows sw.ini file. In that section add the line:__USEQECONNECT=1__and see if that helps.____Are you running the OCX from the same development machine as rsw.exe?____Kathleen__R&R Support

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

=> RE: R&R SQL Edition ODBC Error

Post by kfleming » Mon Jul 28, 2008 9:15 am

If you double click execute RSW.EXE and select the report does it run without an error?____Kathleen__R&R Support

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

===> RE: R&R SQL Edition ODBC Error

Post by kfleming » Tue Jul 29, 2008 9:26 am

__>Are you running the OCX from the same development machine as __>rsw.exe? __>__>Kathleen __>R&R Support ____Yes I am. The R&R SQL OCX cannot find the Access driver. My app conntects to the Access database just fine. But the OCX control does not. Dunno why.

jstiegler
Posts: 23
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: R&R SQL Edition ODBC Error

Post by jstiegler » Tue Jul 29, 2008 10:10 am

I solved the problem. It is not clear from your manuals what the term DataSource means.____I was using the DataSource parameter as the name of the Access database, i.e. Client.mdb. In fact, DataSource means DataSourceType. When I replaced "Client.mdb" with "MS Access Database", the report works fine.____I guess I am just a noob. Sorry to have wasted your time on this.

jstiegler
Posts: 23
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: R&R SQL Edition ODBC Error

Post by jstiegler » Tue Jul 29, 2008 10:10 am

>If you double click execute RSW.EXE and select the report __>does it run without an error? __>__>Kathleen __>R&R Support ____Yes. This works fine. I receive this error only from inside my application using the OCX control with an Access database.____We have been using VB with foxpro files for years, but are now moving to Access. Unfortunately, the SQL edition does not work for us.

Post Reply