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=192.168.0.5;PORT=3306;DATABASE=disc;UID=user;PWD=password
This is returning an error ODBC--Connection to {MySQL ODBC 5.1 Driver}192.168.0.5 failed
Can you please suggest what wrong. as I know the DSN information is correct as it works in a std DSN connection.