Toad for MySQL - General

Community Discussion

cherwin
Follow / 17 Aug 2015 at 11:05pm / Toad for MySQL
Latest post by on 25 Aug 2015 at 3:33am

Automation - Using variables in comparison activity under MySQL

Expand content
Hi guys, I was wondering how to use variables previously defined in my automation script for comparison purposes between two MySQL databases. I have an script that first defines a variable and the...

Hi guys, 

I was wondering how to use variables previously defined in my automation script for comparison purposes between two  MySQL databases.

I have an script that first defines a variable and the next activity is the Comparison between two local databases. The problem is that the syntax inside the 'Source Where clause' filter doesn't seems to be working. I've tried using the variable with
@my_variable and with '#my_variable#' and it doesn't work. Please, could you give me some help with this? Thanks!

Unanswered 307 1 / Create an account to join the discussion.
mashley806
Follow / 24 Aug 2015 at 8:46pm / Toad for MySQL

Alter table with unsigned integer

Expand content
When altering a table with an unsigned integer the unsigned column is false by default even though the column is unsigned. Toad for MySQL version 7.3.1.3290

When altering a table with an unsigned integer the unsigned column is false by default even though the column is unsigned. Toad for MySQL version 7.3.1.3290

100 0 / Create an account to join the discussion.
CuJo
Follow / 19 Aug 2015 at 3:43pm / Toad for MySQL

Object Explorer Mouse Roll over causes Repetitive Jumping error

Expand content
Hey so I've found a bug where it looks like toad loses connection to your server, it then has a ridiculous problem where whenever you mouse over the object explorer the client then throws out a bug...

Hey so I've found a bug where it looks like toad loses connection to your server, it then has a ridiculous problem where whenever you mouse over the object explorer the client then throws out a bug.

This will happen constantly for about 15 minutes, and then randomly will just stop spitting out the error.
I have found that disconnecting and re-connecting sorts the connection problem and then the issue goes away, until it falls over again.

Here is the Error print out:

#################################################################################

System.InvalidOperationException

Connection must be opened.

Stack Trace:

   at Devart.Common.Utils.CheckConnectionOpen(IDbConnection connection)

   at Devart.Data.MySql.MySqlConnection.Ping()

   at Quest.Toad.MySQL.MySQLConnection.Ping(IDbConnection connection, Object syncObject)

   at Quest.Toad.MySQL.MySQLConnection.EnsureOpenConnection(IDbConnection connection, Boolean transaction)

   at Quest.Toad.Db.Connection.Db(ConnectionType type, Boolean transaction, Boolean doNotEnsureOpenConnection)

   at Quest.Toad.Db.Connection.Db(ConnectionType type)

   at Quest.Toad.Trl.SqlTrl.GetTrlCount()

   at Quest.Toad.DatabaseBrowser.LeftListControl.ReadCount(CountState data, Int32& totalCount, Int32& count)

#################################################################################

And here is the full support ticket:

#################################################################################

mouse over object explorer and this happens


**********************************************************************
Exception Information
**********************************************************************
Exception: System.InvalidOperationException
Message : Connection must be opened.
Stack Trace:
at Devart.Common.Utils.CheckConnectionOpen(IDbConnection connection)
at Devart.Data.MySql.MySqlConnection.Ping()
at Quest.Toad.MySQL.MySQLConnection.Ping(IDbConnection connection, Object syncObject)
at Quest.Toad.MySQL.MySQLConnection.EnsureOpenConnection(IDbConnection connection, Boolean transaction)
at Quest.Toad.Db.Connection.Db(ConnectionType type, Boolean transaction, Boolean doNotEnsureOpenConnection)
at Quest.Toad.Db.Connection.Db(ConnectionType type)
at Quest.Toad.Trl.SqlTrl.GetTrlCount()
at Quest.Toad.DatabaseBrowser.LeftListControl.ReadCount(CountState data, Int32& totalCount, Int32& count)

**********************************************************************
NOTE: We are eliminating automatic support case creation by email. Before sending your Support Bundle, ensure your subject line includes an opened CaseID:### or a Service Request ID:###. Without the CaseID or Service Request ID your Support Bundle request will be declined.

The quickest way to open a new service request is through our online Support Portal support.software.dell.com/Manage-Service-Request.

You can also contact Support for assistance to create a new case, please visit support.software.dell.com/.../contact-technical-support. Post case creation you will continue to have all communication options available including email, phone, or through the Support Portal to manage the lifecycle of your case.


**********************************************************************
Support Bundle: Toad for MySQL 7.5.0.966 Freeware
19/08/2015 15:31:00
**********************************************************************

**********************************************************************
System Information
**********************************************************************
Operating System
Microsoft Windows 7 Professional 6.1.7601 AMD64
Manufacturer: Microsoft Corporation
Computer Name: PN-MI-JCU
Windows Directory: C:\windows

Computer System
Computer Manufacturer Name: Dell Inc.
Computer Model: OptiPlex 7020
System Type: x64-based PC
Total Physical Memory: 8,294,560 KB
Domain: pn.domain
User Name: PN\Jcurtis

System Processor
Manufacturer: GenuineIntel
Computer Processor: Intel64 Family 6 Model 60 Stepping 3
CPU Speed: 3.601 GHz
L2 Cache Size: 1 KB

System Bios
BIOS: BIOS Date: 04/01/15 20:21:57 Ver: A04.00
BIOS Version: DELL - 1072009

System Time Zone
Time Zone: (UTC) Dublin, Edinburgh, Lisbon, London

Video Controller
Name: Intel(R) HD Graphics 4600
Processor: Intel(R) HD Graphics Family
Mode: 1680 x 1050 x 4294967296 colors
Video Ram: 1,048,576 KB
PNP Device ID: PCI\VEN_8086&DEV_0412&SUBSYS_05A51028&REV_06\3&11583659&3&10
Status: OK
Name: ShoreTel Desktop Sharing Accelerator
Processor:
Mode: 1440 x 900 x 4294967296 colors
Video Ram:
PNP Device ID: ROOT\DISPLAY\0000
Status: OK

Environment Variables
Path = C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\ShoreTel\Contact Center\Agent\Bin;C:\Program Files (x86)\Shoreline Communications\ShoreWare Client\;C:\Program Files (x86)\Shoreline Communications\ShoreWare Client\win64;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\
CCBASE_HOME = C:\Program Files (x86)\ShoreTel\Contact Center\Agent\
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
USERDOMAIN = PN
PROCESSOR_ARCHITECTURE = x86
ProgramW6432 = C:\Program Files
PUBLIC = C:\Users\Public
APPDATA = C:\Users\Jcurtis\AppData\Roaming
windir = C:\windows
LOCALAPPDATA = C:\Users\Jcurtis\AppData\Local
CommonProgramW6432 = C:\Program Files\Common Files
windows_tracing_flags = 3
windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
USERDNSDOMAIN = PN.DOMAIN
SESSIONNAME = Console
USERPROFILE = C:\Users\Jcurtis
ProgramFiles = C:\Program Files (x86)
PROCESSOR_LEVEL = 6
FP_NO_HOST_CHECK = NO
HOMEPATH = \Users\Jcurtis
COMPUTERNAME = PN-MI-JCU
PROCESSOR_ARCHITEW6432 = AMD64
USERNAME = Jcurtis
NUMBER_OF_PROCESSORS = 8
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 60 Stepping 3, GenuineIntel
ComSpec = C:\windows\system32\cmd.exe
SystemRoot = C:\windows
DEFLOGDIR = C:\ProgramData\McAfee\DesktopProtection
LOGONSERVER = \\PBS-DC01
TEMP = C:\Users\Jcurtis\AppData\Local\Temp
ProgramFiles(x86) = C:\Program Files (x86)
CommonProgramFiles = C:\Program Files (x86)\Common Files
TMP = C:\Users\Jcurtis\AppData\Local\Temp
PROCESSOR_REVISION = 3c03
CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
ALLUSERSPROFILE = C:\ProgramData
SystemDrive = C:
PSModulePath = C:\windows\system32\WindowsPowerShell\v1.0\Modules\
OS = Windows_NT
VSEDEFLOGDIR = C:\ProgramData\McAfee\DesktopProtection
ProgramData = C:\ProgramData
HOMEDRIVE = C:

**********************************************************************
Connection Information
**********************************************************************
Current Connection:
ReportingTeam@mis.plus.net (DataWarehouse)
MySQL database
Server version 5.5.10
Connected since 19/08/2015 15:25:52
0 of 3 connections in pool active
Database Variables:
**********************************************************************
Loaded Assemblies
**********************************************************************
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\windows\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a\Accessibility.dll
ActiproSoftware.Docking.WinForms, Version=14.1.322.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\windows\assembly\GAC_MSIL\ActiproSoftware.Docking.WinForms\14.1.322.0__c27e062d3c1a4763\ActiproSoftware.Docking.WinForms.dll
ActiproSoftware.Shared.WinForms, Version=14.1.322.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\windows\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\14.1.322.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll
ActiproSoftware.SyntaxEditor.WinForms, Version=14.1.322.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\windows\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\14.1.322.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
BouncyCastle.Crypto, Version=1.7.4114.6375, Culture=neutral, PublicKeyToken=0e99375e54769942 C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\BouncyCastle.Crypto.dll
Dell.FastETL, Version=7.2.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Dell.FastETL.dll
Dell.NamedPipeRPC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Dell.NamedPipeRPC.dll
Dell.SecTech, Version=4.3.0.448, Culture=neutral, PublicKeyToken=99d4728064788932 C:\windows\Microsoft.Net\assembly\GAC_MSIL\Dell.SecTech\v4.0_4.3.0.448__99d4728064788932\Dell.SecTech.dll
Dell.ToadCommunication, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Dell.ToadCommunication.dll
Dell.ToadGeneral, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Dell.ToadGeneral.dll
Devart.Data, Version=5.0.1085.0, Culture=neutral, PublicKeyToken=09af7300eec23701 C:\windows\assembly\GAC_MSIL\Devart.Data\5.0.1085.0__09af7300eec23701\Devart.Data.dll
Devart.Data.MySql, Version=8.3.293.0, Culture=neutral, PublicKeyToken=09af7300eec23701 C:\windows\assembly\GAC_MSIL\Devart.Data.MySql\8.3.293.0__09af7300eec23701\Devart.Data.MySql.dll
DevExpress.BonusSkins.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.BonusSkins.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.BonusSkins.v14.1.dll
DevExpress.Data.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Data.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.Data.v14.1.dll
DevExpress.Utils.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Utils.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.Utils.v14.1.dll
DevExpress.XtraBars.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraBars.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraBars.v14.1.dll
DevExpress.XtraEditors.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraEditors.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraEditors.v14.1.dll
DevExpress.XtraGrid.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraGrid.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraGrid.v14.1.dll
DevExpress.XtraPrinting.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraPrinting.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraPrinting.v14.1.dll
DevExpress.XtraTreeList.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraTreeList.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraTreeList.v14.1.dll
FastData, Version=6.0.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\FastData.dll
Ionic.Zip, Version=1.9.1.5, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Ionic.Zip.dll
ManagedQP5, Version=5.2.5.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\managedqp5.dll
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll
MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Plugins\MySQL\MySql.Data.dll
PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\windows\Microsoft.Net\assembly\GAC_32\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35\PresentationCore.dll
PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.dll
PresentationFramework.Aero, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.Aero\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.Aero.dll
Quest.PersistentCache, Version=3.0.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Quest.PersistentCache.dll
Quest.VersionControl, Version=1.1.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Quest.VersionControl.dll
QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\QuestElevation.exe
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll
System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Data.Linq.dll
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\windows\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll
System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Management.dll
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll
System.Runtime.Serialization.Formatters.Soap, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll
System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\windows\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll
System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll
System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll
Toad, Version=7.5.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\toad.exe
ToadBlue2014, Version=14.1.8.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\ToadBlue2014.dll
ToadCore, Version=7.5.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\ToadCore.dll
ToadMySQL, Version=7.5.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Plugins\MySQL\ToadMySQL.dll
ToadMySQLProvider, Version=7.5.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\Plugins\MySQL\ToadMySQLProvider.dll
ToadPlugin, Version=6.0.0.966, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\ToadPlugin.dll
UIAutomationClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\windows\Microsoft.Net\assembly\GAC_MSIL\UIAutomationClient\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationClient.dll
UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\windows\Microsoft.Net\assembly\GAC_MSIL\UIAutomationTypes\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationTypes.dll
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\windows\Microsoft.Net\assembly\GAC_MSIL\WindowsBase\v4.0_4.0.0.0__31bf3856ad364e35\WindowsBase.dll
WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\windows\Microsoft.Net\assembly\GAC_MSIL\WindowsFormsIntegration\v4.0_4.0.0.0__31bf3856ad364e35\WindowsFormsIntegration.dll
QP5, Version=5.276.15058.36019, C:\Program Files (x86)\Dell\Toad for MySQL Freeware 7.5\qp5.dll
**********************************************************************
Licensing
**********************************************************************
DBA, Debugger

#################################################################################

Thanks

153 0 / Create an account to join the discussion.
sparrow_ce
Follow / 13 Aug 2015 at 2:12am / Toad for MySQL
Latest post by on 17 Aug 2015 at 10:17pm

Connection String - How To Set Up

Expand content
I am using Toad for MySQL freeware, and am not able to connect using the options in drop down menu. The connection is refused from host. After talking to host support, they told me I can only ' connect...

I am using Toad for MySQL freeware, and am not able to connect using the options in drop down menu.  The connection is refused from host.  After talking to host support, they told me I can only 'connect only to the mysql through the php only through the connection string'.  I do have the connection string, but am not finding if it's possible or how to set it up.  Have searched, but also not finding answer.  Is this possible?  Thank you.

Unanswered 335 1 / Create an account to join the discussion.
jpetersen@tablesafe.com
Follow / 11 Aug 2015 at 7:46pm / Toad for MySQL
Latest post by on 13 Aug 2015 at 11:50pm

Old toad Install vs New Toad Install issue: Right-click Procedure...

Expand content
A coworker recently introduced me to Toad, and he's running Toad 7.2. He showed me his setup and right-clicked a procedure and it popped up a dilogue for him to put in arguements for the procedure...

A coworker recently introduced me to Toad, and he's running Toad 7.2. He showed me his setup and right-clicked a procedure and it popped up a dilogue for him to put in arguements for the procedure before it ran, it looked really slick. Then, following his example, I grab toad, point to the same DB, right click, run, and get...





So... is it the version? Just a feature that was dropped? Is it a bug? Some mystery setting is needed that my coworker didn't recall at the moment? Or am I secretly just a coma patient hooked up to a malicious AI who's giving me boring but frustrating dreams for the rest of time? Advice is appreciated.

Unanswered 367 2 / Create an account to join the discussion.
pslick
Follow / 11 Aug 2015 at 12:47pm / Toad for MySQL
Latest post by on 13 Aug 2015 at 11:45pm

jdbc driver

Expand content
Toad for MYSQL for Mac has an eclipse driver for jdbc connections. Is that possible with the windows version?

Toad for MYSQL for Mac has an eclipse driver for jdbc connections. Is that possible with the windows version?

Unanswered 342 1 / Create an account to join the discussion.
gowtham_chandra
Follow / 6 Aug 2015 at 6:24am / Toad for MySQL

Facing Issue while Importing Data into Tables from .xls/.csv files...

Expand content
Hi there , I'm using Toad for MySQL product for the past the few months. Its fine when working with queries. But, whenever i want to insert data of 2k or more records, I'm going for Import...

Hi there , 

I'm using Toad for MySQL product for the past the few months. Its fine when working with queries.

But, whenever i want to insert data of 2k or more records, I'm going for Import Wizard. I tried to import from both .XLS and .CSV files. But Import doesn't processed. Showing "Object Reference Error". 

Please help ASAP.

Unanswered 360 0 / Create an account to join the discussion.
MrPrastastic
Follow / 27 Jul 2015 at 6:22pm / Toad for MySQL
Latest post by on 3 Aug 2015 at 3:12pm

Exporting blobs as ASCII instead of hex

Expand content
Hi, I've got an existing table which has a number of blobs in it which I need to read as ASCII. I have two questions: 1) They show up in the view as hex - if I click on them it lets me view them...

Hi, I've got an existing table which has a number of blobs in it which I need to read as ASCII. I have two questions:

1) They show up in the view as hex - if I click on them it lets me view them as ASCII but it makes scanning through the data tricky. Is there a way to have them viewed in the table as ASCII?

2) More importantly, when I export to excel / csv they are formatted as hex - I can do a manual conversion but there a lot of data and the rows are comparatively large (1500+ characters) so using a formula to convert isn't really feasible. Is there a way to export directly as ASCII?

I noticed this question had been asked previously but that was in 2012 and got absolutely no replies. Thanks in advance.

487 1 / Create an account to join the discussion.
manoj_cer
Follow / 27 Jul 2015 at 7:30pm / Toad for MySQL
Latest post by on 3 Aug 2015 at 3:01pm

Reinstallation not working Toad for Sybase

Expand content
Today, i got the Toad Freeware period expired notification and asked me to download the latest version(for my Toad for sybase). I downloaded and installed 2.1.0.2921. Even after installing i am getting...

Today, i got the Toad Freeware period expired notification and asked me to download the latest version(for my Toad for sybase). I downloaded and installed 2.1.0.2921. Even after installing i am getting the same notification and I am unable to start the application. I tried this multiple times with the same result. I tried manually uninstalling and reinstalling, still with the same issue. Even restarted the computer as well before installation, but same result. Any idea on what I need to do. Please let me know

Thanks

M

Unanswered 521 3 / Create an account to join the discussion.
Kal_elSpider
Follow / 30 Jul 2015 at 3:41pm / Toad for MySQL
Latest post by on 3 Aug 2015 at 2:58pm

Toad for SQL Error

Expand content
Hi, I installed Toad for sql 6.1 and works fine, but yesterday i executed the program and appear a error, i downloaded the most recent version 6.6 and replaced the 6.1 version, but to execute the version...

Hi, I installed Toad for sql 6.1 and works fine, but yesterday i executed the program and appear a error, i downloaded the most recent version 6.6 and replaced the 6.1 version, but to execute the version appears the next error:

System.Security.VerificationException
La operación no puede desestabilizar el tiempo de ejecución.
Stack Trace:
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.SortButtonListCore(List`1 positiveList)
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.SortButtonList(BaseButtonCollection buttons)
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.EnsureButtons(Graphics g, Rectangle bounds, BaseButtonPainter buttonPainter)
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.Calc(Graphics g, Rectangle bounds)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcButtons(BaseTabPageViewInfo info, Rectangle bounds)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcPageViewInfo(BaseTabRowViewInfo row, BaseTabPageViewInfo info, Point& topLeft)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcRowsViewInfo(Rectangle rect, Size buttonsSize)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcRowsViewInfo(Rectangle rect)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcViewInfo(Graphics g, Rectangle r, TabHeaderLocation hLocation)
   en DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.CalcViewInfo(Rectangle bounds, Graphics g)
   en DevExpress.XtraBars.Docking2010.Views.Tabbed.DocumentGroupInfo.CalcCore(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.BaseElementInfo.DevExpress.XtraBars.Docking2010.Views.IBaseElementInfo.Calc(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.Tabbed.TabbedViewInfo.CalcGroups(Graphics g, Rectangle bounds, Int32[] intervals, DocumentGroup[] groups, Int32[] splitLengths, Rectangle[]& rects)
   en DevExpress.XtraBars.Docking2010.Views.Tabbed.TabbedViewInfo.CalculateCore(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.BaseViewInfo.Calc(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.BaseView.EnsureLayoutCalculated(GraphicsCache cache)
   en DevExpress.XtraBars.Docking2010.DocumentManager.PatchChildrenCore()
   en DevExpress.XtraBars.Docking2010.DocumentManager.PatchActiveChildren()
   en System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   en System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   en System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   en System.Windows.Forms.Control.InvokeMarshaledCallbacks()

I dont known what this mean, i executed by Admin, and this doesnt works, if somebody can help me with this error to solve. Thanks a lot.

449 1 / Create an account to join the discussion.
jhvheusden
Follow / 17 Jul 2015 at 12:31pm / Toad for MySQL

BUG: In compare schema tool, source and target database are swapp...

Expand content
In compare schema tool, source and target database are swapped. So the script generated applies the changes in the target database to the source database, instead of the other way. Please can this bug...

In compare schema tool, source and target database are swapped.

So the script generated applies the changes in the target database to the source database, instead of the other way.
Please can this bug be corrected? This is quite annoying!

(I have seen many complaints about not working compare schema tool, maybe the swapped entries are the root cause of these complaints?)

Regards, Jan-Hendrik

476 0 / Create an account to join the discussion.
g greaves
Follow / 26 Jun 2015 at 11:52am / Toad for MySQL
Latest post by on 29 Jun 2015 at 8:36am

A Never Ending Loop In Toad for MySQL Chart Designer - Forced To Kill...

Expand content
In the Data window, of the Chart Wizard, I just happened to delete the Argument and Value information which sent Toad for MySQL into a never ending loop with a message box popping up saying "Argument...

In the Data window, of the Chart Wizard,  I just happened to delete the Argument and Value information which sent Toad for MySQL into a never ending loop with a message box popping up saying "Argument isn't compatible with the current argument scale type". I cannot be certain what was in the Series Binding but it was Date type for the X Axis and numeric for Y Axis.

1719 1 / Create an account to join the discussion.
g greaves
Follow / 26 Jun 2015 at 11:42am / Toad for MySQL
Latest post by on 29 Jun 2015 at 8:32am

Error Changing Report Header

Expand content
I got this error message while changing the Report header... System.NullReferenceException Object reference not set to an instance of an object. Stack Trace: at DevExpress.XtraVerticalGrid.NormalState...

I got this error message while changing the Report header...

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at DevExpress.XtraVerticalGrid.NormalState.GetFocusedRecordNavigatonInfo(Int32 beginIndex, Int32 endIndex, Int32 step, Boolean forward)
at DevExpress.XtraVerticalGrid.NormalState.GetNextTabNavigatonInfo(Boolean forward)
at DevExpress.XtraVerticalGrid.NormalState.NavigateControl(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.NavigateControl(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.BehaveControl(KeyEventArgs e, Boolean showEditor)
at DevExpress.XtraVerticalGrid.EditingState.KeyDownCore(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.NormalState.KeyDown(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.KeyDown(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.ControlState.ProcessChildControlKey(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.ProcessChildControlKey(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.VGridControlBase.RaiseEditorKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.Container.EditorContainer.DevExpress.XtraEditors.Container.IEditorContainer.OnEditorKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.TextEdit.OnEditorKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.BaseEdit.OnKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.TextEdit.OnMaskBox_KeyDown(Object sender, KeyEventArgs e)
at System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.Mask.MaskBox.OnKeyDown(KeyEventArgs e)
at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.TextBoxBase.WndProc(Message& m)
at System.Windows.Forms.TextBox.WndProc(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.BaseWndProc(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.MaskStrategy.SimpleStrategy.DoWndProc(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.WndProc(Message& m)
at DevExpress.XtraEditors.TextBoxMaskBox.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I can reproduce it and it occurs whenever I change the information in the Text field. I changed it from the default to IT Team and to check if it was a one off I changed it to IT DBA Team and got the same error. The application does not crash and I don't have to force quit Toad for MySQL.

1627 1 / Create an account to join the discussion.
mwsasser
Follow / 24 Jun 2015 at 3:15pm / Toad for MySQL
Latest post by on 26 Jun 2015 at 2:50pm

Weird error using Compare

Expand content
I keep getting a weird error when using any of the Compare options while connecting to a remote host. In this specific case it is a HostGator server. Keyword not supported: `btkkw;pooling'. I am...

I keep getting a weird error when using any of the Compare options while connecting to a remote host.  In this specific case it is a HostGator server.  

Keyword not supported: `btkkw;pooling'.

I am using Toad for MySQL 7.5.0.966.  This has been happening for a the past month or more.  I noticed it while running 7.3.x, updating hasn't helped.  Otherwise I can connect to the remote server with no problems, view the db, make changes and export with out problems.

Can somebody please help me with this problem?  Maybe make some suggestions?

1804 1 / Create an account to join the discussion.
paulhavey
Follow / 19 Jun 2015 at 4:32am / Toad for MySQL

Toad MySQL Version Control for triggers uses only the tablename not...

Expand content
Toad MySQL Version Control for triggers uses only the tablename not the triggername so you cannot commit multiple triggers INSERT + UPDATE + DELETE for the same table. Each successive commit will overwrite...

Toad MySQL Version Control for triggers uses only the tablename not the triggername so you cannot commit multiple triggers INSERT + UPDATE + DELETE for the same table.

Each successive commit will overwrite the last and then a get latest will drop those triggers from the database.

2207 0 / Create an account to join the discussion.
chuksie2003
Follow / 5 Jul 2011 at 3:07pm / Toad for MySQL
Latest post by on 18 Jun 2015 at 2:42pm

Toadformysql versionable objects

Expand content
I have MySQl 5.1 and interfaces it with subversion edge using ToadForMysql. When i attempt to add objects to subversion it only shows tables, views and triggers. the procedures, functions and scripts are...
I have MySQl 5.1 and interfaces it with subversion edge using ToadForMysql. When i attempt to add objects to subversion it only shows tables, views and triggers. the procedures, functions and scripts are not been included. is there a setting or something i could be missing in my subversion configuration?   or are there objects that can not be versioned from toadformysql?
8927 2 / Create an account to join the discussion.
Elliott
Follow / 11 Jun 2015 at 3:18pm / Toad for MySQL

Customizing connection string to set Allow Zero Datetime=true for...

Expand content
I am using Toad for MySQL to access my database. The database contains datetime values of 0000-00-00 00:00:00. Toad is converting these to null, but I don't want that since the database structure is...

I am using Toad for MySQL to access my database. The database contains datetime values of 0000-00-00 00:00:00. Toad is converting these to null, but I don't want that since the database structure is not allowing these fields to be null. I think I can avoid this problem by adding Allow Zero Datetime=true to the connection string, but I don't know how to do that in Toad for MySQL - i.e. customize the connection string to include that parameter. I tried to manually edit the .xml file that contains the connections strings, but that seemed to have no affect, and my changes were overwritten the next time I exited Toad.

Is there a way to customize the connection string? And if so, will that solve my problem?

2699 0 / Create an account to join the discussion.
Veljko Stanisic
Follow / 11 Jun 2015 at 11:03am / Toad for MySQL

Resignal in stored procedure

Expand content
Toad's SQL editor is signaling incorrect syntax near 'resignal' when resignal is used in a stored procedure. Syntax is actually correct and procedure executes successfully and without errors...

Toad's SQL editor is signaling incorrect syntax near 'resignal' when resignal is used in a stored procedure. Syntax is actually correct and procedure executes successfully and without errors. For example:

declare exit handler for sqlexception
    begin
      rollback;
      call p_log_event();
      commit;
      resignal;
    end;

...


When I have any other error in further code, Messages tab in Results window is always pointing to the line where resignal is called, so i get mislead.

2780 0 / Create an account to join the discussion.
bayridge1
Follow / 9 Jun 2015 at 4:55pm / Toad for MySQL
Latest post by on 11 Jun 2015 at 9:30am

Can't figure out how to connect to a database

Expand content
I am hosted by Godaddy and no matter what I try, I can't connect to my databases. Here's what I'm using. Of course I'm using my real userid, pswd and db name. Is localhost correct or should...

I am hosted by  Godaddy and no matter what I try, I can't connect to my databases. Here's what I'm using. Of course I'm using my real userid, pswd and db name. Is localhost correct or should it be a ip addy? I tried the ipaddy and that didn't work either. Guess I can't paste image here. I have TCP and localhost and port 3306.

3001 2 / Create an account to join the discussion.
benyitzhaki
Follow / 6 May 2015 at 1:59pm / Toad for MySQL
Latest post by on 8 Jun 2015 at 3:51pm

Compare schemas - can i produce clean "alter" statements...

Expand content
I'm struggling with an issue when trying to compare schemas of two mysql databases. I'll explain with an example: I have added an index to one of the columns, something that should have been...

I'm struggling with an issue when trying to compare schemas of two mysql databases. I'll explain with an example:

I have added an index to one of the columns, something that should have been summed as something like:

ALTER TABLE `tablename`

ADD INDEX `index_name` (`column_name`);

And instead.. it wants me to do the whole "create temp table, copy data to temp table, drop original table,rename temp table to original table name".. that's crazy and moreover, it might (and will) lead to some downtime when trying to update a production db.

Is there a way to change that behavior?

Thanks

5301 1 / Create an account to join the discussion.