Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Building an OLE DB Application (SQL Server Compact)

You can create native desktop and smart device applications within Visual Studio 2008 IDE by using Microsoft Visual C++. This topic provides the information that you must have to start to build an OLE DB Visual C++ application.

To create a new application, you first create the project in Visual Studio 2008.

To create a new desktop project
  1. In Visual Studio 2008, on the File menu, point to New, and then select Project.

  2. In the Project Types list of the New Project dialog box, expand the Visual C++ programming language, and then select the type of project you want to create. For example, to create an ATL project, select ATL.

  3. Provide a name and location for your project, and then click OK. Visual Studio creates a new project.

To create a new smart device project
  1. In Visual Studio 2008, on the File menu, point to New, and then select Project.

  2. In the Project Types list of the New Project dialog box, expand the Visual C++ programming language, and then select Smart Device.

  3. In the Templates list, select the type of project you want to create. For example, to create an ATL project, select ATL Smart Device Project.

  4. Provide a name and location for your project, and then click OK.

    Visual Studio creates a new project.

The next step in building an OLE DB-enabled application is to include the appropriate header files. In the main entry point for your application, add include statements for the SQL Server Compact 3.5 OLE DB provider and the SQL Server Compact 3.5 error file:

#include <sqlce_oledb.h>
#include <sqlce_err.h  >

The final step in using OLE DB in your application is to create an instance of the provider. The following code demonstrates how to do this:

hr = CoCreateInstance(CLSID_SQLSERVERCE, 0, CLSCTX_INPROC_SERVER, IID_IDBProperties, (void**) &pIDBProperties);
Show:
© 2015 Microsoft