asp与access的连接问题?
set adocon=server.createobject("adodb.connection")
adocon.open "/mdb/aspbook"
set sal=adocon.execute(sqlstr)
在调试时总现
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
求教!!!
问题点数:20、回复次数:7Top
1 楼yxh_yzh(浪迹天涯)回复于 2002-01-08 19:33:01 得分 10
set dbconnection = Server.createobject("adodb.connection")
'DBPath="M:\jinlu.com\jsw\jsw management\tongji\webdb.mdb"
DBPath="e:\yxh\webdb.mdb"
dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
set rst=server.createobject("adodb.recordset")
sql="select * from fileaccess where href = '"&strDataUrl&"' and accesstime = #" &date()&"#"
rst.open sql,dbconnection ,1,3
Top
2 楼yxh_yzh(浪迹天涯)回复于 2002-01-08 19:33:26 得分 0
一定没有问题Top
3 楼beyond_xiruo(CorruptionException)回复于 2002-01-08 19:48:20 得分 5
set adocon=server.createobject("adodb.connection")
adocon.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & server.mappath("aspbook.mdb")
sqlstr="select * from tablename"
set sal=adocon.execute(sqlstr)Top
4 楼lanying(蓝鹰)(问个不休)回复于 2002-01-08 19:53:34 得分 0
老兄,这样可不行呀,还是多看看书吧?Top
5 楼guiguai(鬼怪)回复于 2002-01-08 19:56:08 得分 5
set adocon=server.createobject("adodb.connection")
adocon.open "driver={Microsoft Access Driver (*.mdb)}; dbq=" & server.mappath("/mdb/aspbook")
set sal=adocon.execute(sqlstr)Top
6 楼sky_line(浪迹天涯)回复于 2002-01-08 20:08:16 得分 0
问题还没解决
Top
7 楼mygia(www.gzcost.com)回复于 2002-01-09 12:39:17 得分 0
学习中。。。Top





