Thanks Razzack
I am afraid that doesn't solve the problem:
If I try to access the data in the "sattached" table either by EDIT, INSERT
OR SET V this error message appears:
"Invalid RBase CFG Command StaticDB off"
The error message dialog box is Captioned "RBase ODBC
Driver"
This box comes up regardless of whether staticDB is on or off and regardless
of whether error messages are set to off.
Next the RBase Connect form, that I completed when setting up the Data
Source, appears asking for the User ID and password for the data source even
though the
user id was set up in the opening connect commands. Once I have entered the
User ID and password everything is fine and data can be accessed throughout
the session. But the next time the database is connected you have to go
through this initial, and for the user: confusing, routine.
Is this problem solved in 6.5++ ?
Any help would be much appreciated
John Dew
-----Original Message-----
From: A. Razzak Memon [mailto:[EMAIL PROTECTED]]
Sent: September 18, 2001 11:02 PM
To: [EMAIL PROTECTED]
Subject: Re: FW: Problems with SCONNECT - Razzak's Reply
At 07:41 AM 9/18/01 -0700, John Dew wrote:
>
>What do I have to do to eliminate the initial Dialog Box
>and how do I automatically set up the Data Source User ID ?
>
>I am using RBase 6.5+ Build 1.839 RT03
John,
First, the effect of having STATICDB set ON is that no
schema changes can occur during that connection session.
If you would like to eliminate the initial dialog and
automatically set up the data source, then:
SET STATICDB ON
CONNect DBName
SCONNect DataSourceName IDENTIFIED BY NONE
SATTACH DataSourceTableName AS DataSourceTableName USING ALL
OR
SATTACH DataSourceTableName AS AliasTableName USING ALL
If you DISConnect the database, make sure to use:
CONNect DBName
SCONNect DataSourceName IDENTIFIED BY NONE
before you access the SATTACHed DataSourceTableName!
Note:
With STATICDB ON and SERVER Table(s) attached, you CANNOT use
SDETACH ALL command. You will need to use:
SDETACH DataSourceTableName
(one at a time)
Have Fun!
Very Best Regards,
Razzak.
PS. TGRB2000 (ver 6.5++) for Windows includes the updated R:BASE
2000 for Windows ODBC driver!
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
