new ODBC driver error
Posted by:
John Brown
Date: December 11, 2013 04:16PM
If I install this driver "mysql-connector-odbc-3.51.30-win32.msi"
and use this connection string "DRIVER={MySQL ODBC 3.51 Driver};SERVER=235.132.123.123;DATABASE=GoodData;UID=tomjones;PWD=metom;OPTION=4"
The connection works and I get my data.
If I install this driver "mysql-connector-odbc-5.2.6-win32.msi"
and use this connection string "DRIVER={MySQL ODBC 5.2 ANSI Driver};SERVER=235.132.123.123;DATABASE=GoodData;UID=tomjones;PWD=metom;OPTION=3"
The connection does NOT work and I DO NOT get my data and I get the following error:
"Exception encountered, Exception.Message = [MySQL][ODBC 5.2(a) Driver]Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)"
What do I need to do to use "DRIVER={MySQL ODBC 5.2 ANSI Driver}" successfully?
Subject
Written By
Posted
new ODBC driver error
December 11, 2013 04:16PM
December 12, 2013 04:21AM
December 12, 2013 08:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.