> For the complete documentation index, see [llms.txt](https://docs.monokot.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.monokot.io/scripts/api/mosodbc.md).

# MosOdbc

The MosOdbc object contains methods used for interaction with a database via the ODBC driver. 

{% hint style="warning" %}
Please note that calling any function of the *MosOdbc* object will immediately put the script module into demo mode if it is not licensed
{% endhint %}

### Methods <a href="#h.dlb4khgqvtip" id="h.dlb4khgqvtip"></a>

| **Name**                                 | **Description**                                                                                                                                                                                      |
| ---------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| executeNonQuery(connectionString, query) | Executes an SQL script and does not return any result. Accepts ODBC string of connection to the database and query string as arguments.                                                              |
| executeScalar(connectionString, query)   | Executes an SQL script and returns the first field of the first record of the resulting set returned by the query. Accepts ODBC string of connection to the database and query string as arguments.  |
| openReader(connectionString, query)      | Executes an SQL script and returns a MosOdbcReader object to navigate the resulting data set returned by the query. Accepts ODBC string of connection to the database and query string as arguments. |