Sub submit_click(sender as Object,e as eventargs) dim myconnection as Sqlconnection dim mycommand as Sqlcommand dim connStr as String dim now as datetime= datetime.Now myconnection =New Sqlconnection("initial catalog=mydb;data Source=(local)\NetSdK;integrated Security=SSPi;") myconnection.Open() 看一看这些吧。哪里有问题呢? 我的数据库是在本机建立的。 我该怎么改呢?
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=" cookieless="false" timeout="20" />
再在你的程序里检察你的联结字串:
this.sqlConnection1.ConnectionString = "data source=YourComputername;initial catalog=mydatabasename;persist security info=False;user id=sa;" +"password=;workstation id=YourworkstationName;packet size=4096";
dim myconnection as Sqlconnection
dim mycommand as Sqlcommand
dim connStr as String
dim now as datetime= datetime.Now
myconnection =New Sqlconnection("initial catalog=mydb;data Source=(local)\NetSdK;integrated Security=SSPi;")
myconnection.Open()
看一看这些吧。哪里有问题呢?
我的数据库是在本机建立的。
我该怎么改呢?
Me.SqlConnection2.ConnectionString = "data source=local;initial catalog=mydb;integrated security=SSPI;persist security info=False;workstation id=myworkstation;packet size= 4096" 如果这些问题你都解决了,那就应该没有问题了.
或者你可以用icefireren的方法,简单,可靠! 你建立一个连接后,得到字串,再把连接删除.