[RBG7-L] - Re: SAttach Error

[David M. Blocker]

Thom   Look at the syntax of the SCONNECT command - it's looking for BOTH the userid AND the password, which in this case are the same.   Try   SCONNECT DatBase IDENTIFIED BY Money Money   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Thomas J Cimicato To: RBG7-L Mailing List Sent: Thursday, December 30, 2004 10:27 PM Subject: [RBG7-L] - Re: SAttach Error That is correct. The DB I am attached to is owner NONE. The DB I am SCONNECTing to is owner MONEY.   Should they be the same or something? I never thought of that.   Thom   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of David M. Blocker Sent: Thursday, December 30, 2004 8:29 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: SAttach Error   First thought is that the database from which you're connecting has an owner password which is different from the database you're connecting to?   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Thomas J Cimicato To: RBG7-L Mailing List Sent: Thursday, December 30, 2004 6:15 PM Subject: [RBG7-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