asp 連結 access 資料庫
今天在寫網頁時,因為懶得寫後端的管理程式,想說用 access 資料庫,就可以偷懶,讓管理者直接用 access 來處理資料就好,可是在連結資料時一直很不順,有時可以有時不行,重整又可以,一會兒又不行,真是xxx,後來在微軟網站找到問題.
本來的連結:(第一種方法)
SET CN=SERVER.CREATEOBJECT("ADODB.CONNECTION")
CONN.OPEN "DRIVER={MICROSOFT ACCESS DRIVER (*.MDB)};DBQ=" & SERVER.MAPPATH("資料.mdb")
後來更正的連結:(第二種方法)
Set CN=Server.Createobject("ADODB.connection")
CN.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("資料.mdb")
網站上說:
第一種是舊方法,主要是給 access97 用
第二種較新,是給 access2000 用
所以改用第二種連結方式問題就解決了
2010/07/01
office2007用
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Fname 'Access 用
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Fname & ";Extended Properties='Excel 12.0 Xml;HDR=YES';" '連接EXCEL文件
必須到 microsoft 下載 AccessDatabaseEngine.exe
迴響
asp 連結 access 資料庫 | 豬窩
Oh my goodness! Amazing article dude! Thank you so much, However I am going through difficulties with your RSS.
I don't know the reason why I am unable to join it.
Is there anybody getting similar RSS issues? Anyone that knows the
answer can you kindly respond? Thanx!! adreamoftrains
best website hosting
asp 連結 access 資料庫 | 豬窩
I got this web page from my buddy who informed me about this web site and at the moment this time I am
browsing this site and reading very informative articles here.
asp 連結 access 資料庫 | 豬窩
fantastic points altogether, you just gained a logo new reader.
What may you suggest about your submit that you simply made a few days ago?
Any sure?
asp 連結 access 資料庫 | 豬窩
Excellent post! We will be linking to this great content on our site.
Keep up the good writing.