ASP 数据库连接

小林飞刀

'ACCESS 2007
conn.open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source="&Server.MapPath(db)

---

'ACCESS 2003
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.MapPath(db)

---

'SQL 2005
conn.open "Driver={SQL Server};Server=JANKU-20100427;Database=bysj;Uid=jaly; Pwd=123;"
conn.open "Provider=SQLoledb;data source=JANKU-20100427;Initial Catalog=bysj;UID=jaly; PWD=123"


作者：林剑坤
日期：2011-5-14 11:42:01