Macro Scheduler 15

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