SQLExpress Installation Notes

    The download page contains several versions of SQLExpress; in order to eliminate version conflicts, make sure to download and use the correct SQLExpress DLLs for your version of Xbase++.

    SQLExpress is distributed as a password protected ZIP archive that can be expanded using a utility such as WinZip. Once you have registered, the archive password and SQLExpress license key will be sent to you by email. The archive contains a directory structure, therefore be sure to extract using folder names!

    Once installed, run GO.BAT to build all samples. Here's a list of sample programs included:

    • 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 are included free of charge in this version of SQLExpress. However, 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.

    • Download ACE32 DLLs   [Size: 600 KB, Date: 2000.05.08, Version: 2.7.0.2]
    • Read ACE Wrapper notes

    The supplied sample programs use the MS Access JET engine, if you experience problems running some of these samples then the most likely cause is an old version of the MS Access ODBC driver. You can update your ODBC drivers by installing the latest Microsoft Data Access Components (MDAC). NOTE: MDAC versions 2.6 and later do not include Microsoft's desktop ODBC drivers (for Access, dBase, FoxPro, Excel, Text and Paradox). These must be downloaded separately.

    • Download MS-JET desktop ODBC drivers Ver.4.0 SP8

    License key information:
    There are no differences between the demo and registered versions of SQLExpress. When you register, a license key will be sent to you by email. Copy and paste the license key into the SQLXKEY.PRG file and make sure to link SQLXKEY.PRG into your application. If the license key is invalid, your SQLExpress application will revert to demo mode.

    When you register, you will receive:

    • a SQLExpress license key
    • a password for downloading the ACE Wrappers source code
    • free technical support and software updates for one year
    • Click here to register

    home     download     top of page