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=

Reply via email to