PC Review


Reply
Thread Tools Rate Thread

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

 
 
Lloyd Dupont
Guest
Posts: n/a
 
      20th Sep 2004
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 ?



 
Reply With Quote
 
 
 
 
Lloyd Dupont
Guest
Posts: n/a
 
      20th Sep 2004
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 ?
>
>
>



 
Reply With Quote
 
Zanna
Guest
Posts: n/a
 
      20th Sep 2004
"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"


 
Reply With Quote
 
Lloyd Dupont
Guest
Posts: n/a
 
      20th Sep 2004
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"
>
>



 
Reply With Quote
 
Zanna
Guest
Posts: n/a
 
      21st Sep 2004
"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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect to Sqlserver =?Utf-8?B?Rw==?= Microsoft Access 2 6th Apr 2005 05:32 AM
Can't connect to SqlServer anymore! (from PocketPC) Lloyd Dupont Microsoft ADO .NET 4 21st Sep 2004 08:53 PM
Can't connect to SqlServer anymore! Lloyd Dupont Microsoft Dot NET Compact Framework 0 20th Sep 2004 06:06 AM
connect to sqlserver? Papa_K Microsoft ASP .NET 1 20th Oct 2003 01:07 PM
Can't connect to pocketpc? Dave Corun Microsoft Dot NET Compact Framework 8 28th Jul 2003 12:35 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:05 AM.