Forums » General Discussion

Thread: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List Point your RSS reader here for a feed of the latest messages in all forums

Permlink Replies: 7 - Pages: 1 - Last Post: Aug 19, 2011 5:01 AM by: skotwani_500 Threads: [ Previous | Next ]
skotwani_500

Posts: 5
Registered: 8/17/11
Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 17, 2011 7:20 AM 		 
  Click to reply to this thread Reply

I can connect to my db instance from the same Win7 machine using ODBC driver and HeidiSQL, but Toad (which I love!) gives me this error. I increased the timeout time to 30 sec, but the error seems to arrive before that time elapses.



**********************************************************************
Exception Information
**********************************************************************
Exception: System.TimeoutException
Message : A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Stack Trace:
at MyNetworkStream.HandleOrRethrowException(Exception e)
at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
Inner Exception: System.IO.IOException
Message : Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Stack Trace:
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
Inner Exception: System.Net.Sockets.SocketException
Message : A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Stack Trace:
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

**********************************************************************
Support Bundle for Toad for MySQL Freeware 5.0 Freeware
8/17/2011 8:16:27 AM
**********************************************************************

**********************************************************************
System Information
**********************************************************************
Operating System
Microsoft Windows 7 Ultimate 6.1.7601 AMD64
Manufacturer: Microsoft Corporation
Computer Name: MACPRO
Windows Directory: C:\Windows

Computer System
Computer Manufacturer Name: VMware, Inc.
Computer Model: VMware Virtual Platform
System Type: x64-based PC
Total Physical Memory: 4,193,848 KB
Domain: WORKGROUP
User Name:

System Processor
Manufacturer: GenuineIntel
Computer Processor: Intel64 Family 6 Model 42 Stepping 7
CPU Speed: 1.995 GHz
L2 Cache Size: Unknown

System Bios
BIOS: PhoenixBIOS 4.0 Release 6.0
BIOS Version: INTEL - 6040000

System Time Zone
Time Zone: (UTC-05:00) Eastern Time (US & Canada)

Logical Memory Configuration
**********************************************************************
Connection Information
**********************************************************************
No open connections.

**********************************************************************
Loaded Assemblies
**********************************************************************
Accessibility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\Accessibility\2.0.0.0__b03f5f7f11d50a3a\Accessibility.dll
ActiproSoftware.Shared.Net20, Version=1.0.103.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.Shared.Net20\1.0.103.0__36ff2196ab5654b9\ActiproSoftware.Shared.Net20.dll
ActiproSoftware.SyntaxEditor.Net20, Version=4.0.284.0, Culture=neutral, PublicKeyToken=21a821480e210563 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.Net20\4.0.284.0__21a821480e210563\ActiproSoftware.SyntaxEditor.Net20.dll
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.109.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.UIStudio.Dock.Net20\2.0.109.0__be939c973e8cb8a6\ActiproSoftware.UIStudio.Dock.Net20.dll
ActiproSoftware.WinUICore.Net20, Version=1.0.103.0, Culture=neutral, PublicKeyToken=1eba893a2bc55de5 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.WinUICore.Net20\1.0.103.0__1eba893a2bc55de5\ActiproSoftware.WinUICore.Net20.dll
Devart.Data.MySql, Version=5.50.79.0, Culture=neutral, PublicKeyToken=09af7300eec23701 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Plugins\MySQL\Devart.Data.MySql.dll
DevExpress.BonusSkins.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Windows\assembly\GAC_MSIL\DevExpress.BonusSkins.v9.3\9.3.3.0__95fc6c5621878f0a\DevExpress.BonusSkins.v9.3.dll
DevExpress.Data.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.Data.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.Data.v9.3.dll
DevExpress.OfficeSkins.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Windows\assembly\GAC_MSIL\DevExpress.OfficeSkins.v9.3\9.3.3.0__95fc6c5621878f0a\DevExpress.OfficeSkins.v9.3.dll
DevExpress.Utils.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.Utils.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.Utils.v9.3.dll
DevExpress.XtraBars.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraBars.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraBars.v9.3.dll
DevExpress.XtraEditors.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraEditors.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraEditors.v9.3.dll
DevExpress.XtraGrid.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraGrid.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraGrid.v9.3.dll
DevExpress.XtraTreeList.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraTreeList.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraTreeList.v9.3.dll
FastData, Version=3.0.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\FastData.dll
ManagedQP5, Version=5.2.5.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\managedqp5.dll
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll
msvcm90, Version=9.0.30729.6161, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\msvcm90.dll
MySql.Data, Version=6.3.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Plugins\MySQL\MySql.Data.dll
Quest.PersistentCache, Version=3.0.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Quest.PersistentCache.dll
Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Quest.Toad.Interop.AxSHDocVw.dll
Quest.VersionControl, Version=1.1.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Quest.VersionControl.dll
QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\QuestElevation.exe
SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\SHDocVw.dll
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll
System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll
System.Management, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Management\2.0.0.0__b03f5f7f11d50a3a\System.Management.dll
System.Runtime.Serialization.Formatters.Soap, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll
System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll
System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_MSIL\System.Xml.Linq\3.5.0.0__b77a5c561934e089\System.Xml.Linq.dll
Toad, Version=5.0.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Toad.exe
ToadCore, Version=5.1.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\ToadCore.dll
ToadMySQL, Version=5.0.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Plugins\MySQL\ToadMySQL.dll
ToadMySQLProvider, Version=5.0.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\Plugins\MySQL\ToadMySQLProvider.dll
ToadPlugin, Version=5.0.0.345, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\ToadPlugin.dll
QP5, Version=5.165.1008.25014, C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 5.0\qp5.dll
**********************************************************************
Licensing
**********************************************************************
DBA, Debugger


Mauritz

Posts: 313
Registered: 8/23/07
Re: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 17, 2011 10:27 AM   in response to: skotwani_500 		 
  Click to reply to this thread Reply

My first suggestion would be to try the 6.0 beta (We are really close to release so it is very stable at this point).

skotwani_500

Posts: 5
Registered: 8/17/11
Re: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 17, 2011 5:49 PM   in response to: Mauritz 		 
  Click to reply to this thread Reply

Thanks for the quick response. I'm now running the beta 6.0 version and still get a similar error (even after increasing timeout to 60 sec -- the error kicks off much before I get to even 30 sec though)


System.TimeoutException
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Stack Trace:
at MyNetworkStream.HandleOrRethrowException(Exception e)
at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

System.IO.IOException
Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Stack Trace:
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)

System.Net.Sockets.SocketException
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Stack Trace:
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)


skotwani_500

Posts: 5
Registered: 8/17/11
Re: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 17, 2011 5:57 PM   in response to: Mauritz 		 
  Click to reply to this thread Reply

Also, I did a packet sniff, and the last packet that the MySQL server sent was a "Server Greeting proto=10 Version=4.1.22". After that the client should send a login request, but I never saw that packet.

Just to confirm, is that version of MySQL supported? It's running off of a Linux NSLU2 Linksys device, so it may not be your "typical" install. Again, I was able to connect to it with other tools though.

Thanks so much!


Mauritz

Posts: 313
Registered: 8/23/07
Re: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 18, 2011 11:32 AM   in response to: skotwani_500 		 
  Click to reply to this thread Reply

What version of MySQL are you trying to connect to?

skotwani_500

Posts: 5
Registered: 8/17/11
Re: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 18, 2011 7:15 PM   in response to: Mauritz 		 
  Click to reply to this thread Reply

Judging from the response packet captured, 4.1.22


Mauritz

Posts: 313
Registered: 8/23/07
Re: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 18, 2011 7:31 PM   in response to: skotwani_500 		 
  Click to reply to this thread Reply

I've made a slight tweak that I think should fix your issue. It will be in the next beta drop.

skotwani_500

Posts: 5
Registered: 8/17/11
Re: Toad for MySQL (Win 7) - Trouble connecting (when other tools connect fine)
Posted: Aug 19, 2011 5:01 AM   in response to: Mauritz 		 
  Click to reply to this thread Reply

Thank you!


Pages: 1
Back to Thread List Back to Thread List
Threads: [ Previous | Next ]
Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums