 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
Before you begin you should check to make sure that you have MDAC v2.1 SP2 or later installed on yourserver. To get the latest MDAC goto http://www.microsoft.com/data. If you are unsure which version of MDAC you have installed Microsoft provides a tool called ComCheck which will tell you. A basic OLEDB Connection String looks like this: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:db1.mdb" Of course you will have to replace the path above ("c:db1.mdb") with the path and filename of your own database. If the database is located on an ISP\\'s server and you don\\'t know the physical path of your database you can use the Server.Mappath() function. Eg: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("/db1.mdb") However it is not recommended that you place your database in a folder that has IIS read permissions enabled (as any casual web-browser will be able to download the file if the filename is known). It is recommended that you assign your connection string to an application level global variable or create an include file that contains code that assigns the connection string to a local variable (with the include file being included on each page that requires a database connection). This way if your database ever changes you only need to make one change to your code to enable it to connect to your new database. Eg (in your global.asa): Sub Application_OnStart Application("strDBConnectionString") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:db1.mdb" End Sub You may need to specify additional parameters for the connection string (eg a User ID and Password, if you have placed a UserName/Password restriction on the database). The following is a list of additional parameters that can go into the connection string. Each parameter takes the form of: parameter name=value and is separated from the next parameter by a ; User ID (default: User ID=Admin) Password (default: Password="") Mode Extended Properties Jet OLEDB:System Jet OLEDB:Registry Path Jet OLEDB:Database Password Jet OLEDB:Engine Type Jet OLEDB:Database Locking Mode Jet OLEDB:Global Partial Bulk Ops Jet OLEDB:Global Bulk Transactions Jet OLEDB:New Database Password Jet OLEDB:Create System Database Jet OLEDB:Encrypt Database Jet OLEDB:Don\\'t Copy Locale on Compact Jet OLEDB:Compact Without Replica Repair Jet OLEDB:SFP For a comprehensive list of connection strings (Access or otherwise) check out this page over at Able Consulting. 返回类别: 教程 上一教程: ASP进阶教程Ⅸ：留言查询功能（二） 下一教程: ASP+上载例子 您可以阅读与"样设置为使用OLEDB连接我的Access数据库？"相关的教程: · 通过ASP与ACCESS数据库建立连接（附源码）(1) · 数据库连接代码(SQL SERVER、ORACLE、ACCESS) · 通过ASP与ACCESS数据库建立连接（附源码）(2) · 通过ASP与ACCESS数据库建立连接(附源码)(3) · 解决使用ASP无法连接ORACLE 9I数据库的问题 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
