You will no longer receive e-mail notifications from this forum.
Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
I have recently discovererd toad and I am very impressed so far.I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the connection to the database server, it works OK.I spent some time googling about this problem, but have'nt found anything. Does anyone have any suggestions?I am using Toad 220.127.116.112 on Windows 7 Ultimate 64-bit.
I have a series of scripts coded and saved in individual .sql files. Is there a way to run a .sql file from within the editor, e.g. (pseudo code)
Now that .NET Core has been out for a while, is Toad for MySQL running on Linux any closer to happening?
I have created .tas files and scheduled for a specific time, but emails or email failure messages are not sent. It shows to have run successfully in job manager. Any thoughts or ideas?
Even though I've selected databases across different servers, I'm getting error when trying to group execute the SQL script:
"Lookup Error - MySQL Database Error: No database selected"
After that, the "Execute Scripts" button is stuck as a red stop circle, until I cancel the "Group Execute" option by clicking on its green double green arrow button.
After doing that, I'm not able to mark the "Group Execute" checkbox in the vertical "Group Execute" tab on the left side of the editor.
I'm using Toad for MySQL 18.104.22.1687.
I might be being a little obtuse here but I cannot work out to insert the full result set into a e-mail body from a SQL Execute,
I enter the variable name as #Result# in the body which returns the first row from the result set. Does anyone know how to insert the full result set without using an attachment.
I did a fair amount of looking around and I am getting nowhere!
Thanks in advance!!!
When I do a schema compare, I have a table that Toad shows has a difference, but the tables match. Below in the screenshot shows where the difference is, but they are actually matches.
Is there a parameter that could be causing this?
I have Mysql Toad loaded on two machines. One is running 7.7 and the other 22.214.171.1247. Both machines were able to open the same TPG file stored on dropbox. After upgrading to 126.96.36.1997 the tpg file does not open. normally after successfully opening the filename appears on the tab. On the 7.9 version, it shows "untitled" on the tab and you cannot show underlying grid by right clicking.
Has something changed?? Any troubleshooting tips?
thanks very much!
I set up a SSH tunnel connection following these steps, which works fine, except that TOAD complains about [Authentication method 'mysql_clear_password' not supported by any of the available plugins]I fixed the very same problem with HeidiSQL by putting mysql_clean_password.dll and dialog.dll in a plugin folder, but I can't figure where to put those two dll's in TOAD in order to make it find them.Can anyone help ? Looks like most of the dll are somehow "declared" in *.pck file if it can help.
Thank in advance !
11:04:18 ч. Thread (20) Export Started [31.8.2016 г. 11:04:18 ч.]11:04:18 ч. Thread (20) Export Wizard: Building object list11:04:19 ч. Thread (20) Exporting Data (1 of 1)11:04:19 ч. Thread (20) Object SQL Query started.11:04:19 ч. Thread (20) Writing rows 0 - 111:04:19 ч. Thread (20) Exception in WriteRows11:04:19 ч. Thread (20) Object reference not set to an instance of an object.11:04:19 ч. Thread (20) Writing rows Finalize11:04:19 ч. Thread (20) Object Table Result Set finished with error: Object reference not set to an instance of an object.11:04:19 ч. Thread (20) at Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable fastTable) at Quest.Toad.ImportExport.ExportObjectData.StartTableWrite(Object context) at Quest.Toad.ImportExport.ExportObjectData.Begin(LogEventHandler logEventHandler, Dictionary`2 connections, Object context)11:04:24 ч. Thread (20) Export Finished [31.8.2016 г. 11:04:24 ч.]
Hi, I have a question, how do i turn off case sensitive feature on toad for mysql v 7.0? Cause it seems like I can't search/query data with different type of cases, let say "Azman/aZman/azMan/azmAn/azmaN/AZMAN" or any other type of cases will give me different results. It's like it checks base on case sensitive. Hope someone can help me.
Thank you so much.
I have 3 installations of toad. I have version 7.0, 7.7, and 7.9.
I have 147 MySQL servers. They are all on linux vm's.
With version 7.0 I can login to all of my servers using TCP.
With version 7.7 or 7.9 I cannot log into any server. I have tried to create new connections with the 7.7 & 7.9 versions but that does not resolve the issue. As, far as i am concerned versions 7.7 & 7.9 are useless to me.
suggestions would be appreciated.
I am trying to schedule an automated job but on clicking schedule get popup with error "Access Denied"
Using v 188.8.131.521 schema compare.Every table is marked as different if you have the compare auto increment option on (not the auto increment value), you need to turn on the ignore option for both auto increment and auto increment value for the schema compare to make any sense.All the other options seem to be fine.Is this a bug?Thanks,Mark.
When using "Schema Compare"
the Datetime Default value CURRENT_TIMESTAMP appears in the ' CURRENT_TIMESTAMP' .
Must appear at CURRENT_TIMESTAMP.
' must not be written.
I think this is not a difficult error.
I hope it will be able to correct it soon.
Suddenly I find as I am typing in the editor window, Toad is instantly checking syntax in real time and automatically flipping over to the Messages tab to show the result of that syntax check - all as I am typing.
I find this annoying as I would rather it stay on the Result Sets tab of the previous output (as it always used to do) - until I am ready to execute the statement again.
Is there a setting to change this behavior?
I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung. I can't do anything in the software, and I can't quit and I have to terminate the process. This happens several times a day.Running on Windows 7 x64. Anybody know what's going on and how to fix this/
Help me out !
MySQL error message: error #2006
What does this message mean? Is there something I can do myself to repair MySQL?