[RBASE-L] - Re: SCONNECT/SATTACH - Razzak's Reply

[A. Razzak Memon]

At 07:44 AM 4/15/2004 -0700, William Mason wrote:

I tried the command without continuation characters with no success - the
error message still occurs.  And the command works fine when the table is
part of the database (not an SATTACH'ed table); this code has been running
for a while now.


William,

Make sure that particular workstation has the ODBC driver installed
as well as the System DSN defined accordingly.
In a multi-user environment, server table(s) SATTACHed by someone else
will be displayed as the R:BASE table but you'll have to make sure that
the actual System DSN is also created on that particular workstation.
If all fails, then:

01. SDETACH ALL NOCHECK
    SDISCONNECT dsnname
02. Verify that the ODBC driver is installed as well as the System DSN
    is created accordingly, including the database source and path
03. CONNECT dbname IDENTIFIED BY userid password
    SCONNECT dsnname IDENTIFIED BY userid password
    SATTACH servertablename AS tablealias USING collist ALIAS aliaslist
    SELECT * FROM tablealias WHERE clause ... ORDER BY clause

Hope that helps!

Very Best R:egards,

Razzak.

P.S. Using R:BASE 7.1 for Windows, you can automate the entire process
using the DSN-Less connection!