Paradox 创建表后在BDE中设置表的密码后,用程序对表操作就出错,我想问在程序访问的时候怎么把Paradox密码设置进去,可以访问操作表.
string stcc = @"Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=f:\pathToDb\;Dbq=f:\pathToDb\;CollatingSequence=ASCII";
strsql = @"Insert into test( LAST_NAME ,FIRST_NAME ,SALARY,DEPT_NO)VALUES (";
strsql = strsql + "\"sxm\"";
strsql = strsql + "," + "\"tom\"" + "," + "3.22,"+"\"12:11:11,2007-06-01\""+")";
odbc.OdbcCommand.CommandText = strsql;
odbc.OdbcCommand.CommandType = CommandType.Text;
iResult = odbc.OdbcCommand.ExecuteNonQuery();
出错提示:ERROR [07002] [Microsoft][ODBC Paradox Driver] 参数不足,期待是 3
但是这条语句直接在DESKTOP DATABASE 的BDE中可以正确执行,我想是我程序里没有加入访问该表的密码引起的,我不知道密码在访问数据表的时候怎么设置?