SqlDbx Forum

sqldbxlier

Member

Crash when connection error

There are many places doesn't handle the MySQL connection error properly, the whole GUI is crashed when you trying to connect to a not exist database or something similar.

Sometimes, it doesn't crash but the error box display nothing except an error icon.

sqldbxhelp

Administrator

Re: Crash when connection error

Can you provide more details.
MySQL version an ODBC driver version.
Way to reproduce the issue.

sqldbxlier

Member

Re: Crash when connection error

Connect to a MySQL Server by specify a non-existing DB, then sqldbx crash.
myodbc5.dll

sqldbxlier

Member

Re: Crash when connection error

One more comment, when we are trying to load the schema meta data can we use a lower isolation level? The reason why i ask is sometimes I even can not open the sqldbx when the schema is changing or some other queries lock it. It makes me impossible to kill it or show the process.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM TABLE_NAME ;
COMMIT ;

sqldbxhelp

Administrator

Re: Crash when connection error

This is MySQL ODBC driver issue.
If you download latest drivers then you should be fine.