Sunday, March 11, 2012

connection from windows mobile 5.0

Hi,
I have written some software for a windows mobile 5.0 device that
connects to a sql server directly and performs various operations
against a database.
Under sql server 2000 and XP, I had no problems doing this using
ActiveSync and/or via wireless tcp connections with a vpn connection
to the desktop.
However, since I switched to MS Vista and SQL Server 2005 (Developers
Edition), I can only connect while using Mobile Device Center
(ActiveSync).
What's confusing to me is that when I am connected wirelessly using a
VPN connection to the Vista machine, I'm on the same subnet as the
desktop/SQL Server. While using ActiveSync (MDC), I'm on a completely
different subnet. SQL Server connections function fine through
ActiveSync, but not over the VPN.
How do I configure SQL Server to allow these wireless/vpn connections?
Is this even a SQL Server setting?
Thanks for any and all help.
Charlie
Ok. I figured it out. My device is not resolving the host name
correctly. I configured the connection string to use the IP address
and it connects fine.
Thanks,
Charlie

No comments:

Post a Comment