ODBC connexion to MySQL from Excel/VBA won't work any more on Windows 8.1

Some days ago, I finally succeeded in establishing a dialog between my Excel 2007 sheet on a Windows 8.1 computer and a MySQL database on the Windows 2008 server of the active directory domain using ADO/ODBC in VBA.

Then I accepted the Microsoft suggestion of 3 imprtant updates on W8.

And today, the dialog fails on the connection string :
"DRIVER={MySQL ODBC 5.3 Unicode Driver};" & _
" SERVER=xxxxx;" & _
" DATABASE=xxxxxxx;" & _
" UID=xxxxxxx;PWD=xxxxxxx; OPTION=3;"

I precize that phpmyadmin works perfectly on W8, same as ODBC driver : "Test" succeeds witout hesitation.

Is ther a known issue with recent Windows 8 updates, or something else ?

Excuse my limited english and thanks a lot.

1 answer

I post the answer I found, in the case somebody where interested...

I defined a DSN as "System data source" in the ODBC Administration tool, say "MySystemDSN", and my connexion string is simply "DSN=MySystemDSN"

Information found thanks to Google who routed me on an MSDN page. I did not tried if it worked with "User data source"

AMIcaly.