all groups > sql server connect > may 2006 >
You're in the

sql server connect

group:

Mobile 5.0 app can not connect to SQL 2005 Express


Mobile 5.0 app can not connect to SQL 2005 Express RedHair
5/31/2006 12:18:21 PM
sql server connect: I'm using VS2005 pro to develop one windows form and one Mobile5.0 app ,
they are simple apps and just connect to SQL server to get data. The SQL
servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5
Express.

All works fine until one day I updated Win2K3 patches to the sql server via
windows update.
The mobile 5.0 app can not connect the SQL 2005 express any more, it will
get error message:
"Can not find specific sql server SERVERNAME\SQLEXPRESS", I didn't change
any codes
or settings. But it still can connect to SQL2000 or SQL 2005 std.

The Windows app is able to connect to SQL2000/SQL2005 std/SQL 2005 express
without
any problem.

Any clue? thanks in advance!




Re: Mobile 5.0 app can not connect to SQL 2005 Express rick
6/1/2006 5:23:31 AM
Apparently, that's not a supported configuration. I'd seen that some
people had tried it and gotten it to work, so maybe MS did something
active to turn it off.
Re: Mobile 5.0 app can not connect to SQL 2005 Express Roger Wolter[MSFT]
6/1/2006 3:46:22 PM
I don't know why it wouldn't be supported. I assume you are using SQLClient
to connect to SQL Express? Do you get an error message on the client? Are
there any errors in the SQL Express error log?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: Mobile 5.0 app can not connect to SQL 2005 Express RedHair
6/2/2006 12:00:00 AM
Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
The problem here is it works for SQL 2005 Express in the begining.
But it's failed after applying windows 2003 patches.


"Roger Wolter[MSFT]" <rwolter@online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:OXJ020chGHA.3756@TK2MSFTNGP02.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button