MyODBC DSN Configuration Dialog Hidden
Hi, I have a vb application which connects to mysql via ado/myodbc 3.51.03. In it, users can choose to connect to databases on different machines. I construct a connection string from the hostname, database etc. So far so good. The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver (or at least I assume its the driver), pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). I can't find any difference between the two machines except that the 2000 machine also has myodbc 2.5 installed, but not used. ANY help appreciated! ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC DSN Configuration Dialog Hidden
Hi , -Original Message- From: mySQL list [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 2:35 AM To: [EMAIL PROTECTED] Subject: MyODBC DSN Configuration Dialog Hidden Hi, I have a vb application which connects to mysql via ado/myodbc 3.51.03. In it, users can choose to connect to databases on different machines. I construct a connection string from the hostname, database etc. So far so good. The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). You can disable the re-connect prompt in ado by using DriverNoPrompt option from your conn.open method. You can also disable the prompt during the failed connection from the DSN using the option 'Don't prompt on connect'. And as far as hidden dialog, am not sure how does that come in to picture as we use XP and 2000 for all internal testing. Can you cross check whether the dialog is really active by using 'alt-tab' ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC DSN Configuration Dialog Hidden
Hi Venu, The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). You can disable the re-connect prompt in ado by using DriverNoPrompt option from your conn.open method. I can't find any option to use DriverNoPrompt in ADO, only DAO, unless you mean in the OPTION= part of the connection string. Originally I had OPTION=35, I've tried OPTION=51 (adding 16 which should disable any prompts), but its just the same. You can also disable the prompt during the failed connection from the DSN using the option 'Don't prompt on connect'. And as far as hidden dialog, am not sure how does that come in to picture as we use XP and 2000 for all internal testing. Can you cross check whether the dialog is really active by using 'alt-tab' ? Yes it is there - alt-tab brings it to the front (and the Don't prompt on connect checkbox is set when I use OPTION=51). Regards, Ian Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php