奇怪问题
出现这样的错误:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
过一会又恢复正常了
连接方式是:
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("/count/mdb/counter.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
如果换成:
connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+server.mappath("/count/mdb/counter.mdb")+";Persist Security Info=False"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
这种连接方式,更奇怪,出现这样的错误
Syntax error in FROM clause.
/count/index.asp, line 60
60: sql ="select * from counter"
居然提示from子句错误
是什么问题呢?有谁遇到过?