ODBC Compatibility
- Last UpdatedJul 13, 2023
- 2 minute read
This section describes the necessary and optional ODBC functions that your database driver needs to support:
Essential functions
The Plant SCADA SQL devices and Cicode functions only work if the database driver supports the following ODBC functions:
|
Level 0 |
Level 1 |
|---|---|
|
SQLAllocConnect |
SQLColumns |
|
SQLAllocEnv |
SQLDriverConnect |
|
SQLAllocStmt |
SQLGetData |
|
SQLBindCol |
SQLGetFunctions |
|
SQLColAttributes |
SQLGetInfo |
|
SQLDescribeCol |
SQLGetTypeInfo |
|
SQLDosconnect |
SQLParamData |
|
SQLError |
SQLPutData |
|
SQLExecDirect |
SQLSetConnectOption |
|
SQLExecute |
SQLSetStmtOption |
|
SQLFetch |
|
|
SQLFreeStmt |
|
|
SQLGetCursorName |
|
|
SQLNumResultCols |
|
|
SQLPrepare |
|
|
SQLRowCount |
|
|
SQLSetParam |
Optional functions
Plant SCADA SQL devices and Cicode functions also use the ODBC functions listed in the table below. While these functions are not necessary for operation, if they are absent in a driver, the error code 307 (SQL database error) will be returned if the ODBC driver does not support the necessary ODBC functions. To get the message associated with the error, call the Cicode function SQLErrMsg.
Level 0
|
SQLTransact |
If the driver does not support this function, the Cicode functions SQLBeginTran(), SQLCommit(), and SQLRollBack() are not supported. |
Level 1
|
SQLSpecial Columns |
Plant SCADA uses this function if it is available. There is no loss of functionality otherwise. |
|
SQLTables |
(no effect on Plant SCADA) |
Level 2
|
SQLData Sources |
The driver does not need to support this function. It is provided by ODBC. |
|
SQLExtended Fetch |
Without this function, Plant SCADA cannot take advantage of the native database's ability to fetch records at random. |
|
SQLSetScroll Options |
Without this function, Plant SCADA cannot take advantage of the native database's ability to fetch records at random. |
|
SQLMore Results |
(no effect on Plant SCADA) |
|
SQLNativeSql |
(no effect on Plant SCADA) |
|
SQLProcedure Columns |
(no effect on Plant SCADA) |