天天看點

連接配接Accee資料庫不穩定解決方案

    我最最進做了個網站,我是用VS2005 + Access 資料庫連接配接,可以我在連接配接的時候總是出現連接配接不穩定的情況,同樣的代碼,一個字也沒改,就是連接配接不上,但是有的又連接配接的上。真是郁悶,真是弄死人。

    錯誤原因的代碼已經放在如下位址中去了,可以直接進去看。還是連接配接有問》http://www.whzbqc.com/

    我把能連接配接到Access資料庫所有的方式全用了下,結果還是這個樣,連接配接方式如下:

   private OleDbConnection AccessHelp(string str){

        OleDbConnection odbconn = new OleDbConnection();

        try{

            string sStr2 = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=" + Server.MapPath(@"App_Data/#fdaeg35@#gds.mdb");

            odbconn.ConnectionString = sStr2;

            if (odbconn.State == ConnectionState.Closed){

                odbconn.Open();

            }

            else{

                sStr2 = "DBQ=" + Server.MapPath(@"App_Data/#fdaeg35@#gds.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};";

                odbconn.ConnectionString = sStr2;

                if (odbconn.State == ConnectionState.Closed){

                    odbconn.Open();

                }

            }

        }

        catch{

            try{

                //odbconn = new OleDbConnection(ConfigurationManager.ConnectionStrings[str].ConnectionString);

                odbconn.ConnectionString = ConfigurationManager.ConnectionStrings[str].ConnectionString;

                if (odbconn.State == ConnectionState.Closed){

                    odbconn.Open();

                }

            }

            catch{

                string sStr1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=./App_Data/#fdaeg35@#gds.mdb";

                //odbconn = new OleDbConnection(sStr1);

                odbconn.ConnectionString = sStr1;

                if (odbconn.State == ConnectionState.Closed){

                    odbconn.Open();

                }

            }

        }

        return odbconn;

    }

  繼續。。。。