I'm planning on getting a PDA so your shop staff and reorder products.

I'm making an application in Visual Studio 2005 and need to get information from our pervasive database.

The idea is they will go to a product scan the barcode which will bring up information like where it's stocked, sku number, price, cost, current stock then they enter how meny they want to order for re-stock and that needs to be entered into the database.

So my question is really how do i get Windows CE/Mobile to connect to our pervasive database via either btreave or ODBC?????


Thanks

Neil

The only way to to directly access Pervasive data one the Windows CE/Mobile PDA would be to create a WebService that runs on a Windows machine and then use VS.NET to create a Smart Client (Mobile) application that consumes that Web Service.

Do you know of any tutorials/guides on how to do this?


Why can't PDA's do ODBC?

Because there are no client components to do ODBC. To access a database, you need some components on the PDA. Pervasive doesn't offer those components.

I don't know of any specific tutorials. I created a test back when VS.NET was first released but I can't find it now. As I recall, all I did was create the web service in C# on the Windows host and then a C# PDA application that uses the WebService.