Windows CE program to access SQL Server 2000 on same machine?

[Guest]

Dear experts,

I am trying to create a Windows CE program using Visual Studio 2003 to access an existing SQL Server 2000 database. Both the Windows CE program and the database exist in the same machine. Is there a way to create a Windows CE program to access an SQL Server 2000 database, without using SQL Server CE? Could u please kindly provide any samples or links?

Thank you very much in advance.

 

[William Ryan eMVP]

Add a reference to the SqlClient .dll and then just use the SqlClient
library directly just like you would on the desktop. You can access big SQL
Server directly and totally cut out CE. However, remember if you do this
that you will have a dependency to network connectivity. Although it's
limited by ADO.NET's architecture, you will need a connection to hit it
whereas a solution where you use CE can work totally stand alone.

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

Dear experts,

I am trying to create a Windows CE program using Visual Studio 2003 to

access an existing SQL Server 2000 database. Both the Windows CE program and
the database exist in the same machine. Is there a way to create a Windows
CE program to access an SQL Server 2000 database, without using SQL Server
CE? Could u please kindly provide any samples or links?

 

[Paul G. Tobey [eMVP]]

How can they exist on the same machine? SQL Server 2000 (desktop) doesn't
run under Windows CE...

Paul T.

Dear experts,

I am trying to create a Windows CE program using Visual Studio 2003 to

access an existing SQL Server 2000 database. Both the Windows CE program and
the database exist in the same machine. Is there a way to create a Windows
CE program to access an SQL Server 2000 database, without using SQL Server
CE? Could u please kindly provide any samples or links?