Can't connect to SqlServer anymore! (from PocketPC)

  • Thread starter Thread starter Lloyd Dupont
  • Start date Start date
L

Lloyd Dupont

I think it might be related to XP SP2, but I have disabled the firewall
already!

Anyway I do some very simple code like that:
//------- OpenConnection ---------
SqlConnection sqlc = new SqlConnection();
sqlc.ConnectionString = "Server=172.16.0.115;Database=Northwind;User
ID=sa;Password=pwd;Trusted_Connection=False";
sqlc.Open();
sqlc.Close();
//-------------------------------

it used to work alright.
I didn't change anything in this code (but I did install SP2)

now it work from ony desktop BUT if I try that from a PocketPC I get:
a SqlException with the message
"General network error. Check your network documentation."

I disabled the windows firewall already (from Control Panel) what else could
I do?

I read on a newsgroup that someone changed the driver and it worked....
I don't quite understand, I just use the System.Data.SqlSclient.dll library
shiped with the compact framework, how could I change it ?
 
I read on some web archive that adding 'Pooling=false' might solve the
problem.
However this is not supported by the Compact franework driver.. any other
ideas?
 
Lloyd Dupont said:
I read on some web archive that adding 'Pooling=false' might solve the
problem.
However this is not supported by the Compact franework driver.. any other
ideas?
Click to expand...

Have you checked to have the SQLserver SP installed: SQLserver without SP is
inaccessible for PocketPC.
 
SQL Server SP???
SP what ?
so you mean the latest service pack for SQL Server?
should it come with Auto-update or should I look for it ?
 
Back
Top