Hi, our CIO is having problems getting Toad for DA v2.7 and 3.0 connected to our MySQL 4.1.22 database (however, v2.6 works fine). Every time he tries to connect he receives the following error message.
Statusbar:3/17/2011 1:19:19 PM: MySQL Database Error: Can’t connect to MySQL server on ‘ecwcognos’ (10061): No connection could be made because the target machine actively refused it 192.168.0.48:3306 (Remembered answer: “OK”. Enable)
Our initial thought is that Toad is using the ‘wrong’ port to connect? The error message shows that the connection was refused on port 3306. However, our database, and within TOAD, is set to use port 4928.
Has anyone run into any issues with TOAD using a non-default port?