<%
dim a,b,c
set a=server.createobject("adodb.connection")
a.open"driver={ sql server};server=ip地址;uid=ss;pwd=12331233;database=student"
b="select * from xsjk"
set c=server.createobject("adodb.recordset")
c.open b,a
response.write c("user")&"<br>"%>
dim a,b,c
set a=server.createobject("adodb.connection")
a.open"driver={ sql server};server=ip地址;uid=ss;pwd=12331233;database=student"
b="select * from xsjk"
set c=server.createobject("adodb.recordset")
c.open b,a
response.write c("user")&"<br>"%>
Public Function InsertLargeTeam(ByVal ACode As String, ByVal AName As String) As String
Const SqlStat As String = "Insert into largeteam(ltno, ltname) values(@no, @name)"
Dim sError As String Dim cntLt As New SqlConnection("data source=192.168.0.250,1433;user id=sa;password=;database=violation")
Dim cmdLt As New SqlCommand(SqlStat, cntLt)
Me.AddParameter(cmdLt, "@no", ACode)
Me.AddParameter(cmdLt, "@name", AName)
cntLt.Open()
Try
cmdLt.ExecuteNonQuery()
sError = ""
Catch e As Exception
sError = e.Message
Finally
cntLt.Close()
End Try
Return sError
End Function
来定义链接对象就可以了,我也是做asp.net开发的,一直用的这种方法
没有问题。
ConnectionString="data source=208.174.58.25;initial catalog=CNPC;password=8498489;persist security info=True;user id=anstinus;workstation id=Pompei;packet size=4096"
1、为什么总是要用data source=ip地址来连接?可不可以也用server=XXX来连接?具体应该怎么做?
2、如果一个ip地址下装有多个SQL server2000服务器,那通过ip地址怎样来区分?
我不知你為什麼要在一個IP下裝多個SQL server服務器,你完全可以裝一個,然後建多個Database