Rachael,
Now that you got your "SCONNECT" to work you micht want to
review your "SATTACH" command. You used the syntax "USING ALL".
My basic question is does the table to attach have a PRIMARY or
UNIQUE KEY? If so you should not be the syntax "USING ALL".
The following is from www.rsyntax.com
"USING ALL
Specifies all columns uniquely identify the rows in an attached
table if no primary or unique keys are defined.
USING collist
If the foreign table has no primary or unique key, specifies the
column(s) that uniquely identify the rows in the table."
Jim Bentley
--- Rachael Malberg <[EMAIL PROTECTED]> wrote:
> well it turns out when I copied the SCONNECT syntax from help
> it had...
> SCONNECT ';driver=R:BASE 8.0 Turbo Database Driver
> (*.RX1);dbq=...
>
> I had created an eep and traced this code but never got any
> error on that line. Then I ran the code from the R:Prompt and
> I got an error 'Microsoft ODBC manager can not find driver' so
> I started looking and my v8 driver in ODBC set up is labeled..
> R:BASE 8.0 Database Driver (*.RX1)
> not sure if these are two different drivers or a little help
> typo but I changed my SCONNECT to..
> SCONNECT ';driver=R:BASE 8.0 Database Driver (*.RX1);dbq=...
> and it works like a charm.
>
> Thanks everyone for your help.
>
> Have a Fabulous Day!
> Rachael M.
> Freelance Developer
> www.DragonflyDevelopmentMN.com
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
