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 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 !
I have Mysql Toad loaded on two machines. One is running 7.7 and the other 18.104.22.1687. Both machines were able to open the same TPG file stored on dropbox. After upgrading to 22.214.171.1247 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!
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 126.96.36.1991 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.
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 188.8.131.527.
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?
I have created database diagram for my schema using toad. It was done and fine. While saving by default, it is .ter format. And accepting no other formats. How can I save my diagram as an Image file (for ex .jpg) ?
Thanks in advance ! :)
Hi, I'm trying to compare schemas with 2 MySQL databases using a snapshot.
How do I create a snapshot? According to the help file I click on an icon/button that I'm unable to find.
Thanks for your help.
I have a problem about data extract which is too big to handle manually so I need to create a temp table which to insert some data and then use that temp table to write the select query joining different other tables to get the required data,..
my issue is that I have 1 db where I'm able to create temp table but the db where I need to get the primary data from is located on another db (another server)
I have googled it how can I query from different dbs and found some cross-query but still cannot find something specific guide for that issue and at whole if this is possible to be done .
Can you please provide some experience help regarding that issue?
is Toad for MySQL freeware free for commercial use?
I clicked edit, but nothing happens, including some buttons that open the edit
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?