Purpose
Synopsis
procedure SQLconnect(s:string)
Argument
Example
The following connects to the MySQL database `test' as the user `yves' with the password `DaSH':
SQLconnect("DSN=mysql;DB=test;UID=yves;PWD=DaSH") Open a connection to Excel using the file mydata.xls
Further information
This procedure establishes a connection to the database
defined by the given connection string. If extended mode is in
use (default) and the ODBC driver manager publishes its driver list,
the connection string may be reduced to a file name as long as
this name allows identification of the required driver (by
using the filename extension).
It is possible to open several connections but the connection
established last becomes active.
Each connection is assigned an identification number which can be
obtained by getting the value of the parameter
SQLconnection
after this procedure has been executed. This parameter can also be
used to change the active connection.
Related topics
If you have any comments or suggestions about these pages,
please send mail to docs@dashoptimization.com.