我现在连接字符串是:Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\DbDir; Extended Properties=Paradox 5.x
现在提示出错ERROR [HY000] [Microsoft][ODBC Paradox 驱动程序] 外部表不是预期的格式。求怎么能连数据库 并对数据操作
可以参考这篇文章 http://www.bubuko.com/infodetail-1180790.html
string ConnectionString = @" Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=C:Paradox;Dbq=C:Paradox;CollatingSequence=ASCII;PWD=; " ;
using (System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(ConnectionString))
{
conn.Open();
using (System.Data.Odbc.OdbcCommand command = conn.CreateCommand())
{
command.CommandText = " update test set aa=14 " ;
command.ExecuteNonQuery();
command.CommandText = " select * from test " ;
Console.WriteLine(command.ExecuteScalar());
}
}