Thomas,
Several thoughts. One does the USERID "MONEY" have a password. If so that
may be reason for problem attaching tables. Complete syntax from
www.rsyntax.com follows:
"Syntax
SCONNECT syntax diagram
Options
datasource
Specifies the name of the foreign data source that contains the table you want.
IDENTIFIED BY userid
Specifies your user account name for the foreign data source. You can use ''
(two single quotes) in this position if there is no User ID.
password
Specifies your password for the foreign data source. You can use '' (two single
quotes) in this position if there is no password.
About the SCONNECT Command
If you omit the datasource option, a dialog box opens, listing data sources
from which to choose and continues with prompts for username and password.
SCONNECT command is also supported in EEPs and Stored Procedures."
Second is on SATTACH command. Do you really mean for ALL columns in each table
to be used to uniquely indentify each row. Usually in most schemes each table
has a primary key. Following is part quote from www.rsyntax.com
"AS alias
Specifies a different name for the table while attached in R:BASE.
tblname
Specifies the table in the foreign database to attach.
USING ALL
Specifies all columns uniquely identify the rows in an attached table if no
primary or unique keys are defined.
USING collist
Specifies which columns uniquely identify the rows in an attached table if no
primary or unique keys are defined.
SATTACH requires an owner password if one has been defined, or permission to
create tables."
"R:BASE 2000 (version 6.5++), Build:1.847xRT03 and Higher ...
Enhanced Syntax:
SATTACH [TableName [AS TableAlias] [USING ColumnList] [ALIAS AliasList]]
There are no parentheses around the aliaslist, just names separated by commas.
[AS TableAlias] specifies an alias, or temporary name, for the foreign table.
[USING ColumnList] If the foreign table has no primary or unique key, specifies
the column(s) that uniquely identify the rows in the table.
[ALIAS AliasList] to specify alias names for columns."
Hope this helps.
--
Sincerely,
Jim Bentley
American Celiac Society
266 Midway Dr
River Ridge LA 70123
email: [EMAIL PROTECTED]
Phone: 504-738-6165
-----Original Message-----
From: Thomas J Cimicato <[EMAIL PROTECTED]>
Sent: Thu, 30 Dec 2004 18:15:16 -0500
To: [email protected] (RBASE-L Mailing List)
Subject: [RBASE-L] - SAttach Error
Here are my ODBC statements
SCONNECT DATBASE IDENTIFIED BY MONEY
SATTACH Checks AS DB_Checks USING ALL
SATTACH RCKDATA AS DB_RCKDATA USING ALL
On the SCONNECT I get no error. On each of the SATTACH commands I get
the
following error.
-ERROR- Error message from server: [RBTI][R:BASE ODBC
Driver][DATBASE]-ERROR- Unauthorized access to the table (2039) (2957)
Any thoughts??
Thomas Cimicato
��< h t m l x m l n s : o = " u r n : s c h e m a s - m i c r o s o f t - c o m : o f f i c e : o f f i c e " x m l n s : w = " u r n : s c h e m a s - m i c r o s o f t - c o m : o f f i c e : w o r d " x m l n s = " h t t p : / / w w w . w 3 . o r g / T R / R E C - h t m l 4 0 " >
< h e a d >
< M E T A H T T P - E Q U I V = " C o n t e n t - T y p e " C O N T E N T = " t e x t / h t m l ; c h a r s e t = u s - a s c i i " >
< m e t a n a m e = P r o g I d c o n t e n t = W o r d . D o c u m e n t >
< m e t a n a m e = G e n e r a t o r c o n t e n t = " M i c r o s o f t W o r d 1 0 " >
< m e t a n a m e = O r i g i n a t o r c o n t e n t = " M i c r o s o f t W o r d 1 0 " >
< l i n k r e l = F i l e - L i s t h r e f = " c i d :[EMAIL PROTECTED]" >
< ! - - [ i f g t e m s o 9 ] > < x m l >
< o : O f f i c e D o c u m e n t S e t t i n g s >
< o : D o N o t R e l y O n C S S / >
< / o : O f f i c e D o c u m e n t S e t t i n g s >
< / x m l > < ! [ e n d i f ] - - > < ! - - [ i f g t e m s o 9 ] > < x m l >
< w : W o r d D o c u m e n t >
< w : S p e l l i n g S t a t e > C l e a n < / w : S p e l l i n g S t a t e >
< w : G r a m m a r S t a t e > C l e a n < / w : G r a m m a r S t a t e >
< w : D o c u m e n t K i n d > D o c u m e n t E m a i l < / w : D o c u m e n t K i n d >
< w : E n v e l o p e V i s / >
< w : C o m p a t i b i l i t y >
< w : B r e a k W r a p p e d T a b l e s / >
< w : S n a p T o G r i d I n C e l l / >
< w : W r a p T e x t W i t h P u n c t / >
< w : U s e A s i a n B r e a k R u l e s / >
< / w : C o m p a t i b i l i t y >
< w : B r o w s e r L e v e l > M i c r o s o f t I n t e r n e t E x p l o r e r 4 < / w : B r o w s e r L e v e l >
< / w : W o r d D o c u m e n t >
< / x m l > < ! [ e n d i f ] - - >
< s t y l e >
< ! - -
/ * S t y l e D e f i n i t i o n s * /
p . M s o N o r m a l , l i . M s o N o r m a l , d i v . M s o N o r m a l
{ m s o - s t y l e - p a r e n t : " " ;
m a r g i n : 0 i n ;
m a r g i n - b o t t o m : . 0 0 0 1 p t ;
m s o - p a g i n a t i o n : w i d o w - o r p h a n ;
f o n t - s i z e : 1 2 . 0 p t ;
f o n t - f a m i l y : " T i m e s N e w R o m a n " ;
m s o - f a r e a s t - f o n t - f a m i l y : " T i m e s N e w R o m a n " ; }
a : l i n k , s p a n . M s o H y p e r l i n k
{ c o l o r : b l u e ;
t e x t - d e c o r a t i o n : u n d e r l i n e ;
t e x t - u n d e r l i n e : s i n g l e ; }
a : v i s i t e d , s p a n . M s o H y p e r l i n k F o l l o w e d
{ c o l o r : p u r p l e ;
t e x t - d e c o r a t i o n : u n d e r l i n e ;
t e x t - u n d e r l i n e : s i n g l e ; }
s p a n . E m a i l S t y l e 1 7
{ m s o - s t y l e - t y p e : p e r s o n a l - c o m p o s e ;
m s o - s t y l e - n o s h o w : y e s ;
m s o - a n s i - f o n t - s i z e : 1 0 . 0 p t ;
m s o - b i d i - f o n t - s i z e : 1 0 . 0 p t ;
f o n t - f a m i l y : A r i a l ;
m s o - a s c i i - f o n t - f a m i l y : A r i a l ;
m s o - h a n s i - f o n t - f a m i l y : A r i a l ;
m s o - b i d i - f o n t - f a m i l y : A r i a l ;
c o l o r : w i n d o w t e x t ; }
s p a n . S p e l l E
{ m s o - s t y l e - n a m e : " " ;
m s o - s p l - e : y e s ; }
s p a n . G r a m E
{ m s o - s t y l e - n a m e : " " ;
m s o - g r a m - e : y e s ; }
[EMAIL PROTECTED] S e c t i o n 1
{ s i z e : 8 . 5 i n 1 1 . 0 i n ;
m a r g i n : 1 . 0 i n 1 . 2 5 i n 1 . 0 i n 1 . 2 5 i n ;
m s o - h e a d e r - m a r g i n : . 5 i n ;
m s o - f o o t e r - m a r g i n : . 5 i n ;
m s o - p a p e r - s o u r c e : 0 ; }
d i v . S e c t i o n 1
{ p a g e : S e c t i o n 1 ; }
- - >
< / s t y l e >
< ! - - [ i f g t e m s o 1 0 ] >
< s t y l e >
/ * S t y l e D e f i n i t i o n s * /
t a b l e . M s o N o r m a l T a b l e
{ m s o - s t y l e - n a m e : " T a b l e N o r m a l " ;
m s o - t s t y l e - r o w b a n d - s i z e : 0 ;
m s o - t s t y l e - c o l b a n d - s i z e : 0 ;
m s o - s t y l e - n o s h o w : y e s ;
m s o - s t y l e - p a r e n t : " " ;
m s o - p a d d i n g - a l t : 0 i n 5 . 4 p t 0 i n 5 . 4 p t ;
m s o - p a r a - m a r g i n : 0 i n ;
m s o - p a r a - m a r g i n - b o t t o m : . 0 0 0 1 p t ;
m s o - p a g i n a t i o n : w i d o w - o r p h a n ;
f o n t - s i z e : 1 0 . 0 p t ;
f o n t - f a m i l y : " T i m e s N e w R o m a n " ; }
< / s t y l e >
< ! [ e n d i f ] - - >
< / h e a d >
< b o d y l a n g = E N - U S l i n k = b l u e v l i n k = p u r p l e s t y l e = ' t a b - i n t e r v a l : . 5 i n ' >
< d i v c l a s s = S e c t i o n 1 >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > H e r e
a r e m y O D B C s t a t e m e n t s < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < o : p > & n b s p ; < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < s p a n
s t y l e = ' m s o - s p a c e r u n : y e s ' > & n b s p ; & n b s p ; < / s p a n > S C O N N E C T D A T B A S E I D E N T I F I E D B Y M O N E Y < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < s p a n
s t y l e = ' m s o - s p a c e r u n : y e s ' > & n b s p ; & n b s p ; < / s p a n > S A T T A C H < s p a n c l a s s = G r a m E > C h e c k s < s p a n
s t y l e = ' m s o - s p a c e r u n : y e s ' > & n b s p ; < / s p a n > A S < / s p a n > < s p a n c l a s s = S p e l l E > D B _ C h e c k s < / s p a n > < s p a n
s t y l e = ' m s o - s p a c e r u n : y e s ' > & n b s p ; < / s p a n > U S I N G A L L < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < s p a n
s t y l e = ' m s o - s p a c e r u n : y e s ' > & n b s p ; & n b s p ; < / s p a n > S A T T A C H R C K D A T A A S D B _ R C K D A T A U S I N G A L L < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < o : p > & n b s p ; < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > O n
t h e S C O N N E C T I g e t n o e r r o r . O n e a c h o f t h e S A T T A C H c o m m a n d s I g e t t h e < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < s p a n
c l a s s = G r a m E > < f o n t s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ;
f o n t - f a m i l y : " C o u r i e r N e w " ' > f o l l o w i n g < / s p a n > < / f o n t > < / s p a n > < f o n t s i z e = 2
f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' >
e r r o r . < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < o : p > & n b s p ; < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > - E R R O R -
E r r o r m e s s a g e f r o m s e r v e r : [ R B T I < s p a n c l a s s = G r a m E > ] [ < / s p a n > R : B A S E O D B C D r i v e r ] [ D A T B A S E ] - E R R O R -
U n a u t h o r i z e d a c c e s s t o t h e t a b l e ( 2 0 3 9 ) ( 2 9 5 7 ) < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < o : p > & n b s p ; < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < s p a n
c l a s s = G r a m E > < f o n t s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ;
f o n t - f a m i l y : " C o u r i e r N e w " ' > A n y t h o u g h t s ? ? < / s p a n > < / f o n t > < / s p a n > < f o n t s i z e = 2
f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > < o : p > & n b s p ; < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l s t y l e = ' m s o - l a y o u t - g r i d - a l i g n : n o n e ; t e x t - a u t o s p a c e : n o n e ' > < f o n t
s i z e = 2 f a c e = " C o u r i e r N e w " > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ; f o n t - f a m i l y : " C o u r i e r N e w " ' > T h o m a s
C i m i c a t o < o : p > < / o : p > < / s p a n > < / f o n t > < / p >
< p c l a s s = M s o N o r m a l > < f o n t s i z e = 2 f a c e = A r i a l > < s p a n s t y l e = ' f o n t - s i z e : 1 0 . 0 p t ;
f o n t - f a m i l y : A r i a l ' > < o : p > & n b s p ; < / o : p > < / s p a n > < / f o n t > < / p >
< / d i v >
< / b o d y >
< / h t m l >
