首页 >数据库 >mysql教程 >使用ACCESS数据库,连接字符串的配置

使用ACCESS数据库,连接字符串的配置

WBOY
WBOY原创
2016-06-07 15:38:191231浏览

Example of ASP.Net 2.0 Access Database Connection String connectionStrings add name ="accessConnStr" connectionString ="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=|DataDirectory|ajTravelDB.mdb" providerName ="System.Data.OleDb" / / connec

Example of ASP.Net 2.0 Access Database Connection String

 connectionStrings>
    
add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|ajTravelDB.mdb" providerName="System.Data.OleDb"/>
  
connectionStrings>


name

attribute of connectionstrings add element contains the name as accessConStr for the connection string.

connectionString attribute contains the connection string format supported by Oledb drivers. |DataDirectory| is used in the above of connection string to connect the MS Access Database placed inside the App_Data directory. By Default |DataDirectory| maps the path of database file placed inside the default App_Data directory. After |DataDirectory| add up the name of MS Access Database filename as shown in above example.

providerName attribute contains the name of the Namespace of ASP.Net 2.0 that will provide the methods and functions for Data Access while coding.

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn