Pocket PC Application

[NareshShroff]

Hi,
i need to develop a pocket PC application, which connects to a remote SQL Server. Does anyone has knowledge on Pocket PC development using VB.net. There is not much info on Pocket PC development available on net. Some are quite confusing. I dont even find good forums for pocket pc development. I found some books on eVB but couldnt able to find one on Pocket PC development using VB.net. It would be great if some one provide me with sample code for connecting remote SQL Server. Do I need to install SQL Server CE on the desktop where I will be developing the application? Any ideas are greatly appreciated.

Thanks,
Naresh

[sanereddy]

Naresh,

Microsoft .NET Compact Framework included SQL Server 2000 CE Edition 2. SQL Server CE extends the desktop version of SQL Server 2000 to devices running the Windows CE operating system. At the same time, it offers developers the familiarity of the programming model of its desktop cousin. In this article, I will explore the SQL Server CE edition and see how it can be used in your Pocket PC applications developed using the Smart Device Extension (SDE) for Visual Studio .NET.

Developing Pocket PC Apps with SQL Server CE

Here is the link with very good tutorials. see if this helps.

http://www.ondotnet.com/pub/a/dotnet...compactce.html


WinCE database application for MS SQL Server 7 using eVB and XML
The article is based on one of many experimental things I do when I am bored. The concept is pretty simple. I wanted my eVB application to talk to MS SQL Sever 7 over the TCP/IP network, just the kind of the thing I do with my desktop database applications. I couldn\'t find any SQL Server ODBC driver for WinCE, and was not interested in writing one. But I could find different ways to connect my WinCE device to a TCP/IP based network. So I went for a different approach. I created an intermediate gateway (simply an ASP file on IIS), which has all the necessary drivers and tools to connect and execute statements on a server based database and needed to find a language that is commonly understood and spoken by both my eVB application and the gateway on the server. And there it was, \"eXtentiable Markup Language\" or XML for short.

Link: http://www.devbuzz.com/content/zinc_...nector_pg1.asp


Thanks,
sanereddy

Post edited by: sanereddy, at: 2004/07/14 21:42

[NareshShroff]

Thanks SaneReddy garu!

I have seen that ondotnet article. All the articles that I find online provides info on local SQL Server connection not remote server connections. And my main Q is I have visual studio.net 2003 and sql server installed on my desktop and using built-in emulator for testing, now do i need to install SQL Server CE on my desktop inorder to connect to my SQL Server database.

Thanks,
Naresh

[imported_admin]

You need to configure the SQL Server on domain, then you should be able to connect to any sql server from any device. I have SQL Server on my home pc and IP is on domain, I can connect to my home SQL Server instance from any sql client remotely. All you need is the IP address of the SQL Server mechine.

Yes, You can have SQL Server CE anywhere but it should be accessable via network.

Post edited by: admin, at: 2004/07/14 22:11