G2 Database Example
The IDX G2 Database examples are a series of demonstrations and documentation how to use the database communications functionality of IDX with G2
With IDX database functionality you can:
1. Connect to any Data Source for which an OLE-DB or ODBC provider exists. Examples include MS Access, MS SQL Server, Oracle & Sybase.
2. Execute any SQL command supported by the database vendor
3. Retrieve the results of SELECT queries in resizeable batches
4. Execute stored procedures and receive either output parameters or query results returned from the stored procedure.
5. Perform asynchronous database operations across multiple database connections (db-objects).
6. Perform other G2-IDX operations (such as tag reading or writing) asynchronously with database operations
For the first four database demonstration exercises, ensure that:
1. An IDX service running
2. Microsoft's MDAC 2.6 or later is installed (see the iDX install CD)
3. A MS Access 2000 database named idx-db-demo.mdb (supplied with this KB - installed in the same directory as the demo KB). You don't need MS Access 2000 itself to access the database via IDX, just the Microsoft Data Access Components (MDAC).
4. The fifth (stored procedures) demonstration assumes you have access to MS SQL Server