做odbc的数据源啊
或者直接
如:
<%
dim conn
set conn=server.createobject("adodb.connection")
conn.connectionString="driver={SQL Server};Server=youserver/ip;pwd=***;database=yourdatabase"
conn.open
%>
或者直接
如:
<%
dim conn
set conn=server.createobject("adodb.connection")
conn.connectionString="driver={SQL Server};Server=youserver/ip;pwd=***;database=yourdatabase"
conn.open
%>
2.它提示用户名、密码不对吗,如果不是,是提示的什么
3.
Dim strconn
strconn="Provider=SQLOLEDB.1;Password=1234;Persist Security Info=True;User ID=sa;Initial Catalog=dbname;Data Source=192.168.1.27"On Error Resume Next
set conn=server.createobject("adodb.connection")
'这里设定连接超时为10秒
conn.ConnectionTimeout=10
conn.Open strconn
If conn.Errors.Count > 0 Then
Response.write "连接数据库失败!可能网络不通或数据库……"
Response.End()
End If