How to insert new row into sql server table with odbc?

[quesxion]

callout_db.Open(_T("CALLOUT"), FALSE, FALSE, _T("ODBC;"));

after open database, then

callout_db.ExecuteSQL("INSERT INTO Callout_Control (control_id, control_desc, control_date) VALUES ('CO0000003', 'asdfsdf!', 'abcd')");

callout_db.Close();

i check that this sql statement in sql server are valid. With "Use Callout"

Are my executesql function invalid used? or my sql statement are incorrect?
Or require another function?

[Ejaz]

[ Redirected Thread ]