DBConnect
Not supported in Macro Scheduler Lite.
DBConnect>connection_string,database_reference
Connects to a database via a system data source or ADO/ODBC connection string.
Accepts an ADO/ODBC connection string or system data source name.
Returns a reference to the database, to be used in DBClose, DBExec and DBQuery commands.
If an error occurs database_reference will be set to "ERR" followed by any error message returned by ADO or the database driver.
Use DBClose to close the database.
To set a timeout for the connection set the DB_CONNECTTIMEOUT variable to a number of seconds.
For more advanced database manipulation use VBScript. See:
http://www.mjtnet.com/blog/2006/02/20/accessing-databases/
Abbreviation: DBC
See also: DBClose, DBExec, DBQuery
Example
Let>str=Driver={MySQL ODBC 3.51 Driver};Server=someserver.com;Port=3306;Database=example;User=admin;Password=xxxx;Option=3;
DBConnect>str,dbH
Let>SQL=delete from mytable where ID=1234
DBExec>dbH,SQL,result
DBClose>dbH