C#打开MDB数据问题求救

zhengjialon 2013-07-13 04:54:33

这个《库存_be.mdb》数据库是有其它N个客户端链接的，但是我用C#再链的时候就出错，用其它客户端ADO方式链接没问题，
Error: Microsoft Jet 数据库引擎打不开文件'\\server\databasen$\库存_be.mdb'。它已经被别的用户以独占方式打开，或没有查看数据的权限。

...全文

218 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

zhengjialon 2013-07-18

打赏
举报

用服务的形式打开链接一直提示错误，改成非服务的形式一点没问题

HooverHuang 2013-07-16

打赏
举报


 string  MyConnctionString="";
 OleDbConnection  MyConnection = new OleDbConnection(MyConnctionString);
 public DataTable ExecReader_Sql(string strCmdText)
        {
            OleDbCommand oleDbCommand = new OleDbCommand();
            oleDbCommand.CommandTimeout = 7200;
            OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter();
            DataTable dtRet = null;
            try
            {
                oleDbCommand.Connection = MyConnection;
                oleDbCommand.CommandText = strCmdText;
                oleDbDataAdapter.SelectCommand = oleDbCommand;
                if (MyConnection.State == ConnectionState.Closed)
                {
                    MyConnection.Open();
                }
                dtRet = new DataTable();
                oleDbDataAdapter.Fill(dtRet);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                oleDbDataAdapter.Dispose();
                oleDbCommand.Dispose();
            }
            return dtRet;
        }

连接字符串格式化函数
        #region  Oledb数据库连接字符串格式化
        /// <summary>
        /// Oledb数据库连接字符串格式化
        /// </summary>
        /// <param name="connectionString">Oledb数据库完整路径</param>
        /// <returns>Oledb数据库连接字符串</returns>
        public static string OledbConnStringFormat(string strOledbName)
        {
            string strOledbDir = System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName) + @"\";
            return String.Format("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = {0};", strOledbDir+strOledbName);
        }
        #endregion

zhengjialon 2013-07-16

打赏
举报

还有人帮忙吗？

zhengjialon 2013-07-15

打赏
举报

我的C#打开方式为： //创建数据库连接 OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server\databasen$\库存_be.mdb"); aConnection.Open(); myDataSet = new DataSet(); OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from 进出成衣单据 where 单据类型='JR' AND FXTEXP=FALSE ORDER BY 日期,单据编号", aConnection);