ODBC functions

StreamServe ODBC functions enable interfacing with ODBC compliant data sources. You can connect to any data source that has an ODBC driver configured for the platform that StreamServe is operating on.

To be able to use the Streamserve ODBC functions, you must be familiar with ODBC and data source concepts, SQL, scripting in StreamServe, and the operating platforms that both StreamServe and the data sources to be used will be running on.

Requirements

To use the ODBC script functions, you must

•	Configure an ODBC data source

You must configure an ODBC data source for each data source you want to use. Once configured, the data sources will be accessible for all ODBC functionality, not just with StreamServe.

Note:

If you run on a 64-bit Windows, you must start the odbcad32.exe manually from the \Windows\SysWOW64 folder, instead of starting the tool via the Administrative tools > Data sources (ODBC) start menu option. This is because of a bug in Windows.

On UNIX, you must configure the odbc.ini file in <StreamServe installation>/Platform to comply with your environment.

•	Use a reliable ODBC driver

The ODBC functions provide an interface to ODBC and not to a specific data source. You must choose a reliable and thoroughly tested ODBC driver for your data source. The StreamServe ODBC module does not check how your ODBC driver executes the SQL statements.

On UNIX, you must configure the odbcinst.ini files in <StreamServe installation>/Platform if you use any other driver than DataDirect.

•	Specify the appropriate ODBC startup arguments

You must specify the appropriate ODBC startup arguments before you export the StreamServe Project. See ODBC startup argument.

Escape sequences

The less-than sign (<) is a reserved character and must be escaped if used in a string, see Escape sequences.

ODBC functions

The table below contains a short description of each script function. For information about syntax, examples, etc., see the full description of each script function.

Function name	Description
OdbcBeginTrans	Begins a new transaction, which opens two possibilities: • To commit the transaction, call the ODBCCommitTrans function. • To end the transaction, call the ODBCRollbackTrans function.
OdbcCommitTrans	Commits a transaction that you have opened with ODBCBeginTrans. The changes within the transaction are saved to the database and the transaction is ended.
OdbcConnect	Connects the user to the data source.
OdbcConnectW	Connects the user to the data source. If the data retrieved with ODBCGetFirst, ODBCGetNext, or ODBCGetOne is of Unicode type, you must use the OdbcConnectW (instead of OdbcConnect) when connecting to the data source.
OdbcCloseQuery	Closes any open queries (statements) in the data source. An open query exists when OdbcGetFirst has been executed and all rows in the result set have not been retrieved with OdbcGetNext.
OdbcDate2Date	Extracts the date from a date and time string.
OdbcDate2Time	Extracts the time from a date and time string.
OdbcDisconnect	Disconnects the server from the data source.
OdbcExecute	Executes SQL statements. Any result sets that the statement generates are ignored. This function can be used, for example, to update record fields in the data source.
OdbcExecuteEx	Same as OdbcExecute. The difference is that this function can be configured to accept that a CREATE TABLE statement fails.
OdbcGetOne	Executes an SQL statement and copies the values from the first row in the result set to script variables.
OdbcGetFirst	Executes an SQL statement and copies the values from the first row in the result set to the specified script variables. The OdbcGetNext function is then used to retrieve the remaining parts of the result set.
OdbcGetNext	Retrieves the values of the columns in the second row of a result set. This function can only be called after OdbcGetFirst has been called to retrieve the first row in the result set. OdbcGetNext can then be called repeatedly to process all the remaining rows.
OdbcRollbackTrans	Rolls back and ends a transaction that you have opened with ODBCBeginTrans.
OdbcSetCodepage	Sets the code page.