that did it! Thanks everyone!
Okay I read I can do a DSN less connection but I can't get it to work. I'm
fine with a User or System ODBC set up but without one I'm always prompted
to record one when I issue a SATTACH (table)
here's my SCONNECT syntax (and the userid and password is set to correct
values in my testing file)
SCONNECT ';driver=R:BASE 8.0 Turbo Database Driver
(*.RX1);dbq=C:\RBTI\RBG8\D2_Applications\highwaRe\Development_Version\ScanDocs;uid=userid;pwd=password;'
----- Original Message -----
From: "Emmitt Dove" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, May 14, 2008 8:58 AM
Subject: [RBASE-L] - RE: Trying to SCONNECT a database but get this error...
Rachael,
You need this:
SET SINGLE='_'
... instead of:
SET SINGLE='*'
Emmitt Dove
Manager, DairyPak Business Systems
Evergreen Packaging, Inc.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(203) 643-8022
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rachael
Malberg
Sent: Wednesday, May 14, 2008 9:31 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Trying to SCONNECT a database but get this error...
-ERROR - Set quote _wildcard to ' and % _before connecting to a server.
(1037)
could anyone send me these settings syntax? I'm alittle confused on
exactly
what they are. My current setting syntax I do before trying to connect
is..
SET QUOTES=NULL
SET QUOTES='
SET DELIMIT=NULL
SET DELIMIT=','
SET LINEEND=NULL
SET LINEEND='^'
SET SEMI=NULL
SET SEMI=';'
SET PLUS=NULL
SET PLUS='+'
SET SINGLE=NULL
SET SINGLE='*'
SET MANY=NULL
SET MANY='%'
SET IDQUOTES=NULL
SET IDQUOTES='`'
Thanks, ~Rach
