search

aws / aws-mysql-odbc

The Amazon Web Services (AWS) ODBC Driver for MySQL allows an application to take advantage of the features of clustered MySQL databases. It is based on and can be used as a drop-in compatible for the MySQL Connector/ODBC driver, and is compatible with all MySQL deployments.
Other
41 stars 4 forks source link

Application Error on Windows Server 2016 EC2 #206

Open AleksandrsRanks opened 3 months ago

AleksandrsRanks commented 3 months ago

Describe the bug

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

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

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 commented 3 months ago

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

AleksandrsRanks commented 3 months ago

@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 commented 2 months ago

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.