Application Error on Windows Server 2016 EC2

[AleksandrsRanks]

Describe the bug

I installed aws-mysql-odbc-1.0.0-winx64a.msi on EC2 with following configuration:

• Windows Server 2016 Datacenter
• Microsoft Visual C++ 2015-2022 Redistributable (x64) - 14.40.33810
• Microsoft Visual C++ 2015-2022 Redistributable (x86) - 14.40.33810

In 'ODBC Data Source Administrator (64-bit)' (odbcad32.exe) While adding new datasource, after I select datasource driver 'AWS ODBC Unicode Driver for MySQL' , and click finish it crashes with following application error:

Faulting application name: odbcad32.exe, version: 10.0.14393.0, time stamp: 0x57899b93
Faulting module name: VCRUNTIME140.dll, version: 14.40.33810.0, time stamp: 0x119a1ae6
Exception code: 0xc0000005
Fault offset: 0x000000000001153e
Faulting process id: 0x2014
Faulting application start time: 0x01dafa07fad87556
Faulting application path: C:\Windows\system32\odbcad32.exe
Faulting module path: C:\Windows\SYSTEM32\VCRUNTIME140.dll
Report Id: 88cc7c9a-32f4-4928-9489-409a57f7e29b
Faulting package full name:
Faulting package-relative application ID:

Expected Behavior

New connection for AWS ODBC Unicode Driver for MySQL dialog box is supposed to show up.

Were cluster failover and/or enhanced failure detection enabled? Were any AWS authentication methods used? What other connection properties were set?

N/A

Current Behavior

• System

  • Provider

  [ Name] Application Error

  • EventID 1000

  [ Qualifiers] 0

  Level 2

  Task 100

  Keywords 0x80000000000000

  • TimeCreated

  [ SystemTime] 2024-08-29T11:38:39.752867100Z

  EventRecordID 4519864

  Channel Application

  Computer EC2AMAZ-E6IHOC9

  Security

• EventData

  odbcad32.exe
  10.0.14393.0
  57899b93
  VCRUNTIME140.dll
  14.40.33810.0
  119a1ae6
  c0000005
  000000000001153e
  2014
  01dafa07fad87556
  C:\Windows\system32\odbcad32.exe
  C:\Windows\SYSTEM32\VCRUNTIME140.dll
  88cc7c9a-32f4-4928-9489-409a57f7e29b

Reproduction Steps

Go to: Control Panel/Administrative Tools/ODBC Data Sources (64-bit)
Click: Add...,
Select: AWS ODBC Unicode Driver for MySQL Version 1.00.00.00
Click: Finish

Possible Solution

No response

Additional Information/Context

No response

The AWS ODBC Driver for MySQL version used

aws-mysql-odbc-1.0.0-winx64a.msi

Operating System and version

Windows Server 2016 Datacenter

[karenc-bq]

Hi @AleksandrsRanks, could you please try the suggestions in #197 and let us know if that resolve your issue?

[AleksandrsRanks]

@karenc-bq, https://github.com/aws/aws-mysql-odbc/issues/197#issuecomment-2258789659 suggests to update VC++ to the latest 14.40.33810.0. That was the first thing I did before registering this issue. Also uninstalled all prior versions of VC++ redistributables and reinstalled the driver, still got the error and then registered this issue.

Would you suggest building own aws-mysql-odbc-1.0.0 from Visual Studio?

[karenc-bq]

Hi @AleksandrsRanks, we are unable to reproduce the crash you are seeing.

We used a new Windows Server 2016, installed the version 1.0.0 driver from https://github.com/aws/aws-mysql-odbc/releases/download/1.0.0/aws-mysql-odbc-1.0.0-winx64a.msi, and installed the latest redistributable from https://aka.ms/vs/17/release/vc_redist.x64.exe. We were able to use the driver in the ODBC Data Source Administrator to establish a connection.

Could you please let us know if we are missing any environment set up? Thank you.