DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Mon, 30 Jul 2007 14:00:41 +0100,    posted on: microsoft.public.dotnet.framework.compactframework        back       

Thread Index
  1    Andy Baker
          2    Paul G. Tobey [eMVP] p space tobey no spam AT no instrument no spam DOT com
          3    Andy Baker
                 4    Paul G. Tobey [eMVP] p space tobey no spam AT no instrument no spam DOT com


Accessing SQL Server database via Activesync   
We have an VB.NET 2003 application running on windows CE.NET devices that 
access an SQL Server 2000 database on a PC network. Usually, this is done 
via a WLAN card in each device, and each device logs into the network 
wirelessly, uploads and downloads data, then disconnects, which works well. 
We have one potential customer who has no faith in wireless devices, and 
wants to see an emergency option where if the wireless network doesn't work, 
they can plug the device into a cradle, or connect a cable, and do the 
transfer directly.
    I don't have the option of plugging a wired ethernet card into the 
device, as the slots are hidden from the user, so the only way that I can 
see of doing it is via Activesync. My questions are 1) Is this possible / 
desirable - in my experience I have had many more problems with Activesync 
than I ever have with Wireless connections. 2) The way that the device works 
wirelessly is that 'knows' the static IP address of a PC on the LAN, 
establishes a connection, and connects to the SQL server database directly. 
What changes would I have to make to make it work with Activesync as well? 
Does the PC see the device connected  via Activesync in the same way as it 
would a wireless device? Thanks in advance.

Andy Baker
Date:Mon, 30 Jul 2007 14:00:41 +0100   Author:  

Re: Accessing SQL Server database via Activesync   
You'd have to be a little more-specific about what version of ActiveSync 
you're talking about to be sure, but generally ActiveSync 4.x provides a 
network connection between the device and the PC, or at least the PC's 
network, so you wouldn't have to change anything in your device code.  It 
should be simple to try with a little test code or even with your existing 
program.  What is the connection for AS that the device provides?  USB? 
Serial?  Bluetooth?  What version of ActiveSync is being used?  3.x?  4.x?

Paul T.

"Andy Baker"  wrote in message 
news:46ade0ce$0$1605$ed2619ec@ptn-nntp-reader02.plus.net...

> We have an VB.NET 2003 application running on windows CE.NET devices that 
> access an SQL Server 2000 database on a PC network. Usually, this is done 
> via a WLAN card in each device, and each device logs into the network 
> wirelessly, uploads and downloads data, then disconnects, which works 
> well. We have one potential customer who has no faith in wireless devices, 
> and wants to see an emergency option where if the wireless network doesn't 
> work, they can plug the device into a cradle, or connect a cable, and do 
> the transfer directly.
>    I don't have the option of plugging a wired ethernet card into the 
> device, as the slots are hidden from the user, so the only way that I can 
> see of doing it is via Activesync. My questions are 1) Is this possible / 
> desirable - in my experience I have had many more problems with Activesync 
> than I ever have with Wireless connections. 2) The way that the device 
> works wirelessly is that 'knows' the static IP address of a PC on the LAN, 
> establishes a connection, and connects to the SQL server database 
> directly. What changes would I have to make to make it work with 
> Activesync as well? Does the PC see the device connected  via Activesync 
> in the same way as it would a wireless device? Thanks in advance.
>
> Andy Baker
>
> 
Date:Mon, 30 Jul 2007 08:40:48 -0700   Author:  

Re: Accessing SQL Server database via Activesync   
Thanks for getting back to me. I have 2 different CE devices that both use 
USB connections. The older one was supplied with Activesync 3.7, so I have 
continued using that, although I suppose there is no reason why I shouldn't 
use 4.x. I'll give it a try.

Andy Baker

"Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT 
com> wrote in message news:%23YTDg$r0HHA.4476@TK2MSFTNGP06.phx.gbl...

> You'd have to be a little more-specific about what version of ActiveSync 
> you're talking about to be sure, but generally ActiveSync 4.x provides a 
> network connection between the device and the PC, or at least the PC's 
> network, so you wouldn't have to change anything in your device code.  It 
> should be simple to try with a little test code or even with your existing 
> program.  What is the connection for AS that the device provides?  USB? 
> Serial?  Bluetooth?  What version of ActiveSync is being used?  3.x?  4.x?
>
> Paul T.
>
> "Andy Baker"  wrote in message 
> news:46ade0ce$0$1605$ed2619ec@ptn-nntp-reader02.plus.net...
>> We have an VB.NET 2003 application running on windows CE.NET devices that 
>> access an SQL Server 2000 database on a PC network. Usually, this is done 
>> via a WLAN card in each device, and each device logs into the network 
>> wirelessly, uploads and downloads data, then disconnects, which works 
>> well. We have one potential customer who has no faith in wireless 
>> devices, and wants to see an emergency option where if the wireless 
>> network doesn't work, they can plug the device into a cradle, or connect 
>> a cable, and do the transfer directly.
>>    I don't have the option of plugging a wired ethernet card into the 
>> device, as the slots are hidden from the user, so the only way that I can 
>> see of doing it is via Activesync. My questions are 1) Is this possible / 
>> desirable - in my experience I have had many more problems with 
>> Activesync than I ever have with Wireless connections. 2) The way that 
>> the device works wirelessly is that 'knows' the static IP address of a PC 
>> on the LAN, establishes a connection, and connects to the SQL server 
>> database directly. What changes would I have to make to make it work with 
>> Activesync as well? Does the PC see the device connected  via Activesync 
>> in the same way as it would a wireless device? Thanks in advance.
>>
>> Andy Baker
>>
>>
>
> 
Date:Tue, 31 Jul 2007 08:54:36 +0100   Author:  

Re: Accessing SQL Server database via Activesync   
Well, there are some reasons, but, if you do, I think that this problem will 
just go away.  3.7 has features like the ability to backup and restore a 
device, which 4.x no longer has.  3.7 also has the ability for actual 
syncing to occur over WiFi, which 4.x removes.

Paul T.

"Andy Baker"  wrote in message 
news:46aeea8c$0$1610$ed2619ec@ptn-nntp-reader02.plus.net...

> Thanks for getting back to me. I have 2 different CE devices that both use 
> USB connections. The older one was supplied with Activesync 3.7, so I have 
> continued using that, although I suppose there is no reason why I 
> shouldn't use 4.x. I'll give it a try.
>
> Andy Baker
>
> "Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT 
> com> wrote in message news:%23YTDg$r0HHA.4476@TK2MSFTNGP06.phx.gbl...
>> You'd have to be a little more-specific about what version of ActiveSync 
>> you're talking about to be sure, but generally ActiveSync 4.x provides a 
>> network connection between the device and the PC, or at least the PC's 
>> network, so you wouldn't have to change anything in your device code.  It 
>> should be simple to try with a little test code or even with your 
>> existing program.  What is the connection for AS that the device 
>> provides?  USB? Serial?  Bluetooth?  What version of ActiveSync is being 
>> used?  3.x?  4.x?
>>
>> Paul T.
>>
>> "Andy Baker"  wrote in message 
>> news:46ade0ce$0$1605$ed2619ec@ptn-nntp-reader02.plus.net...
>>> We have an VB.NET 2003 application running on windows CE.NET devices 
>>> that access an SQL Server 2000 database on a PC network. Usually, this 
>>> is done via a WLAN card in each device, and each device logs into the 
>>> network wirelessly, uploads and downloads data, then disconnects, which 
>>> works well. We have one potential customer who has no faith in wireless 
>>> devices, and wants to see an emergency option where if the wireless 
>>> network doesn't work, they can plug the device into a cradle, or connect 
>>> a cable, and do the transfer directly.
>>>    I don't have the option of plugging a wired ethernet card into the 
>>> device, as the slots are hidden from the user, so the only way that I 
>>> can see of doing it is via Activesync. My questions are 1) Is this 
>>> possible / desirable - in my experience I have had many more problems 
>>> with Activesync than I ever have with Wireless connections. 2) The way 
>>> that the device works wirelessly is that 'knows' the static IP address 
>>> of a PC on the LAN, establishes a connection, and connects to the SQL 
>>> server database directly. What changes would I have to make to make it 
>>> work with Activesync as well? Does the PC see the device connected  via 
>>> Activesync in the same way as it would a wireless device? Thanks in 
>>> advance.
>>>
>>> Andy Baker
>>>
>>>
>>
>>
>
> 
Date:Tue, 31 Jul 2007 08:23:54 -0700   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us