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 資料庫 | 豬窩
Hey There. I found your blog using msn. This is an extremely
well written article. I'll be sure to bookmark it and come back to
read more of your useful information. Thanks for the post.
I'll certainly comeback.
asp 連結 access 資料庫 | 豬窩
Cbd oil that works 2020
I do not even understand how I ended up here, however I believed this post used to be great.
I do not realize who you're however certainly you're going to a famous blogger should you
are not already. Cheers! best rated cbd oil http://t.co/4kPhN7Ek0L cbd oil that works 2020 http://t.co/4kPhN7Ek0L
asp 連結 access 資料庫 | 豬窩
Wow, this article is good, my younger sister is analyzing these kinds of things, thus I am going to convey
her.
asp 連結 access 資料庫 | 豬窩
Does your website have a contact page? I'm having a tough time locating it but, I'd
like to send you an e-mail. I've got some creative ideas for your blog you might be interested in hearing.
Either way, great site and I look forward to seeing it grow
over time.
asp 連結 access 資料庫 | 豬窩
Hey there! I know this is kinda off topic but I'd
figured I'd ask. Would you be interested in trading links or maybe
guest writing a blog article or vice-versa?
My blog covers a lot of the same topics as yours and I feel we could
greatly benefit from each other. If you are interested feel free to send me an email.
I look forward to hearing from you! Excellent
blog by the way!