Database Driver - mSQL

The DBmSQL database driver allows you to connect to mSQL databases through the standard API provided by the Database Framework module.

Requirements

The mSQL client library is compiled into the module.
Other than a database to connect to, there are no external requirements.

Accessing an mSQL Database

To enable an mSQL connection, you simply pass a dbtype of "MSQL" to the LoadDatabase function.

The second parameter dbname is the name of the mSQL database to connect to.

To connect to an mSQL database on the same machine, you do not need to set values for host, as the default is to connect to localhost.

The user, password and server parameter is not required for this driver.

Prepared Statement Placeholders

mSQL does NOT support prepared statements. The methods prepare and execute simply return False.

Transactions

mSQL does NOT support transactions. The methods startTransaction, commit and rollback simply return True.

SQL with mSQL

For a complete guide to mSQL's SQL syntax, you can download the documentation here.

Module Information