Professional Web Applications Themes

ODBC Manager hangs while creating a DSN for MyODBC driver - MySQL

Hi, I am trying to use mysql-connector-odbc-3.51.12-win32.msi with a MySql 4.1.9-nt server instance running on Windows Server 2003 SP1. After installing the driver, I tried to create a DSN using the ODBC Manager in Windows. I get as far as the MyODBC dialog. After entering the connection details, I press "Test" to test the connection. At this point the process simply freezes - with little CPU activity - and has to be forcibly terminated. The same thing happen if I enter no connection details at all and just press the Test button. Has anyone else experienced this issue (and hopefully ...

  1. #1

    Default ODBC Manager hangs while creating a DSN for MyODBC driver

    Hi,

    I am trying to use mysql-connector-odbc-3.51.12-win32.msi with a MySql
    4.1.9-nt server instance running on Windows Server 2003 SP1.

    After installing the driver, I tried to create a DSN using the ODBC Manager
    in Windows. I get as far as the MyODBC dialog. After entering the connection
    details, I press "Test" to test the connection. At this point the process
    simply freezes - with little CPU activity - and has to be forcibly
    terminated. The same thing happen if I enter no connection details at all
    and just press the Test button.

    Has anyone else experienced this issue (and hopefully has a
    solution/workaround)?.

    Thanks

    Kunle Guest

  2. #2

    Default Re: ODBC Manager hangs while creating a DSN for MyODBC driver

    I've just had the same result with mysql-connector-odbc-3.51.14-win32.msi
    trying to connect to a MySql 4.1.21-community-nt server instance running on
    Windows Server 2003 SP1.

    The ODBC Manager process freezes (couldn't kill it via task manager - it
    froze task manager too). Everything else seems to continue working fine
    (there is minimal-low cpu usage). Really strange.

    Kunle Guest

  3. #3

    Default Re: SOLUTION - ODBC Manager hangs while creating a DSN for MyODBC driver

    This issue seems to be triggered by the presence of the ZoneAlarm firewall
    product (perhaps other firewalls too?). Not sure why MySql/MyODBC objects
    particularly since other Client/Server RDBMS systems work fine with
    ZoneAlarm and other firewalls. In any case, **uninstalling** ZoneAlarm
    solves this issue here.

    It isn't a satisfactory solution by any means and effectively rules out
    MySql/MyODBC in the long run.

    Kunle Guest

Similar Threads

  1. Replies: 1
    Last Post: October 21st, 06:44 PM
  2. Replies: 4
    Last Post: July 2nd, 01:11 PM
  3. Replies: 1
    Last Post: December 13th, 02:59 AM
  4. #26049 [Opn->Bgs]: Cannot connect to ODBC source (MyODBC)
    By kalowsky@php.net in forum PHP Development
    Replies: 0
    Last Post: October 31st, 02:23 PM
  5. #26049 [NEW]: Cannot connect to ODBC source (MyODBC)
    By miroslav dot sulc at startnet dot cz in forum PHP Development
    Replies: 0
    Last Post: October 31st, 10:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139