Puzzled with Database Connectivity...

W

Wong

Dear everyone,

i hav no idea abt database built by microsoft access able to be accessed by
smartphone or not.... here i giv a brief idea on wat i mention...

for example, i hav a web-service with database, the database is powered by
Microsoft Access file, and all update for the database is tightly connected
by ODBC... everything works fine....

however, i hav to build a application for smartphone by using .NET.. if not
mistaken, it would b datagrid to retrieve the data... i notice that SQL CE
work fine wif that, but how abt the database is *.mdb from microsoft
access..? isn't it possible for us to use the same database file as the
web-service ones..?

the reason for me to do so is, the SQL Server web hosting is too expensive
for us... if connectivity of database by ODBC the cost is acceptable for us
since we are doin school project...

hope somebody out here giv me some idea.... thanks a lot...


cheers,
wong
 
B

Brendan Reynolds

I haven't seem a smart phone yet, or heard much about them, but using the
..NET Compact Framework you can build web pages that connect to Jet (MDB)
databases via either the ODBC data provider or (better) the Jet OLEDB data
provider, and display on a PDA, Blackberry, or plain old ordinary mobile
(cell) phone, so I guess they should display OK on a smart phone. Basically,
they should display on just about any device with a web browser.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top