MS SQLCE - Dumb easy question

Author

Dumb easy question

CindyLu

2005-04-18, 3:23 am

Using Visual Studio .Net to develop for a mobile application, is the only way
to communicate with a SQL 2000 server to use the SQL CE client (which appears
that even that can't directly communicate with SQL 2000, but must go through
IIS), or is it possible to simply use the Imports System.Data.SQLClient and
use the same code in the mobile app that I would use for a regular Windows
App?

Thanks from an embarrassed newbie

Arun

2005-04-18, 3:23 am

Hi,

use the same code in the mobile app that I would use for a regular
Windows
App?

You can directly use System.Data.SQLClient namespace to connect and
execute your transact SQL queries from Pocket PC directly, provided,
the connected environment is "always", either through WLAN or GPRS. But
the problem is establishing a connection with SQL Server 2000 is very
very slow and you should plan in a way, you should open the connection
at the start of the application and end it when you are closing the
application.

Hope this helps,
Cheers,
Arun.
www.innasite.com

CindyLu

2005-04-18, 8:23 pm

Arun, thank you SO MUCH!!! You only saved me about a bazillion hours of
time. I'm so grateful. Have a great one!!!

"Arun" wrote:

> Hi,
>
> use the same code in the mobile app that I would use for a regular
> Windows
> App?
>
> You can directly use System.Data.SQLClient namespace to connect and
> execute your transact SQL queries from Pocket PC directly, provided,
> the connected environment is "always", either through WLAN or GPRS. But
> the problem is establishing a connection with SQL Server 2000 is very
> very slow and you should plan in a way, you should open the connection
> at the start of the application and end it when you are closing the
> application.
>
> Hope this helps,
> Cheers,
> Arun.
> www.innasite.com
>
>

Sponsored Links