MySQL ODBC 3.51 Driver

[jbeetz1]

I have an application developed in Powerbuilder that makes a connect to a MySQL DB. If the connect fails the user is prompted with the MySQL ODBC Driver Configuration which has information (Database Name/User/Password etc)I rather not share with the user. Is there an option to supress this from happening.

I am using version 3.51 ODBC Driver.

 

[ingresman]

Have you tried the don't prompt on connect check box in the odbc administrator ? (presume your are on windows)

 

[jbeetz1]

I tried that and it does nothing.

 

[ingresman]

What kind of fail throws up the message,. I'm wondering if the syntax to do a DSN less connection has anything on it.
The documentation is at

http://www.mysql.com/products/myodbc/manual.html#Connection_parameters

And it looks like you need to set bit 16 on SQLDriverConnect.
I'm interested in how you get on and I might have a play asd well.
I'm presuming that poerbuilder offers you the ODBC interface ?
regards

 

[ingresman]

Another thought. Have you tried using SQLConnect, the documentation says the SQLDriverConnect will prmpt, which may be hard to turn off.

 

[jbeetz1]

If I disconnect my PC from my cable modem I will get it. Since this application will be distrubited to various customers they may be on a dial-up connection and therefore not on-line at the time they run the application. I do have a work around that I have used previously using (ftp). I just was trying to make my life easier. I appreciate your help.