SQL Server Driver Timeout expired

来源:互联网 发布:淘宝联盟怎么自己买 编辑:程序博客网 时间:2024/06/03 05:07

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Microsoft][ODBC SQL Server Driver]Timeout expired

 设定:
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 15 '必须在open之前调用
conn.CommandTimeout = 30 '一般在open之后设置
conn.CursorLocation = 3
conn.ConnectionString = "driver={SQL Server};server=.;uid=sa;pwd=***;database=mdb"
conn.Open

 

 

原创粉丝点击