connect to a remote SQLServer (CompactFramework)

[Guest]

Hello, I'm going to try to explain my problem. Excuse my English. There are
a DB stored at a server that is placed at another city. I've the external IP,
the ID and the Password. If I do a ping with my pocket I obtain response.
I've an object connection (SqlClient.SqlConnection) whose properties are OK
(ID ok, Password ok...) but when call to connection.Open then wait and it
doesn't work (Cann't found server).
If I change the Server to a local machine, it's works. The pocket (I've
tried with Wmobile 2003 and WM2003SE) has access to the internet by LAN. Can
anybody help me? Thanks

 

[Morten Wennevik]

Hi David,

Just a question, is the Server accepting Sql Server Connections? (The
Default is Windows connections only). You can also check the validity of
your connection string from this web site

http://www.connectionstrings.com

 

[Guest]

Morten, I can connect to the server whith a simple program in VB6. I think
the connection string is ok.
Thanks