Razzak, Thanks for the reply. I did check all the settings as you suggested and all looks good. I read the documentation you suggested below as well prior to setting up the ODBC connection. I have tested it and it works for me. Hopefully there will be no "bugs" to work out.
Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, May 14, 2009 11:44 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DSNless connection At 08:22 PM 5/14/2009, Jim Belisle wrote: >RBASE is set up on each individual computer but the database is >set up on a server. If I put a DSN less connection to another >RBASE database in the DAT file for when each user starts up, will >that be a problem? Will there be a conflict in this scenario? >We use the latest 7.6. Jim, Using System DSN or DNS-Less connection, you will have to make sure that a full version of R:BASE 7.6 for Windows is installed using the full installer that installs and configures the R:BASE 7.6 ODBC driver. Use the ODBC Data Source Administrator panel to verify the properly installed R:BASE 7.6 ODBC Drivers. ODBC Data Source Administrator | Drivers ... R:BASE 7.6 ODBC driver should be list as follows: Name: R:BASE 7.6 Database Driver (*.rb1) Version: 7.06.07.3xxxx Company: R:BASE Technologies, Inc. File: RBG76_32.DLL Date: mm/dd/2009 Once the R:BASE 7.6 ODBC driver is installed and configured, you should be able to use the DSN-Less connection to SCONNECT and SATTACH tables as server or TEMPORARY table(s) from another R:BASE database. Here is an example to automate the entire process: -- Assure the connection of primary database IF (CVAL('DATABASE')) <> 'primrydb' OR (CVAL('DATABASE')) IS NULL THEN CONNECT primrydb IDENTIFIED BY NONE ENDIF -- Make sure that previously SATTACHed table is detached SDETACH ALL NOCHECK -- Make sure that the previously DSN-Less Database is Disconnected SDISCONNECT ';Driver=R:BASE 7.6 Database Driver (*.rb1);dbq=seconddb' -- Now Connect the Database Using the DSN-Less Connection SCONNECT ';Driver=R:BASE 7.6 Database Driver (*.rb1);dbq=seconddb' -- SAttach Table(s) SATTACH table1 AS ttable1 USING ALL SATTACH table2 AS ttable2 USING ALL SATTACH table3 AS ttable3 USING ALL -- do what you have to do after SATTACHing R:BASE database tables -- Prior to exiting the application, make sure that all SATTACHed -- table(s) are detached and the DSN-Less Database is Disconnected SDETACH ALL NOCHECK SDISCONNECT ';Driver=R:BASE 7.6 Database Driver (*.rb1);dbq=seconddb' For a technical document with further details, take a look at: From The Edge: http://www.razzak.com/fte/ Article: Using DSN-Less Connections in R:BASE Very Best R:egards, Razzak.
