Thank you very much for solving this problem
When I use web page to connect Database(SQL Server 2000) by ,I don't know why I can't connect database successfully as following errors
************************************************** ******************
¡°/WroxJokeShop¡±Ó¦ÓóÌÐòÖеķþÎñÆ ÷´íÎó¡£
--------------------------------------------------------------------------------

SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø¡£
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆڼ䣬³öÏÖδ´¦ÀíµÄÒì³ £¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔ Á˽âÓйظôíÎóÒÔ¼°´úÂëÖе ¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£

Òì³£ÏêϸÐÅÏ¢: System.Data.SqlClient.SqlException: SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø¡£

Ô´´íÎó:


ÐÐ 10£º command.CommandType = CommandType.StoredProcedure
ÐÐ 11£º
ÐÐ 12£º connection.Open()
ÐÐ 13£º
ÐÐ 14£º


Ô´Îļþ: D:\E-Tutorial\Self Study\WroxJokeShop\BusinessObjects\Catalog.vb ÐÐ: 12

¶ÑÕ»¸ú×Ù:


[SqlException: SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø¡£]
   System.Data.SqlClient.SqlConnection.Open() +761
   WroxJokeShop.Catalog.GetDepartments() in D:\E-Tutorial\Self Study\WroxJokeShop\BusinessObjects\Catalog.vb:12
   WroxJokeShop.DepartmentsList.Page_Load(Object sender, EventArgs e) in D:\E-Tutorial\Self Study\WroxJokeShop\UserControls\DepartmentsList.as cx.vb:28
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +29
   System.Web.UI.Control.LoadRecursive() +92
   System.Web.UI.Control.LoadRecursive() +92
   System.Web.UI.Page.ProcessRequestMain() +724






Qiang Guo

I am not sure about this error, but I think
that it is character set problem.

character set (china) not properly installed.