Win7 ASP連接數據庫“未找到提供程序.該程序可能未正確安裝”問

今天調試了基于Access數據庫的ASP應用，沒想到IIS7報錯，提示ADODB.Connection 錯誤 '800a0e7a' 未找到提供程序。該程序可能未正確安裝 ASP連接數據庫的連接字符串是Provider=Microsoft.Jet.OLEDB.4.0; Data Source=路徑，采用的是OleDB方式連接，問題可能就出在OleDB方式連接這一環節上。

后來搜索網絡得到了解決的辦法 。原來是自己裝的64位Windows 7系統的原因，默認64位環境下，IIS應用程序池未啟用32位應用程序，我們只需要啟用一下就可以了。打開IIS 7，定位到“應用程序池”，然后選擇使用OleDB方式連接數據庫的程序池，然后將啟用32位應用程序設置為True就可以了。



Using MyODBC with ASP.NET in IIS7 on Vista x64

That's a heck of a title, but it's a problem I hit recently. I have a bunch of ASP.NET sites that use MySQL as their datastore, but I hadn't tried the on IIS7 yet. It took a while to get them to work at all (I had to set permissions on web.config and the other website files so that they could be read by both the Users group and the IIS_IUSRS group), but then I was left with an error about my MySQL connection. “ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified” 主站蜘蛛池模板： 陇川县| 枝江市| 二手房| 沂南县| 抚宁县| 邹城市| 苗栗市| 财经| 岑巩县| 呼伦贝尔市| 南木林县| 株洲县| 安新县| 宁阳县| 平昌县| 扶绥县| 周至县| 璧山县| 类乌齐县| 图们市| 宁津县| 齐齐哈尔市| 宁陵县| 临沂市| 焉耆| 繁昌县| 莱芜市| 巍山| 许昌县| 井冈山市| 浠水县| 临猗县| 新野县| 当涂县| 保定市| 乌鲁木齐县| 临漳县| 蚌埠市| 高清| 大姚县| 新蔡县|