Access数据库在Web.Config文件中的配置

    技术2022-05-11  22

    在开发中用MSSQL 的多,而Access数据库的少,下面简单说下Access数据库的连接设置:

     

    web.config配置

    <configuration> <appSettings/>  <connectionStrings>    <add name="MyJetConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|/skdb.mdb; Persist Security Info=False;" providerName="System.Data.OleDb" />  </connectionStrings>

    用于测试连接状态的代码:

     

     public string OpenDB()    {        string msg;        OleDbConnection MyOleDB = new OleDbConnection();        MyOleDB.ConnectionString = WebConfigurationManager.ConnectionStrings["MyJetConn"].ConnectionString;        try        {            MyOleDB.Open();            msg = "server vision:" + MyOleDB.ServerVersion + "connection is " + MyOleDB.State.ToString();            return (msg);        }        catch (Exception err)        {            msg = err.Message;            return (msg);        }        finally {            MyOleDB.Close();        }    }

     


    最新回复(0)