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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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" <(E-Mail Removed)> ha scritto nel messaggio news:%

> 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.


--
MathParser = "http://www.neodatatype.net"

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> "Lloyd Dupont" <(E-Mail Removed)> ha scritto nel messaggio
> news:%
>
>> 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.
>
>
> --
> MathParser = "http://www.neodatatype.net"
>
>

"Lloyd Dupont" <(E-Mail Removed)> ha scritto nel messaggio


> 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...b;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

--
NeoDataType : http://www.neodatatype.net