General Network Error - Connecting Pocket PC with SQL Server (Desktop)

  • Thread starter Thread starter Leonardo Castillo
  • Start date Start date
L

Leonardo Castillo

I need to connect from a program in the Pocket PC to SQL Server in my
desktop. (I need an information in one table in SQL Server 2000).

However i get a following error message
"General network error".

This is the code:

Dim xx As New SqlClient.SqlConnection("Data
Source=LEOC2004;DataBase=cas;User ID=sa;Password=sa")

Try

xx.Open()

Catch exSQL As SqlClient.SqlException

MsgBox(exSQL.Message)

End Try

(The SQL Server Name (instance) is LEOC2004).

Thanks



Leonardo Castillo
 
Try using SQL Server IP address instead of name. I'm pretty sure you are
hitting a name resolution problem.
 
Thanks Alex,

However the problem is still the same. Any other ideas? Has any
configuration in the ActiveSync for solve this problem?

Leonardo Castillo.
 
If you happen to have a web server on that machine, can you open a page on
it using Pocket IE?
Also, how are you connected to the network? WiFi or ActiveSync?
Another thing to check is under
Settings/Connections/Connections/Advanced/Network Card choose My network
Card connects to Internet (this is if you are using IP address)
 
Ok.

I can open a page from the web server, however the pocket ask a user and
password. This is probably the problem.
I connect via ActiveSync

I try again and sent to this forum the results.

Thanks again

Leonardo Castillo.
 
No, password will not be a problem, but if you have another PC, try checking
that you can access this SQL Server from it. One of the reasons for what you
are seeing might be a firewall (if you have one)
 
Thanks Alex. The problem is in the machine with SQL Server. I change the
connections driver and the problem has been fixed.

Thanks again for your time.

Leonardo Castillo.
 
Back
Top