我觉着在asp里,连接数据库是件很不稳定的情况,不久前刚刚能用的,现在又不能用了,虽然环境是有了一些变化,但真的很烦心,记录下最新用OLEDB连接成功地代码吧,方便以后复用,加上了错误提示
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER = SQLOLEDB;Data Source=.\LOCAL;user ID=sa;Password=000000;inital Catalog=msgdb"
Data Source = 数据库路径地址
'连接出错则报错'
If Err Then
Response.Write "数据库连接错误<br />"
Response.Write Err.Number&"<br />"
Response.Write Err.Source&"<br />"
Response.Write Err.Description&"<br />"
Err.Clear
Response.End
End If