UC知道关于SQL数据库连接问题!请高手解答!
来源：百度知道 编辑：UC知道 时间：2024/06/06 10:10:57
<%
'Dim StrServer,StrUid,StrSaPwd,StrDbName
StrServer="(local)"
StrUid="happy20001"
StrSaPwd="#$TSDF22sald"
'StrServer="61.142.81.27"
'StrSaPwd="sz@))%chwl"
StrDbName="chwl"
'Dim Conn,StrDSN,Rs
StrDSN = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & StrUid & ";PWD=" & StrSaPwd & ";Initial Catalog=" & StrDbName & ";Data
Source=."
'StrDSN="driver={SQL server};server="&StrServer&";uid="&StrUid&";pwd="&StrSaPwd&";database="&StrDbName
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.RecordSet")
Conn.Open StrDSN
'Dim StrServer,StrUid,StrSaPwd,StrDbName
StrServer="(local)"
StrUid="happy20001"
StrSaPwd="#$TSDF22sald"
'StrServer="61.142.81.27"
'StrSaPwd="sz@))%chwl"
StrDbName="chwl"
'Dim Conn,StrDSN,Rs
StrDSN = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & StrUid & ";PWD=" & StrSaPwd & ";Initial Catalog=" & StrDbName & ";Data
Source=."
'StrDSN="driver={SQL server};server="&StrServer&";uid="&StrUid&";pwd="&StrSaPwd&";database="&StrDbName
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.RecordSet")
Conn.Open StrDSN
StrDSN = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & StrUid & ";PWD=" & StrSaPwd & ";Initial Catalog=" & StrDbName & ";Data
Source=."
将中间的多余的空格与换行去掉
StrDSN = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & StrUid & ";PWD=" & StrSaPwd & ";Initial Catalog=" & StrDbName & ";Data Source=."
<%
SQLServerName="127.0.0.1" '服务器名称或IP地址
SQLUserName="sa" '数据库帐号
SQLUserPWD="111111" '数据库密码
SQLDataBase="luokun" '数据库名称
'数据库连接
'On Error Resume Next '容错声明
response.buffer=true
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open"Provider=sqloledb;user id="&SQLUserName&";password="&SQLUserPWD&";initial catalog="&SQLDataBase&";data source="&SQLServerNam