Accuracer ODBC Driver
Description
Description
Specification
Specification
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. All these functions support SQL template and insert values binding by SQLBindParameter in it.
Bind result set columns using row-wise binding as well as column-wise binding, by calling SQLBindCol.
Fetch one binding row of a result set data and scroll the cursor to the next row, in the forward direction only, by calling SQLFetch or by calling SQLExtendedFetch.
Use scrollable cursors, and thereby achieve access to a result set in methods other than forward-only, by calling SQLExtendedFetch with the following FetchOrientation arguments: SQL_FETCH_NEXT, SQL_FETCH_FIRST, SQL_FETCH_LAST, SQL_FETCH_PRIOR, SQL_FETCH_ABSOLUTE, SQL_FETCH_RELATIVE.
Fetch one row of a result set or multiple rows using block cursors, by calling SQLExtendedFetch.
Obtain an unbound column in parts, by calling SQLGetData.
Obtain current values of connection and statement attributes, by calling SQLGetConnectOption and SQLGetStmtOption, and set all attributes to their default values and set certain attributes to nondefault values by calling SQLSetConnectOption and SQLSetStmtOption.
Detect driver capabilities, by calling SQLGetFunctions and SQLGetInfo.
Advanced features:
Multipart name emulation is released in SQLGetInfo, SQLTables, SQLColumns, SQLPrepare, SQLExecute, SQLExecDirect to allow some application to work with driver. (Level1 and Level2 Interface Conformance)
SQL_DESC_NUM_PREC_RADIX, SQL_DESC_NULLABLE attributes in SQLColAttributes (ODBC v.3 Specification)
The Accuracer ODBC Driver supports ODBC v.2 functions only.
Nevertheless you can use it even if your application uses ODBC v.3
functions because the Driver Manager (a Windows dll(s)) maps ODBC v.3 functions to ODBC v.2 functions.
Some features of Accuracer functionality are not available in the Accuracer ODBC Driver due to ODBC
standard restrictions. Despite this fact the driver is fully functional and allows
almost all database operations, some functions are partially implemented yet and
others have some peculiarities.
Read Accuracer ODBC Driver White Paper to learn about
the Driver features. Also you can find there some recommendations on how to work with the driver.
To learn about Accuracer database format read Accuracer Specification .
Tested Environments
Tested Environments
The following environments were successfully tested with the Accuracer ODBC Driver:
CodeGear Delphi 2009, C++Builder 2009 IDE (via BDE)
php v.4 (See php demo supplied with the product)
Borland Delphi 7, BDE (See Test demo)
Microsoft Visual C++.Net v.7.0 (See included DBFetch demo)
Microsoft Excel 2003
Microsoft Excel 2002 SP-1
Microsoft Access 2002 SP-1
Microsoft Visual Studio .Net, Server Explorer
BusinessObjects Crystal Reports 11
DbExpress driver for ODBC, v.2.12. Tested using DBExpress Open ODBC Explorer, v.2.12.
Downloads are available at
DBExpress Open project: http://sourceforge.net/projects/open-dbexpress
Versions and Licenses
Versions and Licenses
Trial - for 1 developer.
This version allows up to two database multi-user connections and
up to five multi-thread single-user connections.
Trial version is intended for evaluation only !
To develop your application you must buy one or more of the following commercial versions:
Std - Standard - for 1 developer, without source code.
Team4 - for up to 4 developers, without source code.
Team8 - for up to 8 developers, without source code.
Ent - Enterprise - unlimited number of developers at one company, includes full source code and free Upgrade Subscription for 12 months.
All commercial licenses are royalty free .
It means you may develop any number of applications for any number of users using this product without additional fees.
How to use
How to use
The Accuracer ODBC Driver is easy-to-use:
just run setup.exe to install/uninstall the dll in your system.
The installation is detailed in Installation chapter in readme.txt.
If you have any questions, please read it carefully.
The basic techniques on how to work with the Driver are shown in Tutorial .
Some features of the Driver work are described in White Paper .
Support
Support
If you have any problems or questions, please read Tutorial
and White Paper first.
In case you did not find an answer to your questions there, please contact our
Support Team
.
We consider any ideas while developing further versions of our products.
You can read more about our Support Policy here .
Purchasing and Registration
Purchasing and Registration
Custom Development!
Custom Development for you -
Delphi and
C++ Builder !
Experts in Database, Networking, Data Compression and Encryption.
10+ years experience.
Contact Us!
讠믬/a>
讠믬