can i pull data from a sql server express 2005 db onto my ce device?

Will my 'smart device application' designed with VS.Net 2005 allow my ce
device to pull data from a SQL Server EXPRESS 2005 database residing on the
server computer? Or must I be using the full version of SQL Server 2005 to
accomplish this movement of data between my ce device and my server
computer?
Thanks!
hi Jesse,
Jesse Aufiero wrote:
> Will my 'smart device application' designed with VS.Net 2005 allow my
> ce device to pull data from a SQL Server EXPRESS 2005 database
> residing on the server computer? Or must I be using the full version
> of SQL Server 2005 to accomplish this movement of data between my ce
> device and my server computer?
>
i you mean, for instance, querying a SQLExpress instance via (say) wi-fi
connected CE devices, then yes.. just verify the SQLExpress instances allows
remote connections..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||thanks, i need to know specifically if a vs.net 2005 smart device
application can issue an RDA pull method (like i was able to do with vs.net
2003) to a sql server express 2005 database residing on a remote server
computer.
i'm actually hoping that someone can answer the question or point me to an
article so that i don't have to go through extensive r&d to determine if it
can be done. normally i would be more than happy to do this r&d, however,
to answer this seemingly simple question would require that i purchase and
install vs.net 2005, install sql server express 2005, learn how to use them,
write test applications, install the test applications to devices, etc.
before i go down this expensive and arduous road, i figured maybe someone
might know the answer off the top of their head. ah, the beauty of
newsgroups!
thank you
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:42i54eF1jj877U1@.individual.net...
> hi Jesse,
> Jesse Aufiero wrote:
> i you mean, for instance, querying a SQLExpress instance via (say) wi-fi
> connected CE devices, then yes.. just verify the SQLExpress instances
> allows remote connections..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>