help with starting sql server 7 & ipaq

[skalag]

Hi, I have been working on a website i have been planning for a while, and doing well thanks to a lot of help from this site, but for the third time in 2 years since i had the idea, i have been diverted..my brother wants me do do a stock control application, it sounds within my novice capabilities... populate dropdown boxes from database with the product name, description, and amount, with ability to add, edit, delete...The thing i wantr help with is that i have been using MSaccess, and he wants me to do this with SQL SERVER 7, which i know 0 about, also it is to be connected to using an iPAQ pocket PC, which i also know 0 about...in fact theres quite a lot i know 0 about, but anyway, can anyone advise on requirements or problems associated with using ipaq and sql 7? obviously i can wade as normal through problems like page size and screen size, but i dont know if the vbscript i have been learning can do this project? Apart fom connection string stuff is there anything else different, or where is a good help site for this idea?Thanks for reading this far!

[Spudhead]

AFAIK, there's no way SQLServer will run on a 'Mac. Sorry. Might be wrong; I usually am, but I'd be very surprised if it did, and if it does, it's gonna be an absolute pig. Heck, it's hard enough to keep the blasted thing running on a nice, familiar Win2000 setup; put it on a Mac and it'd have kittens.

Re: SQLServer, though - it's not so hard; there's some SQL syntax differences with Access, it's bigger and there are more options, but you should become familiar with it pretty quickly. There are plenty of resource and tutorial sites around, but forums are IMHO still the best way - try somewhere like dbforums.com for a start.

Hope that's some help.