SQL Server Communication WHILE docked.

[Eric S. Blake]

Hi:

Hope this is a simple one. Simply stated this code functions while PDA is
NOT DOCKED and connected to network via WIFI, once docked this code fails to
connect to my server.

Am I doing something wrong?? Any help of suggestions would be appreciated!

Eric.

Private Const strConnection As String = _
"Server=serveripaddr;" + _
"User ID=id;password=pw;" + _
"Persist Security Info=True;Integrated Security=false;Connect Timeout=5;" +
_
"initial catalog=myDatabase;"

Public Function Check_Connectivity(Optional ByVal strState As String =
"TEST") As Boolean
'-------------------------------------------------------------------------------------------
' Function: CheckConnectivity Mod:08/04/2005 Programmer: Eric
S. Blake
' Check Connectivity See if we have Internet Access....
'-------------------------------------------------------------------------------------------
Dim sqlConn As New SqlClient.SqlConnection
Dim strConn As String = strConnection
Dim strS As String
Check_Connectivity = False
If strConn <> "" Then
sqlConn = New SqlClient.SqlConnection
sqlConn.ConnectionString = strConn
strS = sqlConn.GetType.ToString
Check_Connectivity = True
Try
sqlConn.Open()
Catch ex As Exception
Check_Connectivity = False
End Try
If Check_Connectivity = True Then
sqlConn.Close()
End If
End If
sqlConn = Nothing
End Function

 

[Darren Shaffer]

while docked, open PocketIE and try to hit your server.
do you have ethernet passthrough enabled in Activesync?
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

 

[Eric S. Blake]

while docked, open PocketIE and try to hit your server.
do you have ethernet passthrough enabled in Activesync?

Yep, I can see internet just fine. I can TS Client to corp servers as
well. Just not seeing SQL Server via tcpip Address\SqlName...