November 26th, 2012, 12:40 PM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 1
Time spent in forums: 24 m 8 sec
Reputation Power: 0
|
|
|
DSN Less Passthrough Query
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.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
