<%
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr ="Provider=SQLOLEDB.1;Password=123;" & _
"Persist Security Info=True;User ID=sa;" & _
"Initial Catalog=tssgajzbc;" & _
"Data Source=a4eb66b5bfd242a;Connect Timeout=15"
conn.Open connstr
%>
这段代码我看不懂。
參考答案:我猜想你的数据库与IIS是在同一台机器,在此假设的基础上,做如下修改:
将下面这句
connstr ="Provider=SQLOLEDB.1;Password=123;" & _
"Persist Security Info=True;User ID=sa;" & _
"Initial Catalog=tssgajzbc;" & _
"Data Source=a4eb66b5bfd242a;Connect Timeout=15"
修改为:
connstr ="Provider=SQLOLEDB.1;DATA SOURCE=(local);" & _ "Password=123;" & _
"User ID=sa;" & _
"DATABASE=tssgajzbc;" '这里假设数据库的名字是tssgajzbc
祝你好运!