如何连接ACCESS数据库?不用odbc

如何连接ACCESS数据库,不用odbc
---------------------------------------------------------------

1   
2set objCon=server.createobject("adodb.connection")   
3dbpath=server.mappath("you_database.mdb")   
4objCon.open "Driver={Microsoft Access Driver (*.mdb)}; dbq="&dbpath   

---------------------------------------------------------------

这不还是ODBC嘛!

OLEDB连接是
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据库文件名
---------------------------------------------------------------

connstr="PROVICER=MICROSOFT.JET.OLEDB.4.0;
DATA SOURCE=c:\abc\abc.mdb"
set conn=server.createobject("adodb.connection")
conn.open connstr

---------------------------------------------------------------

http://expert.csdn.net/Expert/topic/1546/1546594.xml?temp=.5030786
---------------------------------------------------------------

来晚了,数据连接有三种方式

DSN ,DSN-LESS OLEDB
楼主说的应该是不用DSN,1981的是DSN-Less 楼上的是OLEDB

Published At
Categories with Web编程
comments powered by Disqus