早上调试程序的时候出现如下问题: 执行到 Conn.Open();时报错; 错误提示:System.NullReferenceException: 未将对象引用设置到对象的实例。代码如下: SqlConnection Conn = new SqlConnection(); Conn.ConnectionString = "data source=127.0.0.1;persist security info=False;initial catalog=flyhouse;user id=sa; password=;Max Pool Size=512";
Conn.Open();堆栈跟踪:
[NullReferenceException: 未将对象引用设置到对象的实例。]
LoadLibraryW(UInt16* ) +0
System.EnterpriseServices.Thunk.Security.Init() +76
System.EnterpriseServices.Thunk.Security.SuspendImpersonation() +81
System.EnterpriseServices.Platform.Initialize() +503
System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb) +11
System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl) +797
System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl) +170
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +358
System.Data.SqlClient.SqlConnection.Open() +384
WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) in f:\w文件备分\flyhouse\programe\webapplication3\webform1.aspx.cs:34
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Conn.Open();堆栈跟踪:
[NullReferenceException: 未将对象引用设置到对象的实例。]
LoadLibraryW(UInt16* ) +0
System.EnterpriseServices.Thunk.Security.Init() +76
System.EnterpriseServices.Thunk.Security.SuspendImpersonation() +81
System.EnterpriseServices.Platform.Initialize() +503
System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb) +11
System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl) +797
System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl) +170
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +358
System.Data.SqlClient.SqlConnection.Open() +384
WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) in f:\w文件备分\flyhouse\programe\webapplication3\webform1.aspx.cs:34
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
写成这样不是更方便么
connectionString="server=172.16.1.6;User ID=rrr;Password=rrr;database=rrr_portal;Provider = SQLOLEDB.1;Connection Reset=FALSE"
是库吧?
static string StrConn = "workstation id=202.134.127.77;data source=202.134.127.77;initial catalog=Yellowpage;user id=sa;password=grt2006";SQL2005:
con = new SqlConnection(@"Server=.\SQLExpress;Database=db_CMS;Persist Security Info=True;User ID=sa;Password=Masslong");
数据库连接字符串有点问题=。=
===========================================》
一般是正常如何写的?
会不会是数据库的原因?
问题出在这,改大一点或者重启电脑
最大就是512了
这个问题可不简单,楼主出400分也不一定有人解决得了,以前提这问题的人多了去了,就没见结帖的,哈哈,没办法,怀疑与操作系统版本或某些设置有关系
----------------------------------------------------------------》
TO:hengwang007(★★★★★) (冒充5星的)
问题解决了```方法很简单 ```我重启了下就可以了````` 现在准备买块豆腐撞死
非常感谢 楼上的朋友的回复``