Help with ADOCommand->Execute with Parameters
COM
1
Posts
1
Posters
0
Views
1
Watching
-
Using Access 2000 and ADO VC++6.0 I am executing the following statement.. VARIANT Params[2]; Params[0].vt = VT_I2; Params[0].iVal = 1; Params[1].vt = VT_R4; Params[1].fltVal = 8.99; m_pCommand->adCmdText = "Query4"; m_pCommand->ActiveConnection = m_pConnection; m_pCommand->Execute(0, Params, adCmdStoredProc); Generates an exception {DB_E_PARAMNOTOPTIONAL} Query4 in Access is as follows: PARAMETERS vID Short, Rad IEEESingle; INSERT INTO TABLE1 ( ODID, MeasRadius ) VALUES (vID, Rad); Thanks for your help in advance.