Re: MySQL ODBC connector forgets password and server name

[Bogdan Degtyariov]

Hi Horst,

What is the exact version of Connector/ODBC 8 you are using?
Is it 32-bit or 64-bit?

Currently with 8.0.X version line we support only 32-bit driver as a legacy product because many Windows applications are still 32-bit. The last 64-bit version of Connector/ODBC was 8.0.33, which released in March 2023.

Regarding the values in the registry:

the registry key for storing 32-bit DSN would be: HKLM\SOFTWARE\WOW6432Node\ODBC

and for 64-bit DSN it is:
HKLM\SOFTWARE\ODBC

The situation could be as follows:

- 64-bit ODBC Driver 8.0.33 created a 64-bit DSN

- a newer version of ODBC Driver 8.0 was installed (such as 8.0.43),
which is 32-bit only. A 32-bit DSN with the same name was created.

- 32-bit version of 8.0.43 does not read 64-bit DSN, which looks as if
the driver forgot password and server name.

Please let me know if this explains what is happening in your environment.