Editor: The Accuracer ODBC Driver provides read/write access to Accuracer database in accordance with Level1 interface conformance of ODBC v.2 specification with some additional Level2 features.
Starting with v.2.00 Accuracer ODBC Driver works in client-server mode as well as in file-server mode it supported before.
In file-server mode Accuracer ODBC Driver requires a local or network path to the database file. When you update or insert new data, be sure that the database you work with is not opened in exclusive mode by another application (for example, by AccuracerDatabaseServer utility).
In client-server mode you must specify connection parameters (such as network address of the server). Be sure that the AccuracerDatabaseServer utility or your own server application was started and configured properly to work with The Target database.
The Accuracer ODBC Driver exhibits Level1 interface conformance. The features in the Core level also correspond to the features defined in the ISO CLI specification and to the nonoptional features defined in the X/Open CLI specification. The Accuracer ODBC Driver allows the application to do all of the following:
-Allocate and free all types of handles, by calling SQLAllocConnect, SQLAllocEnv, SQLAllocStmt, and SQLFreeConnect, SQLFreeEnv, SQLFreeStmt.
-Use all forms of the SQLFreeStmt function.
-Gain access to the description (metadata) of result sets, by calling SQLColAttributes, SQLDescribeCol, SQLNumResultCols, and SQLRowCount.
-Query the data dictionary, by calling the Catalog functions SQLGetTypeInfo, SQLTables, and SQLColumns.
-Establish connections, by calling SQLConnect and SQLDriverConnect.
-Handle dynamic parameters, including arrays of parameters, in the input direction only, by calling SQLBindParameter.
-Prepare and execute SQL statements by calling SQLPrepare and SQLExecute. Execute SQL statements, by calling SQLExecDirect.