locked
ADO RRS feed

  • Question

  • Hi:

    Is it true that a .net project of WinCE 5.0 pro can't access Win2000 SQL database thru ADO?

    Any solution?

    Chang  

     

     

    Wednesday, July 19, 2006 5:07 PM

Answers

  • If you are developing a Smart Device project in Visual Studio 2005, all you need to do to work with SQL Server 2000 using the SqlClient is add a reference to your project to System.Data.SqlClient version 3.0.3600.0.  The SqlClient comes as part of the .NET Compact Framework, which is included with versions of Visual Studio that are capable of doing Smart Device projects (VSTS Developer, VS2005 Professional, etc).

    In general, you should only be using SqlClient if you are reliably connected (WinCe device to server) during database operations.  As this is often impossible to guarantee, most people use a local data cache on device (SQL CE or SQL Mobile are the common choices) and periodically synchronize data between the server and local data cache when a connection is available.  A newsgroup is not the place to teach you how to implement this, but any of the books on the .NET Compact Framework cover this topic and the new Mobile Client Software Factory provides a reference implementation.  http://msdn.microsoft.com/mobility/default.aspx?pull=/library/en-us/dnpag2/html/mcsflp.asp

    Darren

     

    Friday, July 21, 2006 5:23 PM

All replies

  • ADO.Net CE actually has a different forum.  I'll move the thread over there.
    Wednesday, July 19, 2006 8:11 PM
  • no, not true.  A .NET Compact Framework 1.0 or 2.0 project running on WinCE5 can indeed access a SQL Server 2000 database directly using the version of the SqlClient included with the COmpact Framework.

    Darren

     

    Thursday, July 20, 2006 2:21 PM
  • Thank you Darren:

    Can you give me the address to download the version of the SqlClient included with the COmpact Framework?

    My purpose is to use a WinCE mobil computer to run a .net program and real time access my SQL2000. Someone suggest me to use sqlCE to sychronize with SQL2000? or use webservice but neither of these way were workable, I don't know what's wrong.

    Jeanet

     

     

    Friday, July 21, 2006 4:41 PM
  • If you are developing a Smart Device project in Visual Studio 2005, all you need to do to work with SQL Server 2000 using the SqlClient is add a reference to your project to System.Data.SqlClient version 3.0.3600.0.  The SqlClient comes as part of the .NET Compact Framework, which is included with versions of Visual Studio that are capable of doing Smart Device projects (VSTS Developer, VS2005 Professional, etc).

    In general, you should only be using SqlClient if you are reliably connected (WinCe device to server) during database operations.  As this is often impossible to guarantee, most people use a local data cache on device (SQL CE or SQL Mobile are the common choices) and periodically synchronize data between the server and local data cache when a connection is available.  A newsgroup is not the place to teach you how to implement this, but any of the books on the .NET Compact Framework cover this topic and the new Mobile Client Software Factory provides a reference implementation.  http://msdn.microsoft.com/mobility/default.aspx?pull=/library/en-us/dnpag2/html/mcsflp.asp

    Darren

     

    Friday, July 21, 2006 5:23 PM
  • Thank you Darren:

    I'm new to work with WinCE. My purpose is to use a handheld (Symbol 3090 running WinCE 5.0) to run a simple application (a .net 2005 program) over RF connection to real time access my SQL server.

    I need clear instructions to setup the environment.

    Your answer will be very appreciaated.

     

    Jeanet

    Friday, July 21, 2006 6:58 PM