EasyTable ODBC Driver: Tutorial

This tutorial illustrates how to connect to a data source, fetch data from existing table, create a new table and insert values into it, retrieve those values, drop this table, and disconnect from the data source. In so doing, it acquaints you with most of ODBC functions.

To connect to a data source:

Manual: Using the ODBC Administrator, create an EasyTable user data source called EasyTable_Test. Specify the database path to test.edb in Demo\Test folder. For information about creating data sources with the ODBC Administrator, see "Managing Data Sources" under "ODBC Data Source Administrator" in the Microsoft Data Access Components (MDAC) SDK.
From your application: Call ConfigDSN with lpszDriver="EasyTable"
Call the following functions:
- SQLAllocEnv
- SQLAllocConnect
- SQLDriverConnect with parameters "DSN=EasyTable_Test;"
  or
  SQLDriverConnect with parameters "DATABASE=test.edb;" or
  SQLConnect with parameter ServerName set to "EasyTable_Test;"

To fetch data from existing table:

Call SQLAllocStmt
Call SQLExecDirect with statement "SELECT str25 FROM Table1"
Until SQLFetch returns 100 (SQL_NO_DATA) instead of 0 (SQL_SUCCESS) call SQLFetch to scroll to new record then SQLGetData to fetch the data.
Call SQLFreeStmt with option 0 (SQL_CLOSE).

To create a table and insert values into it:

Call SQLExecDirect with statement "CREATE TABLE NewTable (City CHAR(10), State CHAR(2))"
Call SQLExecDirect with statement "INSERT INTO NewTable VALUES ('Phoenix', 'CA')"
Call SQLExecDirect with statement "INSERT INTO NewTable VALUES ('Cheyenne', 'WY')"

To retrieve data from a table:

Call SQLExecDirect with statement "SELECT * FROM NewTable"
Call SQLNumResultCol. It should returns 2
While SQLFetch returns 0 (SQL_SUCCESS) until SQLFetch returns 100 (SQL_NO_DATA) call SQLFetch to scroll to new record then call SQLGetData twice as it is defined by SQLNumResultCol to fetch the data from the first and the second columns.
Call SQLFreeStmt with option 0 (SQL_CLOSE).

To drop a table:

Call SQLExecDirect with statement "Drop table NewTable"

To disconnect from a data source:

Call SQLFreeStmt with option 1 (SQL_DROP)
Call SQLDisconnect
Call SQLFreeConnect
Call SQLFreeEnv


	Custom Development!

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

01/16/10
Accuracer VCL v.5.01

12/30/09
MsgCommunicator v.4.10

21/12/09
SQLMemTable v.4.20

07/28/09
EasyTable v.6.40

07/01/09
Single File System v.2.70

06/18/09
Accuracer ODBC Driver v.3.00

03/12/09
CryptoPressStream v.2.00

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

What is the maximum number of records in your tables?

< 1'000

1'000 - 10'000

10'000 - 100'000

100'000 - 1'000'000

> 1'000'000


	Last Releases

	01/16/10 Accuracer VCL v.5.01 12/30/09 MsgCommunicator v.4.10 21/12/09 SQLMemTable v.4.20 07/28/09 EasyTable v.6.40 07/01/09 Single File System v.2.70 06/18/09 Accuracer ODBC Driver v.3.00 03/12/09 CryptoPressStream v.2.00 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