well I added the RX1 and I'm still getting the prompt to select the data
source when I issue...
SATTACH CustomerScannedDocs AS tCustomerScannedDocs USING ALL
so now my entire syntax is as follows (and I tried the username/password
with in this syntax and ;uid=userid;pwd=password; syntax with the same
results...
SDISCONNECT ScanDocs
SCONNECT ';driver=R:BASE 8.0 Turbo Database Driver
(*.RX1);dbq=C:\RBTI\RBG8\D2_Applications\highwaRe\Development_Version\ScanDocs.RX1'
IDENTIFIED BY username password
SDETACH tCustomerScannedDocs NOCHECK
SATTACH CustomerScannedDocs AS tCustomerScannedDocs USING ALL
----- Original Message -----
From: "Emmitt Dove" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, May 14, 2008 12:23 PM
Subject: [RBASE-L] - RE: Trying to SCONNECT a database but get this error
FIXED but how about a DSN-less connection?
Try this:
SCONNECT ';driver=R:BASE 8.0 Turbo Database Driver
(*.RX1);dbq=C:\RBTI\RBG8\D2_Applications\highwaRe\Development_Version\ScanDo
cs.rb1;uid=userid;pwd=password;'
Note the addition of ".rb1" to your string.
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 1:03 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Trying to SCONNECT a database but get this error
FIXED but how about a DSN-less connection?
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\ScanDo
cs;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
