Razzak You are fantastic! My Boston wish already there! Gunnar Ekblad
-----Ursprungligt meddelande----- Fr�n: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] F�r A. Razzak Memon Skickat: den 8 februari 2004 22:27 Till: RBASE-L Mailing List �mne: [RBASE-L] - From the Edge: Using DSN-Less Connections in R:BASE 7.1 February 8, 2004 From the Edge: Using DSN-Less Connections in R:BASE 7.1 Section: Enhanced Commands Chapter: Running R:BASE Your Way! Platform: R:BASE 7.1 for Windows Build: 7.1.71.30214 and higher Normally on the SCONNECT command you specify the DSN you want to use. ODBC looks up this DSN and determines the driver to use and what connection it needs. In this version we let you specify the ODBC driver instead of an DSN. This is done as follows: Assume you have a R:BASE database called RRBYW8 located in a folder called D:\71D. To access this database you need an R:BASE 7.0 or Oterro 3.0 ODBC driver installed. For the SCONNECT command use this: Examples 01 (Using R:BASE 7.0 ODBC Driver): SCONNECT ';driver=R:BASE 7.0 Database Driver (*.rb1);dbq=d:\71d\rrbyw8' Examples 02 (Using Oterro 3.0 ODBC Driver): SCONNECT ';driver=Oterro 3.0 Database Driver (*.rb1);dbq=d:\71d\rrbyw8' Note the initial semi-colon. This is the flag that you are not specifying a DSN. The item after the 'driver' is the actual name of the driver as defined in ODBC. Make sure you spell and space this exactly as it is defined in ODBC Data Source Administrator Drivers. The database and the exact path of the database is specified in the 'dbq' part of the string. The entire string must be surrounded by your database QUOTE character. Single quotes are used in the example above. With a connection like this you can use a linked R:BASE database without a pre-defined DSN. A table attached using such a connection remembers all this for later "DSN-less" access. For a complete PDF version of this technical document, examples and syntax, please visit: From The Edge: http://www.razzak.com/fte (Powered by R:PHP) Imagine the Possibilities! Very Best R:egards, Razzak. --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=

