You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for MySQL great and have the most points for this month!
Can someone explain to me how i can open a new Script editor via a keyboard shortcut? This is driving me insane. I tried to set my own shortcut using Tools>Options>Keyboard but 'New Script' command is not listed there. Hopefully i am missing something?
Toad for MySQL version: 184.108.40.20650
I am Unable to connect Remote MySQL database using " Toad for MySQL ,Version 220.127.116.1122 ".
Server is listening on port 3306.I can access the same database remotely through MySQL Workbench 6.1 but can't access through Toad.
Also firewall is not blocking access to server.
I have attached error screen and telnet response on port 3306.Please help me to resolve problem.
Is it just me???
Whenever I leave my Toad for MySQL open on my desktop for a long time it becomes somewhat non-responsive.
"A long time" is roughly 1 hour, but I'm not sure exactly.
"somewhat non-responsive" means that I can type in the editor, click on menus/toolbars, but when I try to execute a query the program does not respond.
My work around is to use Windows Task Manager and end task the TOAD application.
I do this several times a day.
Any ideas, help, and/or workarounds would be appreciated.
I really enjoy using this product, but I'm really getting tired of using task manager.
Just downloaded Toad for Mysql when I try to connect I get the following error:
"Unable to connect to any of the specified MySQL hosts."
release notes say you have to download Toad 7.0 to correct this error. Only Toad 7.3 is available for download, how do you find Toad for Mysql 7.0 for download??
You can probably guess from the question that I'm new to this environment, so please bear with me.
I have my.ini including a reference to the windows authentication plugin, as below:
I've rebooted both my desktop and the server.
I have this both on my Windows 8 client install and the Windows Server 2012 server install. When I connect to the server and list plugins via the command below:
select *from information_schema.PLUGINSwhere plugin_name like '%mysql%';
I do get that the plugin is there and installed:
but when I try to create a login (below), it tells me that the plugin is not installed.
CREATE USER cust_login IDENTIFIED WITH authentication_windows AS 'domain\\MyWindowsName';
Plugin 'authentication_windows' is not loaded
Is my connection to MySQL using the my.ini file? If not, how can I set that in TOAD?
I have downloaded Taod for MySQL 7.3 and have a problem with the Autocomplete feature.
1. It does not pop up automatically. For example, when I type a table alias followed by a period(.) I would expect that autocomplete shows a list of columns of the table.
2. If I activate the autocomplete popup with CTRL+Period it pops up quickly and disappears right away. I am not able to select anything from it.
Is there a fix for this?
For people who require old installers they are now available at.
Toad for MySQL 18.104.22.1683
Toad for MySQL 22.214.171.1242
Toad for MySQL 126.96.36.1994
Toad for MySQL 7.0.2038
Toad for MySQL 188.8.131.5222
The new version of Toad for MySQL 6.3 is now available for immediate downloadfrom www.toadformysql.com .Contains improved user interface for automation, query builder, editor and addsintegration to Sharepoint. Also features improvements in document recovery, CodeCompletion, Code Snippets, Report Designer, Project Manager, FTP andperformance./Henrik JohnsonQuest Software
The new stable version of Toad for MySQL 7.2 is now available for immediate download.
Just head over to the download section and get it right now!
i have the problem that, if i execute a statement with joins inside and try to change a value in the grid, i get an error like:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET fk_Auftragsstatus = 21 WHERE (id = 5614440 OR (NULL = 1 AND id IS NULL))' at line 1
One Statement for example, but i get the error with any other select with join:
select Auftrag.* from Auftrag inner join Auftragsposition B on Auftrag.id = B.fk_Auftrag and B.fk_Auftragsart = 1inner join Auftragsposition A on Auftrag.id = A.fk_Auftrag and A.fk_Auftragsart = 2where fk_Auftragsstatus = 33 and A.Storno = 0 and B.Storno = 0;
What its wrong? With Toad 6.0 there was not that Error.
I'm not beeing able to open the script editor when creating a new View or editing an old one. On MySQL Workbench a similar problem occuried, but it was only a matter of chosing a default Scheme. On Toad, even chosing a default one, the screen still freezes when trying to open the editor. Does anyone know why it might happen or have seen a similar problem? 64bits / 32bits problem maybe?
Windows 8.1 Pro 64bits
i7 2.2GHz CPU
MySQL Server v5.6.21 X64
Connector/ODBC v5.3.4 X86 and X64
Toad for MySQL Freeware v184.108.40.20650 and v220.127.116.1141 Beta (both didn't work, not even running as administrator)
When browsing through tables / views in object explorer I often need to run select statement on a table to see the data. Only option I know is to make a right click -> generate SQL -> Select statement -> To editor and then click on run button. This is very inconvenient and time consuming. Is there any way to define a shortcut which would do all the steps at ones?
First of all I'm just beginner so forgive me for asking stupid questions ... ;-)
I'm using wampserver ( MySql 5.6.12) on windows XP and after installing a new Toad 18.104.22.16850 version noticed a problem in editor and grid view with special characters ...
For example sql "select 'žćčđšŽĆČĐŠ' from dual" returns 'žccdšŽCCÐŠ' ?!? I tried to change editor character encoding from "windows default" to utf8, but the result is the same.
Simple "select on a table" returns correct values from database, but when I try to update table for example like "update table set column = "Č" database is updated with "C" values instead of "Č"?!? The same things happend when I update through the "Table/Data View" editor.
Thanks in advance ZKlas
In a previous version of toad I could just push F9 from the editor window to run the statement where my cursor was. For example - | shows where the cursor is.
Select * from table1;
Select * from ta|ble 2; <-- the cursor is here but the statement isn't highlighted. Pushing F9 would execute this statement.
Select * from table 3;
My company have updated the version ro 10.1.1.8 and now if I try this it doesn't work - it only works if I highlight the statement.
Is there a setting or option I can set to make this work like it used to? It's a pain having to highlight the whole statement when some are many lines long.
THere has been some time since I last time connected to my few MySQL DBs via Toad, and today when I tried to connect I got the following error:
System.Xml.XmlException'', hexadecimal value 0x03, is an invalid character. Line 1, position 1.Stack Trace: at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.Throw(String res, String args) at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Char data, Int32 length, Int32 invCharPos) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlTextReaderImpl.Read() at System.Xml.XmlTextReader.Read() at System.Xml.XmlReader.MoveToContent() at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving) at System.Data.DataSet.ReadXml(String fileName) at Quest.PersistentCache.DataEngine.LoadDataSet() at Quest.PersistentCache.DataEngine.Contains(DimensionTypes dimensionType) at Quest.PersistentCache.PersistentCache.Contains(DimensionTypes type) at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.SetObjectNodeImage(TreeListNode node, ITrl trl) at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.SetNodeImage(TreeListNode node, ITrl trl) at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.CreateTypeNode(TreeListNode parentNode, String type) at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.CreateParentTypes(TreeListNode parentNode, String type) at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.updateContentTimer_Tick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
First I thought that as I had old Toad 6.xx, I firstly upgraded it to the newest but I still get the same error.
As host for Toad I have Win7 and MySQLs are running on CentOs, even though I think this is Windows issue.
All the other connection methods are working just fine (SQLYog, MysqlCLI)
All documentation online is for Toad for DB2 and the menus they talk about are nonexistent in Toad for MYSQL. Why is the most basic command so obtuse to perform?
I had 2 queries in the editor window. I cancelled it 2X as I had the wrong info in my query. I stopped the background process and thought I was terminating the query. I went into the Session Monitor and see those 2 queries in the Query status under the Activity column. My question is, are these 2 queries still running as they are NOT in sleep mode? If they are how can I terminate them?
I have upgraded from 7.2 to 7.3 and was very disappointed with unrevertable UI changes. I've spent about 1 hour trying to make new version look like 7.2 version, recovering my old skin, placing windows in convenient layout etc. I am still unable to place tab toolbars above the tabs. I need only edit toolbar which has "format SQL" button. Having this toolbar below the tabs makes it hard to switch tabs - you need to find it between 2 rows of buttons.
One more thing which is hard to understand for me. How can I see at once database object tabs (with tables for example) from 2 different connections? When I open new Database Explorer it is opened with the tree of all objects at the left side so I have 2 trees at once. Also is I switch between SQL Editor tab from 2 different connections my DB Explorer tab is changed and I cannot. That is so confusing.
Other wishes about DB Explorer window: add refresh button to the toolbar and make is customazable, allow removing filter which just eats space, do not show "+" if there are no items in the list.
In Connection Manager allow removing toolbar - there are no useful buttons as for me. You rarely need to add new connections but switching between them is oftern operation. Switching is
Hi,When I run some big queries (>20MB sql script) Toad throws an out of memory error message. System.OutOfMemoryExceptionException of type 'System.OutOfMemoryException' was thrown.Stack Trace: at System.String.Replace(String oldValue, String newValue) at ActiproSoftware.SyntaxEditor.Document.GetText(LineTerminator lineTerminator) at ActiproSoftware.SyntaxEditor.SyntaxEditor.get_Text() at Quest.Toad.Editor.EditorForm.CheckConnection() at Quest.Toad.Editor.EditorForm.DoExecuteSqlScript() at Quest.Toad.Editor.EditorForm.ExecuteSqlScript()
I'm using Toad for MySQL 22.214.171.1242
Could anyone help me about this?
Thanks in advance