ERROR [HY000] [Microsoft][ODBC Paradox Driver] 外部数据库驱动程序 (8961) 中的意外异常
ERROR [HY000] [Microsoft][ODBC Paradox Driver] 外部数据库驱动程序 (8961) 中的意外错误
我这里有个easyaccess5.db数据文件,我用ODBC打开报错。错误如题,相关代码如下:
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "*.db|*.db";
if (ofd.ShowDialog() == DialogResult.OK)
{
string DBData = ofd.FileName.Substring(0, ofd.FileName.LastIndexOf("."));
string dbpath = ofd.FileName.Substring(0,ofd.FileName.LastIndexOf("\\"));
string DBConn = @"Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;
DefaultDir=" + dbpath + "\\;Dbq=" + dbpath + "\\;CollatingSequence=ASCII";
Helper helper = new Helper();
string cmd = @"select * from "+DBData;
dgv_display.DataSource = helper.GetDBTable(cmd);
}
public DataTable GetDBTable(string cmd)
{
using (OdbcConnection conn = new OdbcConnection(DBConn))
{
conn.Open();
using (DataTable dt = new DataTable())
{
using (OdbcDataAdapter da = new OdbcDataAdapter())
{
da.SelectCommand = new OdbcCommand(cmd, conn);
da.Fill(dt);
return dt;
}
}
}
}
求大神帮助解决!
------解决方案--------------------
恭喜,接分.
我这里有个easyaccess5.db数据文件,我用ODBC打开报错。错误如题,相关代码如下:
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "*.db|*.db";
if (ofd.ShowDialog() == DialogResult.OK)
{
string DBData = ofd.FileName.Substring(0, ofd.FileName.LastIndexOf("."));
string dbpath = ofd.FileName.Substring(0,ofd.FileName.LastIndexOf("\\"));
string DBConn = @"Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;
DefaultDir=" + dbpath + "\\;Dbq=" + dbpath + "\\;CollatingSequence=ASCII";
Helper helper = new Helper();
string cmd = @"select * from "+DBData;
dgv_display.DataSource = helper.GetDBTable(cmd);
}
public DataTable GetDBTable(string cmd)
{
using (OdbcConnection conn = new OdbcConnection(DBConn))
{
conn.Open();
using (DataTable dt = new DataTable())
{
using (OdbcDataAdapter da = new OdbcDataAdapter())
{
da.SelectCommand = new OdbcCommand(cmd, conn);
da.Fill(dt);
return dt;
}
}
}
}
求大神帮助解决!
------解决方案--------------------
恭喜,接分.