|
Thank you very much Chief. It is now working
real great. I appreciate your responsiveness and hints.
BTW, the default date format and date
sequence in OTERRO.CFG are different from the default settings in
RBASE.CFG. Is there a good reason for the difference?
Thanks.
Stan Loo
----- Original Message -----
Sent: Thursday, July 05, 2001 5:13
AM
Subject: Re: Accessing RBase for Windows
6.5+ data from Excel 2000
Aloha Stan,
Those -ERROR- messages are the result
of different
default settings in OTERRO.CFG vs. RBASE.CFG file in
PATH.
Follow these steps to avoid those -ERROR-
messages:
01. Using the Windows explorer, search for OTERRO.CFG
file(s) in PATH.
02. Make sure to keep/copy ONLY ONE OTERRO.CFG
file in
C:\windows
03. Using any text editor, edit OTERRO.CFG file
and make
sure that following settings are as below:
MULTI
ON
TRANSACT OFF
AUTOCOMM OFF
AUTOCONV OFF
AUTORECO OFF
AUTOROWV
OFF
AUTOSYNC OFF
AUTOUPGR OFF
COMPATIB ON
04. Make sure that
above settings in OTERRO.CFG are
consistent with RBASE.CFG file in PATH,
i.e:
MULTI ON
TRANSACT OFF
AUTOCOMM OFF
AUTOCONV
OFF
AUTORECO OFF
AUTOROWV OFF
AUTOSYNC OFF
AUTOUPGR
OFF
COMPATIB ON
05. When using Oterro 2000, I also recommend to keep
default RBASE.CFG in c:\windows.
In that case, you need to edit
RBASE.INI file to
reflect that change,
i.e:
CFGFile=C:\WINDOWS\RBASE.CFG
Also make sure you are only
using one RBASE.CFG
file in PATH.
There you have it
...
Enjoy and make sure to have fun!
Note:
Among many
engine level fixes and enhancements, the
upcoming upgrade version of
Oterro 2000 (ver 2.5),
to be released on July 16, 2001, includes the fix
to create default OTERRO.CFG consistent with RBASE.CFG!
Very Best
Regards,
Razzak.
At 10:41 PM 7/3/2001 -0400, you wrote:
>>>>
What
I want to do is to use Rbase 6.5+ (single user, Build 1.839xRT03) data in
Excel 2000, via Oterro 2.0. I did the following: 1. I
built a Rbase data source (System DSN) in Windows 98 ODBC Data Source
Administrator using Oterro 2.0. I named this data source Rbase4Excel. 2. The Rbase database has the following
ODBC-compliant settings: IDQUOTES `
QUOTES ' PLUS + SEMI ; MANY % SINGLE _
3. In Excel 2000, I selected Data Get External Data -- New Database
Query, and chose Rbase4Excel as the data source. The path
shown is correct for the data source, and I supplied the correct password
for the data source. Upon clicking the OK button, the
following RBase error messages popped up in the MS Query message box: -Error- The database cannot be opened for recovery
(1133) -Error- The current user identifier will not allow
access to any table (2318) When I clicked OK, another
error message said Couldnt read this file. The second
attempt produced the following RBase error messages, shown in the MS Query
message box: -Error- Encountered an invalid transaction
id number (2341) -Error- The database is in a state which
requires the recovery program (2405) I had to go into
RBase and use RECOVER to correct the problem. What did I
do wrong or miss? I appreciate your help in finding and removing this show
stopper. Thanks. Stan Loo
===================================-============================
R:BASE
Developers's Conference: http://www.rbase.com/conference
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.
==================================-=============================
|
