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!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.|||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
"rick" <rickkozak@.hotmail.com> wrote in message
news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
> 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.
>|||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> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.
phx.gbl...
>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
> "rick" <rickkozak@.hotmail.com> wrote in message
> news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
>|||Sorry, if "failed" is all you're willing to tell us, I don't think we can be
of much help. Depending on which patches you installed, some network or
security setting may have changed.
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
"RedHair" <redhair@.ms40.url.com.tw> wrote in message
news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
> 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>
> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.phx.gbl...
>|||In my orginal post , I have mentioned the error msg is
"Specified SQL server not found: ServerName\SQLEXPRESS"
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OKyb8alhGHA.3584@.TK2MSFTNGP04.phx.gbl...
> Sorry, if "failed" is all you're willing to tell us, I don't think we can
> be of much help. Depending on which patches you installed, some network
> or security setting may have changed.
> --
> 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
> "RedHair" <redhair@.ms40.url.com.tw> wrote in message
> news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment