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

[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

 

[Alex Feinman [MVP]]

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

 

[Leonardo Castillo]

Thanks Alex,

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

Leonardo Castillo.

 

[Alex Feinman [MVP]]

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)

 

[Leonardo Castillo]

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.

 

[Alex Feinman [MVP]]

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)

 

[Leonardo Castillo]

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.