Once installed, run GO.BAT to build all samples. Here's a list of the sample programs:
SQLTEST | Creates a new table then inserts, updates and deletes a few rows |
SQLTEST2 | Sample using parameter query and cursor updates |
SQLTEST3 | Creating a relation between SQLDataSet objects + some useful user functions |
SQLTEST4 | Populating a un-connected SQLDataSet object |
SQLEXCEL | Sample showing how to create/read/write to MS Excel files |
SQLTBRO | Example of using TBrowse to browse an SQL result set |
SQLBRO | Example of using XbpBrowse to browse an SQL result set |
ACEBRO | Example of using XbpBrowse to browse a DBF with the ACE Wrappers |
ACETEST | ACE Wrapper sample with automatic SQL replication of table changes |
ACEADT | ACE Wrapper sample showing how to use ADT/ADI tables |
SQLSYNC | Multithreaded example using ACE Wrappers to copy DBF files to ODBC |
The ACE Wrappers is a separate library that is included AS IS and free of charge with SQLExpress. In order to run the ACE Wrapper samples you will need to download the Advantage Client Engine, ACE32 DLLs. Once downloaded, unzip the files in the same directory where the sample executables are located.
The supplied sample programs use the 32-bit Microsoft Access JET engine. If you experience problems running some of these samples then the most likely cause is that you do not have the 32-bit Microsoft Access Database Engine installed. Here is the link to download the redistributables directly from Microsoft. Make sure to select the 32-bit drivers.