Connect to SQL Server 2000 Database from PDA PPC2003

TheMSsForum.com: The Microsoft Software Forum

Currently I'm using ActiveSync to sychronise the DB. But the automatic
sychronisation only allow me to do every 5 minutes. is there anyway making it
lower than 5 minutes?

Also, is there anyway to Connect to SQL Server 2000 Database from PDA
through Wifi?How?

thanks

Jose
Top

Re: Connect to SQL Server 2000 Database from PDA PPC2003 by Darren

Darren
Tue Aug 16 21:55:59 CDT 2005

If you are using the .NET Compact Framework, you can access a
SQL Server 2000 database using the System.Data.SqlServer namespace
which has functionality very similar to standard ADO.NET syntax.

For your first question, we need much more information about what
your are synchronizing (SQL CE to SQL SVR 2000 ?) and what
synch technology you are using (RDA, merge, custom, etc) before
we can help you improve performance.
--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Jose" <Jose@discussions.microsoft.com> wrote in message
news:BC777327-5DC6-4EB5-9872-3FC52B05A1D6@microsoft.com...
> Currently I'm using ActiveSync to sychronise the DB. But the automatic
> sychronisation only allow me to do every 5 minutes. is there anyway making
> it
> lower than 5 minutes?
>
> Also, is there anyway to Connect to SQL Server 2000 Database from PDA
> through Wifi?How?
>
> thanks
>
> Jose


Top

Re: Connect to SQL Server 2000 Database from PDA PPC2003 by Darren

Darren
Wed Aug 17 11:49:14 CDT 2005

make that System.Data.SqlClient, *NOT* System.Data.SqlServer - sorry for the
typo.

--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com


"Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in message
news:OBN03ctoFHA.1204@TK2MSFTNGP12.phx.gbl...
> If you are using the .NET Compact Framework, you can access a
> SQL Server 2000 database using the System.Data.SqlServer namespace
> which has functionality very similar to standard ADO.NET syntax.
>
> For your first question, we need much more information about what
> your are synchronizing (SQL CE to SQL SVR 2000 ?) and what
> synch technology you are using (RDA, merge, custom, etc) before
> we can help you improve performance.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Jose" <Jose@discussions.microsoft.com> wrote in message
> news:BC777327-5DC6-4EB5-9872-3FC52B05A1D6@microsoft.com...
>> Currently I'm using ActiveSync to sychronise the DB. But the automatic
>> sychronisation only allow me to do every 5 minutes. is there anyway
>> making it
>> lower than 5 minutes?
>>
>> Also, is there anyway to Connect to SQL Server 2000 Database from PDA
>> through Wifi?How?
>>
>> thanks
>>
>> Jose
>
>


Top

Re: Connect to SQL Server 2000 Database from PDA PPC2003 by Frank

Frank
Fri Aug 26 08:52:39 CDT 2005


--------------6379A7F89CAE3FDDC2F9EF9A
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jose'

My company sells a piece of middleware (mEnable) designed for use with the .NET framework that allows you to connect a PPC to any ODBC enabled database using any TCP/IP connection, including WiFi and the Internet.

Details can be found here:

http://www.syware.com/prodlib/win_ce/menable/menable.htm

My Best,
Frank Yacano

Jose wrote:

> Currently I'm using ActiveSync to sychronise the DB. But the automatic
> sychronisation only allow me to do every 5 minutes. is there anyway making it
> lower than 5 minutes?
>
> Also, is there anyway to Connect to SQL Server 2000 Database from PDA
> through Wifi?How?
>
> thanks
>
> Jose

--
-------------------------------------------------------------------
Frank Yacano, Sales.....................mailto://frank@syware.com
SYWARE, Inc.................................http://www.syware.com
Tel: +1 617 497-1300.........................Fax: +1 617 497-8729
Mobile database tools for business and personal productivity
-------------------------------------------------------------------


--------------6379A7F89CAE3FDDC2F9EF9A
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Jose'
<p>My company sells a piece of middleware (<a href="http://www.syware.com/prodlib/win_ce/menable/menable.htm">mEnable</a>)
designed for use with the .NET framework that allows you to connect a PPC
to any ODBC enabled database using any TCP/IP connection, including WiFi
and the Internet.
<p>Details can be found here:
<p><A HREF="http://www.syware.com/prodlib/win_ce/menable/menable.htm">http://www.syware.com/prodlib/win_ce/menable/menable.htm</A>
<p>My Best,
<br>Frank Yacano
<p>Jose wrote:
<blockquote TYPE=CITE>Currently I'm using ActiveSync to sychronise the
DB. But the automatic
<br>sychronisation only allow me to do every 5 minutes. is there anyway
making it
<br>lower than 5 minutes?
<p>Also, is there anyway to Connect to SQL Server 2000 Database from PDA
<br>through Wifi?How?
<p>thanks
<p>Jose</blockquote>

<p>--
<br>-------------------------------------------------------------------
<br>&nbsp;Frank Yacano, Sales.....................<A HREF="mailto://frank@syware.com">mailto://frank@syware.com</A>
<br>&nbsp;SYWARE, Inc.................................<A HREF="http://www.syware.com">http://www.syware.com</A>
<br>&nbsp;Tel: +1 617 497-1300.........................Fax: +1 617 497-8729
<br>&nbsp;Mobile database tools for business and personal productivity
<br>-------------------------------------------------------------------
<br>&nbsp;</html>

--------------6379A7F89CAE3FDDC2F9EF9A--

Top