Wireless, ODBC database Application on MicrosoftR Windows Mobile? 2003 Second Edition

Hi,

I am doing a new project on MicrosoftR Windows Mobile 2003 Second Edition. I am a new hand for developing a mobile application.

This project is like: on a PC desktop, there is an ODBC database that has already existed for a long time. We are planning to develop an application for a Mobile device whose platform is MicrosoftR Windows Mobile 2003 Second Edition. In this application, I can click a button so that mobile device can be connected to the ODBC database and the data in the mobile device can be transferred to/from it on PC desktop. The connection between mobile and the PC desktop will be wireless connection.

I am planning to develop it on the Visual studio 2005.

Questions:

Any information about sample project like this Any hyperlink Any books

Thanks a lot.

Answer this question

Wireless, ODBC database Application on MicrosoftR Windows Mobile? 2003 Second Edition

sxsoptic
Please take a look here for general guidelines:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=287811&SiteID=1

Sure it would work with wireless network. Nature of the network media is irrelevant as long as it can run TCP/IP over it.
JJO123
I suggest you look at SqlMobile. You can host the database in SQL Server and sync it to th device using RDA
bala_kk

Hi,

Thanks for your reply. We have almost 100 offices all over US, and there is an ODBC database in each office. Moreover, these databases have already existed. So we have to connect to ODBC databases using wireless way. Any other ideas

Best regards.
sorunsal
Hi,

we have SqlLinkCE on our site (www.gui-innovations.com) which will allow you to read ODBC compliant databases from your PPC - this may help you

Pete
frozon
"Create/Web Site" - that's on a start page of VS 2005. If you don't see it, you probably don't have IIS installed. Please install it from Add/Remove Programs.
Srinivas Gudimella

Thanks for your reply about Web services. I read the hyperlink that you provided. The related information is:

These WS methods would run on desktop via IIS which would host WS. To create them, please click ‘Create/Web Site’ and choose "ASP.Net Web Service". You'll get project skeleton, simply add code you need and run it. Decorate added methods with WebMethod attribute. This is desktop project, so you could use anything desktop has to offer.

But where I can do for the "click ‘Create/Web Site’ and choose "ASP.Net Web Service"

Does anyone else have any other ideas about my project

Thanks in advance.

Best regards.
rwike

ODBC is not a database, it's a DB connection API. Pretty much any database has ODBC driver. ODBC is not supported on devices.

Which database you're using Perhaps there's 3rd party managed provider for it on devices. If there's none, you can use Web Services as a proxy - device would talk to WS, WS would connect to database.
DavidLSNB

Hi,

Thank you so much for your answer. Any sample hyperlinks about how to use Web Services as a proxy - device would talk to WS, WS would connect to database Can this way work for wireless connection between device and PC desktop

Best regards.
Wireless, ODBC database Application on MicrosoftR Windows Mobile? 2003 Second Edition

Answer this question