Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Pocket PC Dilemma

Author  Topic 

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-06-24 : 16:33:25
Our company wishes to improve our comunications so it has purchased some Ipaq 4150 complete with internal Wi-Fi.
Since we have internal wirless with good security I thought we could use them to access things like Inventory.
I created the views and the Html to get at the inventory control even sized it for the small screen everything seemed to be going well.
Now I hit the SNAG the Ipaq Runs MS Pocket PC 2003 and the version of the Internet explorer will not run Data Access Pages. Customer Support says there is no other version for this.

Now what the heck do I do? Anyone Got any Ideas?

Jim
Users <> Logic

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-06-24 : 18:09:52
Data Access Pages? Is that an MS office thing?

You probably need to write an ASP or an ASP.Net page to make this work. Visual Studio .net has a ton of tools that are used to make Pocket PC applications. I've not done it, but it looks pretty easy.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

Pat Phelan
Posting Yak Master

187 Posts

Posted - 2004-06-24 : 18:22:44
Don't pitch the baby with the bath water! I'd suggest Data Access Strategy as a starting point.

-PatP
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-06-25 : 08:11:29
Michael

ASP is also a Data Access Page(tried that after HTML failed)

PAT

You raise a very good point. But for this application we have continuious net connection in all areas I would want them to have data access. A Full Cisco 802.11e wireless network It cost me a pound of flesh to push that project through but its worth it.

All I need is a way to access my SQL Querries and SPs on the server. I can connect using the terminal server on the Ipaq but because of the screen layout is is difficult to use and I would prefer to limit access to a few apllications only.

I will have to look at Visual Studio.net Wish I knew some one who had deveoped one of these for Pocket PC.

Jim
Users <> Logic
Go to Top of Page

Pat Phelan
Posting Yak Master

187 Posts

Posted - 2004-06-25 : 12:53:13
Uff-da! I remember talking with some of the geeks about this very subject a while back. Our TAM will be in my office on Monday, I'll abuse them and see if I can resurrect an answer.

There is a technology that is a lot like DAP, but with a pure DHTML / XML basis that runs under IIS 6 that is perfect for this kind of use. It even automagically handles the screen scaling (and allows for simple rotation too). I haven't needed it myself, but I'll see if I can finger out where I can get more info.

-PatP
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-06-25 : 13:00:36
That would be great Thanks Pat.

Jim
Users <> Logic
Go to Top of Page

Pat Phelan
Posting Yak Master

187 Posts

Posted - 2004-06-28 : 15:41:57
Our TAM couldn't come up with the info, but he gave me more ideas on where to look. Now this has become an obsession!

-PatP
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-06-29 : 08:01:40
I broke down and Purchased Visual studio .net.

Now all I have to do is learn how to use it.

It has been years since I wrote Strait VB and then only for under Access.

Jim
Users <> Logic
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-06-29 : 14:01:04
If you are looking to learn ASP.net (Mobile Web Forms) a good book to look at is ASP.Net Unleashed by Stephen Walther. Chapter 7 has some stuff about developing stuff for mobile devices.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

Pat Phelan
Posting Yak Master

187 Posts

Posted - 2004-07-06 : 13:13:27
Blast! I'd hoped to find the answer before I went on vacation, but time has become rather scarce. I'll post the answer as soon as I can, but it doesn't look like it will be until at least August now.

Sorry!
-PatP
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-07-06 : 14:32:23
See ya when ya get back pat

Have a Nice "Timer".




Jim
Users <> Logic
Go to Top of Page

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-07-06 : 18:35:18
Jim,

Have you looked into XPath Queries Using HTTP?

Also, another decent resource for Mobile .NET apps is:

http://www.asp.net/Default.aspx?tabindex=6&tabid=44
Go to Top of Page
   

- Advertisement -