[FIXED] How do I suppress the ODBC dialog box on a DSN-Less connection?

Issue

I am trying to access a MySQL table via a DSNless ODBC connection from Microsoft Access. I ave no problem actually connecting is a valid user name and password is provided. However in either of these are not valid, the ODBC dialog screen appears asking for connection details. Is there any way of stopping the ODBC dialog screen from appearing and just letting the connection error?

My ODBC connection string is

"ODBC;Driver=MySQL ODBC 3.51 Driver;SERVER=XXXX;DATABASE=XXXX;UID=XXXX;PWD=XXXX;Option=3"

Solution

Take a look at - 19.1.4.2. Connector/ODBC Connection Parameters

Specifically, the "options" parameter and its flag "FLAG_NO_PROMPT"...

Answered By - Garry M. Biggs

Answer Checked By - Pedro (PHPFixing Volunteer)