Rachel I believe you will have to SDETACH the table first and then issue the DSN-less connection and then SATTACH the table. Now once this is done and you haven't SDETACH the table you shouldn't receive the prompt to sconnect again.
Buddy -----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\Sc anDocs;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 > >
