Bug #104032 asp clasic, error C0000005 when using addnew on text fld
Submitted: 16 Jun 2021 7:35 Modified: 27 Jan 2022 13:52
Reporter: Elad Yankovich Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:8.0.25 OS:Windows (iis 7)
Assigned to: CPU Architecture:x86 (x64)
Tags: c0000005, classic asp, odbc connector 8

[16 Jun 2021 7:35] Elad Yankovich 
Description:
we have upgraded the ODBC connector from 5 to 8.0.25 (along with MySQL upgrades)
in classic asp and MySQL 8.0.25 (same as ODBC connector's version)
when we use "addnew" (for adding new record) functionality of classic asp
inserting into a text field on my SQL, the IIS application pool crashes
and a constant error appears: A trappable error (C0000005) occurred in an external object. The script cannot continue running. 
if changing field to varchar(255) no errors occur.

How to repeat:
mysql:

CREATE TABLE `test` (
  `recid` int NOT NULL,
  `myname` varchar(220) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `myid` int NOT NULL,
  `myboolean` tinyint(1) NOT NULL,
  `mytext` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `test` ADD PRIMARY KEY (`recid`);
ALTER TABLE `test`MODIFY `recid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

asp classic:

rs.open "select * from test;",conn,1,3
rs.AddNew
rs("myname")="test varchar"
rs("myid")=123456
rs("myboolean")=1
rs("mytext")="a"
rs.Update
rs.close
[22 Jun 2021 12:20] MySQL Verification Team 
Hello Elad Yankovich,

Thank you for the bug report.
Could you please provide a complete test case and code file which hit the issue reported? Thanks.

Regards,
Ashwini Patil
[27 Jan 2022 13:52] MySQL Verification Team 
Hello Elad Yankovich,

Thank you for the details.
I tried to reproduce your issue on windows 10 with Connector/ODBC 8.0.28 using the test file provided but I am not seeing any issues at my end. 

Regards,
Ashwini Patil