Bug #92961 ado 3092 only first time.
Submitted: 26 Oct 2018 11:13 Modified: 28 Oct 2018 8:38
Reporter: tj chang Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0 OS:Microsoft Windows (win10)
Assigned to: CPU Architecture:Any

[26 Oct 2018 11:13] tj chang
Description:
ADODB.Command.
ADODB.Connection
i create one procedure.

CString sql;
sql = "use myDbTest";
command->execute(sql );
sql =
"CREATE PROCEDURE  cmd_event_insert_procedure( "
		"in id bigint(8), "
		"in stationNo int, "
		"in nDeviceIP int, "
		"in deviceIP varchar(128), "
		"in nISCSIP int, "
		"in iscsIP varchar(128), "
		"in cmd varchar(256), "
		"in time bigint(8), "
		"in logDate varchar(64) ) "
		"begin "
		"insert into cmd_event( id,stationNo, nDeviceIP, deviceIP, nISCSIP, iscsIP, cmd, time, logDate) values( id, stationNo, nDeviceIP, deviceIP, nISCSIP, iscsIP, cmd, time, logDate); "
		"end";

command->ActiveConnection = ds.GetConnection();
command->CommandText = _bstr_t( "cmd_event_insert_procedure" );
command->CommandType = adCmdStoredProc;

add_command_param();

for( int i = 0; i < 1000; i ++)
{
 update_command_para();

 command.execute();
}

How to repeat:
close myaqpp

redo up
[26 Oct 2018 12:32] tj chang
sorry , it is my wrong.
[28 Oct 2018 8:38] Umesh Shastry
Thank you for confirming, closing as per last comment.