I am trying to make a DSN-less passthrough query from Access 2007 to MySql 5.
I am entering an ODBC Connect Str in the Access query property sheet as shown
ODBC;DRIVER={MySQL ODBC 5.1 Driver};SERVER=;PORT=3306;DATABASE=disc;UID=user;PWD=password
This is returning an error ODBC--Connection to {MySQL ODBC 5.1 Driver} failed
Can you please suggest what wrong. as I know the DSN information is correct as it works in a std DSN connection.