The following sample applications and wrapper DLLs are referenced in this chapter and you can find the source files on the CD-ROM that accompanies this volume. See www.microsoft.com/sql/ for updates to these resources.
Resource | Description |
---|---|
Btrvapp.exe | Sample Btrieve application that references the Sales.btr and Titlepub.btr Btrieve data files. It is the starting point for the conversion strategy, and it is a simple data-entry and reporting application for a database that maintains information about publishing companies, the titles they manage, and current sales information for each title. |
Mybtrv32.dll | Sample wrapper DLL that translates the Btrieve calls in Btrvapp.exe to ODBC and Transact-SQL calls. The wrapper provides a bare minimum conversion from a Btrieve ISAM implementation to a SQL Server client/server implementation. Using this wrapper DLL, Btrvapp.exe accesses nonnormalized tables from the SQL Server pubs database instead of the Btrieve data files. |
Odbcapp.exe | Sample ODBC and SQL Server application that performs the same function as the Btrvapp.exe and Mybtrv32.dll combination by using ODBC and Transact-SQL only, and no Btrieve calls or references. |
Morepubs.sql | Script file that creates the nonnormalized tables in the pubs database referenced by the wrapper DLL, as well as the stored procedures used by Odbcapp.exe for illustrative purposes. |