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.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
