今天我用VC 连接MySQL数据库(ODBC),装的驱动是MySQL ODBC 5.1 Driver,
CDatabase db;
BOOL bResult = TRUE;
CString chSql;
CString sDsn;
sDsn="DSN=airmonitordb;Server=192.168.0.120; Driver={MySQL ODBC 5.1 Driver};UID=MM;PWD=ZM";
chSql.Format("insert into airconditionpara(TemperSet,MaxTemper,MinTemper,HumiditySet,MaxHumidity,MinHumidity,RoleNumber) values(%d,%d,%d,%d,%d,%d,%d)",
20,20,20,20,20,20,20);
TRY
{
db.OpenEx(_T( sDsn),CDatabase::noOdbcDialog ) ;
db.ExecuteSQL(chSql);
}
CATCH(CDBException, e)
{
bResult = FALSE; //数据库处理异常
return bResult;
}
就是插入不进去,请教高手怎么解决,谢谢
CDatabase db;
BOOL bResult = TRUE;
CString chSql;
CString sDsn;
sDsn="DSN=airmonitordb;Server=192.168.0.120; Driver={MySQL ODBC 5.1 Driver};UID=MM;PWD=ZM";
chSql.Format("insert into airconditionpara(TemperSet,MaxTemper,MinTemper,HumiditySet,MaxHumidity,MinHumidity,RoleNumber) values(%d,%d,%d,%d,%d,%d,%d)",
20,20,20,20,20,20,20);
TRY
{
db.OpenEx(_T( sDsn),CDatabase::noOdbcDialog ) ;
db.ExecuteSQL(chSql);
}
CATCH(CDBException, e)
{
bResult = FALSE; //数据库处理异常
return bResult;
}
就是插入不进去,请教高手怎么解决,谢谢
rs.Open(CRecordset::forwardOnly, chSql);看看这个行不行