Native Programming Reference (SQL Server Compact)

By using Microsoft Visual C++, you can apply your knowledge of Visual C++ to develop desktop applications that use Microsoft SQL Server Compact 4.0.

SQL Server Compact 4.0 is implemented as a set of dynamic-link libraries (DLLs) that simplify data access. You use OLE DB to access a SQL Server Compact database in Visual C++ applications. OLE DB is a low-level data interface technology that provides granular capabilities for data access. Of all the data access APIs, OLE DB for SQL Server Compact provides the fastest data manipulation and access.

SQL Server Compact 4.0 header files are installed under %ProgramFiles%\Microsoft SQL Server Compact Edition\v4.0\Include. In the file header comments, the version-specific information for SQL Server Compact is contained. The list of header files and their purpose is given below:

  • sqlce_err.h

    Error codes used by database

  • sqlce_oledb.h

    OLEDB standard programming interfaces

  • sqlce_sync.h

The following table describes the topics in this section:



Engine Object Programming (SQL Server Compact)

Describes the methods and properties used to create, use, and delete a SQL Server Compact database when you use Visual C++.

Programming the Native Error Object (SQL Server Compact)

Describes the methods and properties used to implement error handling with SQL Server Compact when you use Visual C++.