Customer would like to use the 64-bit version of
MySQL ODBC 3.51 (IIS website of legacy Windows hosting subscription) driver for connection between APS.NET application and MySQL database. The following setting is set for IIS application pool:
Enable 32-Bit Applications = False
Control Panel\All Control Panel Items\Administrative Tools\ODBC Data Sources (64-bit) snap-in crashes on attempt to use the
Test button with customer's DSN details entered.
Windows event viewer error at crash:
Problem signature: Problem Event Name: APPCRASH Application Name: odbcad32.exe Application Version: 6.3.9600.16384 Application Timestamp: 5215f2d8 Fault Module Name: myodbc3.dll Fault Module Version: 22.214.171.124 Fault Module Timestamp: 4925e0c0 Exception Code: c0000005 Exception Offset: 00000000000b6a63 OS Version: 6.3.9600.2.0.0.272.7 Locale ID: 3082 Additional Information 1: ca3c Additional Information 2: ca3c599cec7fb39385d4e6a024733271 Additional Information 3: d59d Additional Information 4: d59dfe93ec262cbf88c656d0721cb972
Faulting application name: odbcad32.exe, version: 6.3.9600.16384, time stamp: 0x5215f2d8 Faulting module name: myodbc3.dll, version: 126.96.36.199, time stamp: 0x4925e0c0 The HTTP Filter DLL C:\Windows\System32\myodbc3.dll failed to load. The data is the error. Could not load all ISAPI filters for site 'WEBSPACE_00... - DOMAIN (...)'.
Test button operation, performed in the 32-Bit snap-in (
ODBC Data Sources (64-bit)) does not crash the application and works correctly.
The failure is not related to Windows Shared Hosting module directly, pure OS issue.
Contact Microsoft support.
Note: Avoid installing other
MySQL ODBC driver versions (5.1.x and later) - it is not officially supported - refer to Supported ODBC-MySQL Driver for Windows Versions.