MySQL connect displays ODBC configuration dialog...

[humour]

Everytime I connect using Powerbuilder to MySQL I get the MySQL odbc configuration dialog.... WHY?? How can I avoid it... I am using the code below. It connects fine but I need to dismiss the ODBC config dialog... (obviously I dont want it showing up)...

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=mysql1'"

Connect using SQLCA ;

 

[humour]

Darn After 1.5 hours of looking I found the answer on a Google Groups.... (buried deep)..."no prompt connect option is required" !!!!



SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=mysql1',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT"