Win CE connect to SQL server from by network

See more:

.NETCF

SQL-Server

Hello All,

I have a question regarding the Win CE(compact framework) with SQL server.

i writing a program by using compact framework in Win CE, i will use window authentication to connect SQL server by network(WIFI). most of the time the program can connect to the server, but sometime the PDA unable to connect to the server.(seldom happen)
once it happen then the production will become messy, below is the exception:

i get the SQLexception is - "General network error. Check your network documentation".

here is stack-trace :

at System.Data.SqlClient.SqlConnection.OnError()
at System.Data.SqlClient.SqlInternalConnection.OnError()
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib()
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run()
at System.Data.SqlClient.SqlInternalConnection.Login()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at MAX_DKNYI.login.btnLogin_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Button.OnClick()
at System.Windows.Forms.ButtonBase.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
i get some suggestion from the MSDN but it look like not really suit to me. (it mention upgrade the server's service pack or hotfix)
but i have try to change the different testing server in the PDA connection, it still the same, so mostly is not the server problem.

i using window authentication method to connect to server with the domain name. example as below;
Data Source=192.168.1.10;Initial Catalog=MyNewDB;Integrated Security=SSPI;User ID=DOMAINNAME\testuser;Password=testpassword;
i believe now is not the domain problem, but don't know how to settle.


hopefully someone can provide some idea/solution for this.
thanks