Thanks Paul. I'll double check that the DSN's are System. What ODBC driver are you using?
Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Paul Buckley Sent: Tuesday, April 14, 2009 12:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Compiler Dennis, I have a 7.6 compiled app that has been running for a couple of years that accesses a SQL database. Like yourself, I have the SQL tables attached permanently in Rbase and I use a System DSN on each workstation. They don't even have a license of Rbase in house and I have no problems accessing data. I can read from and write to the SQL tables. Paul Buckley From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Tuesday, April 14, 2009 1:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Compiler We cannot execute the SATTACH at run time because we run with staticdb on. If we did so, the data would be created as a temporary tables and we have found that to be way slow as the source data is very large. We have the foreign tables SATTACHED permanently. We do create the DSN on each computer. Perhaps we should try creating the permanent connections DSN-Less, although I can't imagine why this would make a difference. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Tuesday, April 14, 2009 12:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Compiler Dennis: I have no problems accessing other databases from a compiled application using DSN-less connections, where the SCONNECT and SATTACH as well as the SDETACH and SDISCONNECT are executed at run time. You would have this issue only if the application is trying to access another R:Base database as the Compiler and/or Compiled applications do not install the R:Base ODBC driver; this driver is installed only when the full version of R:Base is installed. However, if you are accessing a SQL Server, you should not have this problem provided you have the SQL drivers properly installed. Ironic that you can readily access other databases from a compiled application but to access another R:Base database you have to use Oterro...oh well... Javier, Javier Valencia 913-915-3137 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Tuesday, April 14, 2009 11:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Compiler I'm having an issue with the compiler. Perhaps someone has a fix. I have a DB with sattached tables (actually views) from SQL Server. Running the same compiled EXE (starting in the EXE directory with -A switch) On some computers the data is available, on others no rows are returned. The pattern seems to be if full RBASE 7.6 is installed the data is available, otherwise not. Thanks for any feedback, Dennis McGrath
