locked
Use SQL Server 2000 in windows mobile 5.0 application RRS feed

  • Question

  • User1210363811 posted
    Hi,

    I am starting to learn about the Windows Mobile 5.0 and Visual Studio 2005. My question are as follows:

    1. How can i manually install SQL Server Mobile to my smartphone or Pocket PC
    2. Can i use SQL Server 2000 as the backend database of my Windows mobile 5.0 application

    thanks.



    Wednesday, May 10, 2006 9:04 PM

All replies

  • User-278257239 posted
    Hi

    1. To install Sql Server Mobile on your device, just create a project in VS2005 for your type of device and include this in the programs.cs file:

    using System.Data.SqlServerCe;

    This will install the necessary components on your device.
    You'll need to make a reference in your project to System.SqlServerCe too...
    Hope that helps a bit. Haven't tried to really manually install the sql server.

    2. Yes. but keep in mind memory and performance restraints on handheld devices, and storage capacity.

    Marius.
    Monday, May 15, 2006 4:00 AM