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

[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 ?

 

[Lloyd Dupont]

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?

 

[Zanna]

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?

Have you checked to have the SQLserver SP installed: SQLserver without SP is
inaccessible for PocketPC.

 

[Lloyd Dupont]

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 ?

 

[Zanna]

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 ?

Yes, SP for SQLserver.

Take a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

You can search for the latest SP at microsoft site (I think you can find it
at http://support.microsoft.com)

Fabio