|
|
You're in the
dotnet compact framework
group:Accessing SQL Server database via Activesync
dotnet compact framework:
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. [quoted text, click to view] "Andy Baker" <abaker@NOSPAMvanputer.com> 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 > >
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
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 [quoted text, click to view] 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" <abaker@NOSPAMvanputer.com> 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 >> >> > >
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. [quoted text, click to view] "Andy Baker" <abaker@NOSPAMvanputer.com> 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" <abaker@NOSPAMvanputer.com> 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 >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |