direct database connection

  • Thread starter Thread starter Gogy
  • Start date Start date
G

Gogy

Can I establish a direct database connection to MSSQL 2000 with .NET CF
through ActiveSync 4.1?
 
I'm using MS Loopback on PC:
IP Address. . . . . . . . . . . . : 192.168.55.102
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.55.100

On PPC which is conneted with PC over ActiveSync (USB):
IP Address. . . . . . . . . . . . : 192.168.55.102
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.55.100

With vxUtil I can't ping PC from PPC.
With ping I can't ping PPC from PC.

Thanks.
 
My loopback adapter, using the default ip address, is at 169.254.25.129 with
a subnet mask of 255.255.0.0 and no default gateway, but I can connect to
SQL Servers using the ip address. I never tried pinging from one to the
other. If you have IIS running on your pc you could try surfing from the
PPC. Are you sure you have tcp/ip enabled for your server? SQL Express, for
example, has that disabled by default.
 
What version of activesync are you using, as I thought the newer (ie.
4.1, 4.2) versions the ip address that the device gets is 169.254.2.1
(this is what my device is reporting in vxUtil when you press the 'I'
button...), and my pc gets the address 169.254.2.2 (which you can see
because activesync 4.x makes a new network adapter appear in the
connections on the device and assigns it an IP address).

You can use the name 'PPP_Peer' on the device to get to your desktop
machine through the activesync connection, as it's resolved to the
address activesync is giving the device.

Matt
 
Matt,

You're right that PPP_PEER does resolve to a network address on the PC, but
for WM 5 it doesn't resolve to a network address that SQL Server listens on.
 
Ahhh, yes, because that network adapter is only there when you are
connected via activesync. Our application talks to our server software
via activesync ok, its a tcp connection on port 2000, and once the
device is activesync'd the device can talk to an instance running on my
local pc that the device is connected to, or on servers on our network.

Although I have been having problems on the device resolving dns to get
my pc's ip address (maybe our network), so I changed to ppp_peer and it
works great. But my server software is listening on IpAddress.Any, and
it seems to pick up the new adapter when it appears, even if it's not
there when it starts listening.

Matt
 
Good to hear, Matt. I was never able to get that to work with my servers
even when connected with Activesync, but I think IpAddress.Any could be the
key.
 
Back
Top