UC知道请帮我写个ASP的连接SQL语句
来源：百度知道 编辑：UC知道 时间：2024/06/22 05:01:21
数据库连接字符串：
name="LogisticsTrackConnectionString" connectionString="Data Source=61.172.200.195;Initial Catalog=YHWL;Persist Security Info=True;User ID=cftms;password=yuhongwuliu" providerName="System.Data.SqlClient
这是提供的字串, 帮我写一个如
<%
set conn="xxx..."
...
%>
可以用的, 谢谢
name="LogisticsTrackConnectionString" connectionString="Data Source=61.172.200.195;Initial Catalog=YHWL;Persist Security Info=True;User ID=cftms;password=yuhongwuliu" providerName="System.Data.SqlClient
这是提供的字串, 帮我写一个如
<%
set conn="xxx..."
...
%>
可以用的, 谢谢
你好 下面经过测试的结果：
data="Provider=SQLOLEDB; Data Source=61.172.200.195; database=YHWL;uid=cftms; pwd=yuhongwuliu"
set conn=Server.CreateObject("adodb.connection")
conn.Open data
祝你成功！
给你个例子
<%
Const SqlDatabaseName = "test" ' 数据库名字'
Const SqlPassword = "123" '数据库密码'
Const SqlUsername = "sa" '数据库帐户'
Const SqlLocalName = "127.0.0.1" '数据库地址'
'数据库连接函数'
Sub ConnectionDatabase
Dim ConnStr
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Respons