asp.net怎样连接SQL server2000?我看到书上的一个例子是这样写的:
Dim connstring As String
Dim As String
Dim conn As New SqlConnection
Dim i As Integer, j As Integer
connstring = "data source=local;
connstring &= "Integrated security=sspi;"Initial catalog=test"(test是我在sql2000中建立的一个表)
conn.ConnectionString = connstring
conn.Open()
但是总是连接不上,高手帮帮忙!
------解决方案--------------------------------------------------------
- VB.NET code
Dim connstring As String Dim As String Dim conn As New SqlConnection Dim i As Integer, j As Integer connstring = "ata source=localhost; connstring &= "duid=SQL2000用户名;pwd=SQL2000密码;database=连接的数据库 conn.ConnectionString = connstring conn.Open()
------解决方案--------------------------------------------------------
c#的一个例子
- C# code
string myConnStr="Data Source=locolhost;";myConnStr+="Initial Catalog=数据库;";//注意“数据库”是你想连接的数据库(一定是数据库,不能是表)myConnStr+="Integrated Security=true";SqlConnection myConn = new SqlConnection(myConnStr);try{ myConn.Open();}catch (SqlException SqlEx){ this.Response.Write("错误:<br/>" + SqlEx.Message.ToString());}finally{ if (myConn.State == ConnectionState.Open) { myConn.Close(); }}