VCL

Kylix

Download

Technologies

Articles

Products –> VCL


	Products
Delphi Components

Accuracer

EasyTable

SQLMemTable

Single File System

CryptoPressStream

MsgCommunicator

Active Query Builder

Database Master

BDE Replacement

Delphi Database

Kylix Components

Download

Technologies

Articles

Under Development


	Order
How To Buy

Sales Policy

Upgrade Policy


	Support
Support Policy

FAQ

Contact Us


	Info
Main

News

Why Choose Us

Testimonials

Partners

About Us

Awards

Trademarks

Subscription

EasyTable ODBC Driver

Description
Specification
Tested Environments
How to use
Support
How to order

Description

The EasyTable ODBC Driver provides read/write access to EasyTable database in accordance with Level1 interface conformance of ODBC v.2 specification with some additional Level2 features.

Some features of EasyTable functionality are not available in the EasyTable 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 EasyTable ODBC Driver White Paper to learn about the Driver features. Also you can find there some recommendations on how to work with the driver.

Specification

The EasyTable 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 EasyTable 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, 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 EasyTable 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.

To learn about EasyTable database format read EasyTable Specification.

Tested Environments

The following environments were successfully tested with the EasyTable ODBC Driver:

BDE (See Test demo supplied with the product)
Visual C++.Net v.7.0 (See DBFetch demo supplied with the product)
Crystal Reports 11
Microsoft Excel 2002 SP-1
Microsoft Access 2002 SP-1
Microsoft Visual Studio .Net, Server Explorer
Macromedia Dreamweaver 7
DbExpress driver for ODBC, v.2.12. Tested using DBExpress Open ODBC Explorer, v.2.12. Downloads are available at

How to use

The EasyTable 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

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 .

We consider any ideas while developing further versions of our products. You can read more about our Support Policy here.

Purchasing and Registration

Please click the following link if you would like to order this product.

In case you have already bought this product, you can upgrade it to the latest version or edition. Read our Upgrade Policy to learn more about it.

Please see Sales Policy for details about guarantee, money back, usage terms and conditions.

If you have any problems or questions, please contact our .

Accuracer is fastest!

Accuracer Database System is the fastest Delphi client/server database!

Custom Development

Custom Development for you - Delphi and C++ Builder!
Experts in Database, Networking, Data Compression and Encryption.
10+ years experience.

Last Releases

02/02/12
EasyTable v.7.00

01/31/12
Single File System v.3.00

01/30/12
CryptoPressStream v.3.00

10/27/11
MsgCommunicator v.5.00

10/19/11
SQLMemTable v.5.00

10/06/11
Accuracer VCL v.6.00 Beta 2 with XE2

04/27/11
MsgCommunicator Database Pack v.1.10

03/30/11
Accuracer ODBC Driver v.4.02

03/23/11
Accuracer VCL v.5.90 is the fastest Delphi C/S database

02/10/11
Accuracer is the best in the SQL test!

02/17/06
EasyTable ODBC Driver v.1.20

12/14/05
Active Query Builder v.1

10/12/04
Accuracer & EasyTable
are the fastest!
Competitive Prices and
Features Comparison

01/28/04
Accuracer CLX v.1.40 for Kylix

Competitive Upgrade

If you own a competing product, you may take a discount up to 50%.
Please, contact our

Voting

In what language do you prefer to read a documentation?

English

German

French

Italian

Spanish

Portuguese

Russian

Turkish

Chinese

Japanese

Other:


	Accuracer is fastest!

	Accuracer Database System is the fastest Delphi client/server database!


	Custom Development

	Custom Development for you - Delphi and C++ Builder! Experts in Database, Networking, Data Compression and Encryption. 10+ years experience.


	Last Releases

	02/02/12 EasyTable v.7.00 01/31/12 Single File System v.3.00 01/30/12 CryptoPressStream v.3.00 10/27/11 MsgCommunicator v.5.00 10/19/11 SQLMemTable v.5.00 10/06/11 Accuracer VCL v.6.00 Beta 2 with XE2 04/27/11 MsgCommunicator Database Pack v.1.10 03/30/11 Accuracer ODBC Driver v.4.02 03/23/11 Accuracer VCL v.5.90 is the fastest Delphi C/S database 02/10/11 Accuracer is the best in the SQL test! 02/17/06 EasyTable ODBC Driver v.1.20 12/14/05 Active Query Builder v.1 10/12/04 Accuracer & EasyTable are the fastest! Competitive Prices and Features Comparison 01/28/04 Accuracer CLX v.1.40 for Kylix


	Competitive Upgrade

	If you own a competing product, you may take a discount up to 50%. Please, contact our