# Latest **URL:** https://forums.toadworld.com/latest.md?page=471 [Latest](https://forums.toadworld.com/latest.md) · [Categories](https://forums.toadworld.com/categories.md) **Page:** 472 --- ## ["Incorrect syntax near the keyword" when filtering objects](https://forums.toadworld.com/t/incorrect-syntax-near-the-keyword-when-filtering-objects/30369)
**Author:** [@rayg73](https://forums.toadworld.com/u/rayg73)\ **Replies:** 5\ **Last updated:** [July 8, 2014, 2:16pm UTC](https://forums.toadworld.com/t/incorrect-syntax-near-the-keyword-when-filtering-objects/30369 "2014-07-08T14:16:54Z")
This has happened to me a lot with SQL Agent jobs when filtering with a keyword, but it may happen in other sections of the object explorer tree. It has also happened across Toad for SQL Server versions, including 5.6 Co… --- ## [Toad 12.1 64-bit on Windows7 is very slow](https://forums.toadworld.com/t/toad-12-1-64-bit-on-windows7-is-very-slow/27951)
**Author:** [@claes-goran.andersso](https://forums.toadworld.com/u/claes-goran.andersso)\ **Replies:** 5\ **Last updated:** [July 8, 2014, 1:57pm UTC](https://forums.toadworld.com/t/toad-12-1-64-bit-on-windows7-is-very-slow/27951 "2014-07-08T13:57:33Z")
I have been running Toad for many years but have never been soo irritated on Toad as I am now. All window handling is very slow. Switching between different windows takes 2s. Switching between different tabs in editor… --- ## [Toad for Oracle 12.5 expired after 10 days of use...](https://forums.toadworld.com/t/toad-for-oracle-12-5-expired-after-10-days-of-use/30390)
**Author:** [@masterx](https://forums.toadworld.com/u/masterx)\ **Replies:** 3\ **Last updated:** [July 8, 2014, 12:34pm UTC](https://forums.toadworld.com/t/toad-for-oracle-12-5-expired-after-10-days-of-use/30390 "2014-07-08T12:34:41Z")
All, I downloaded and installed Toad for Oracle Freeware (Version 12.5, 64-bit) on 6/25/2014 and got an expiry notice dialog on start-up of the application this morning. Since there was only 2 weeks or so of sporadic us… --- ## [Toad version 9.6.1.1 keeps crashing with exception code c0000005 on a query that runs instantly on Golden or PL/SQL Developer !](https://forums.toadworld.com/t/toad-version-9-6-1-1-keeps-crashing-with-exception-code-c0000005-on-a-query-that-runs-instantly-on-golden-or-pl-sql-developer/30388)
**Author:** [@jcchoy](https://forums.toadworld.com/u/jcchoy)\ **Replies:** 2\ **Last updated:** [July 8, 2014, 11:07am UTC](https://forums.toadworld.com/t/toad-version-9-6-1-1-keeps-crashing-with-exception-code-c0000005-on-a-query-that-runs-instantly-on-golden-or-pl-sql-developer/30388 "2014-07-08T11:07:38Z")
Here is the query from a non-partitioned table. define Rprt\_ID = “75401550186”; – ‘DATAMSGCNT\_DATAMSG\_ID’ value – Client Records select C.CLIENT\_PROCESSED\_CNT “Client Submitted” , round(case when (C.FILE\_R… --- ## [Lots of issues with 12.6 beta ( 64 bit for me)](https://forums.toadworld.com/t/lots-of-issues-with-12-6-beta-64-bit-for-me/30366)
**Author:** [@steven.kladitis\_687](https://forums.toadworld.com/u/steven.kladitis_687)\ **Replies:** 16\ **Last updated:** [July 8, 2014, 9:15am UTC](https://forums.toadworld.com/t/lots-of-issues-with-12-6-beta-64-bit-for-me/30366 "2014-07-08T09:15:49Z")
Unless I am logged into shcema with table , I get NO results. Using a subquery with -\> order by \<- in it causes toad to tell me I am missing a paran somewhere. During compare you are unable to check only column… --- ## [Single object compare.](https://forums.toadworld.com/t/single-object-compare/30373)
**Author:** [@steven.kladitis\_687](https://forums.toadworld.com/u/steven.kladitis_687)\ **Replies:** 1\ **Last updated:** [July 8, 2014, 8:17am UTC](https://forums.toadworld.com/t/single-object-compare/30373 "2014-07-08T08:17:29Z")
It woudl be MUCH easier to work with, if both source and target tabs were visible at the same time. There is lots of empty space on the screen. --- ## [sb custom queries not working](https://forums.toadworld.com/t/sb-custom-queries-not-working/30381)
**Author:** [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\ **Replies:** 1\ **Last updated:** [July 8, 2014, 7:12am UTC](https://forums.toadworld.com/t/sb-custom-queries-not-working/30381 "2014-07-08T07:12:47Z")
Nothing happens when I click on a custom query. --- ## [finding older version of Toad for SQL server](https://forums.toadworld.com/t/finding-older-version-of-toad-for-sql-server/30377)
**Author:** [@andrianavony](https://forums.toadworld.com/u/andrianavony)\ **Replies:** 1\ **Last updated:** [July 8, 2014, 6:18am UTC](https://forums.toadworld.com/t/finding-older-version-of-toad-for-sql-server/30377 "2014-07-08T06:18:09Z")
Hi, I’m looking for older version of TOAD. I use a software (StarLIMS) which doesn’t work with .Net \>= 4.0.30319. So I’m looking a older version (which one ?) of Toad which work with .Net 4.0. --- ## [Toad 3.5 SharePoint](https://forums.toadworld.com/t/toad-3-5-sharepoint/29908)
**Author:** [@bill.h.lee](https://forums.toadworld.com/u/bill.h.lee)\ **Replies:** 11\ **Last updated:** [July 7, 2014, 6:01pm UTC](https://forums.toadworld.com/t/toad-3-5-sharepoint/29908 "2014-07-07T18:01:56Z")
Is SharePoint supported in Toad Data Point base, or is the professional version required? --- ## [\[TDP 3.3.0.1526\] Automation - Zip Activity Can't See Files Created In a 'Container'](https://forums.toadworld.com/t/tdp-3-3-0-1526-automation-zip-activity-cant-see-files-created-in-a-container/30209)
**Author:** [@N.B](https://forums.toadworld.com/u/N.B)\ **Replies:** 5\ **Last updated:** [July 7, 2014, 3:04pm UTC](https://forums.toadworld.com/t/tdp-3-3-0-1526-automation-zip-activity-cant-see-files-created-in-a-container/30209 "2014-07-07T15:04:28Z")
Is there a reason why when I use a ‘container’ - such as a If/Condition, While, Group Activities, or Parallel - certain items that come after it (say, zipping a file) cannot ‘see’ the file name created by other actions -… --- ## [Save As for Data Pump's Use Existing File?](https://forums.toadworld.com/t/save-as-for-data-pumps-use-existing-file/30288)
**Author:** [@rjesse](https://forums.toadworld.com/u/rjesse)\ **Replies:** 2\ **Last updated:** [July 7, 2014, 12:23pm UTC](https://forums.toadworld.com/t/save-as-for-data-pumps-use-existing-file/30288 "2014-07-07T12:23:37Z")
Howdy, Using 12.6.0.10b (and others), Is there a way to “Save As” in Data Pump with the “Use Existing File”? I run several DP exp/imp with the only change being the date stamp in the name and the data/log files. Curren… --- ## [Why did all of my connections disappear?](https://forums.toadworld.com/t/why-did-all-of-my-connections-disappear/30321)
**Author:** [@tonybyrnes](https://forums.toadworld.com/u/tonybyrnes)\ **Replies:** 5\ **Last updated:** [July 7, 2014, 9:24am UTC](https://forums.toadworld.com/t/why-did-all-of-my-connections-disappear/30321 "2014-07-07T09:24:48Z")
I logged into Toad just now, and all of my connections were gone. I even went back in to attempt to re-import them from the XML file, and nothing was there. How do connections just disappear? Not cool. --- ## [Unable to connect using Toad for DB2](https://forums.toadworld.com/t/unable-to-connect-using-toad-for-db2/30310)
**Author:** [@trant](https://forums.toadworld.com/u/trant)\ **Replies:** 10\ **Last updated:** [July 7, 2014, 6:51am UTC](https://forums.toadworld.com/t/unable-to-connect-using-toad-for-db2/30310 "2014-07-07T06:51:20Z")
I installed Toad for DB2 5.6 (32-bit) When I try to connect to a DB2 database, I get the following error: ERROR \[42724\] \[IBM\] SQL1109N The specified DLL “GSKit Error: 202” could not be loaded. SQLSTATE=42724 Can I g… --- ## [Toad for Oracle version 12.5 not found. Please install the latest commercial version of Toad before attempting to run Toad for Oracle Beta.](https://forums.toadworld.com/t/toad-for-oracle-version-12-5-not-found-please-install-the-latest-commercial-version-of-toad-before-attempting-to-run-toad-for-oracle-beta/30170)
**Author:** [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Replies:** 15\ **Last updated:** [July 5, 2014, 11:18pm UTC](https://forums.toadworld.com/t/toad-for-oracle-version-12-5-not-found-please-install-the-latest-commercial-version-of-toad-before-attempting-to-run-toad-for-oracle-beta/30170 "2014-07-05T23:18:54Z")
I have a problem with new Toad 12.6b. I have 12.5 installed latest release installed but I get message Toad for Oracle Toad for Oracle version 12.5 not found. Please install the latest commercial version of Toad befor… --- ## [Export to Excel 2010 -- Dates](https://forums.toadworld.com/t/export-to-excel-2010-dates/7080)
**Author:** [@AdamS](https://forums.toadworld.com/u/AdamS)\ **Replies:** 2\ **Last updated:** [July 4, 2014, 2:46am UTC](https://forums.toadworld.com/t/export-to-excel-2010-dates/7080 "2014-07-04T02:46:51Z")
When I attempt to export results to Excel 2010 from a query against Teradata using ODBC connection the date columns appear blank in Excel. Any suggestions? --- ## [Upper case column headings but lower case SQL](https://forums.toadworld.com/t/upper-case-column-headings-but-lower-case-sql/30300)
**Author:** [@tonybyrnes](https://forums.toadworld.com/u/tonybyrnes)\ **Replies:** 1\ **Last updated:** [July 3, 2014, 7:18pm UTC](https://forums.toadworld.com/t/upper-case-column-headings-but-lower-case-sql/30300 "2014-07-03T19:18:27Z")
I prefer to write my SQL in lower case, it’s much easier for me to read and follow that way, but I’ve noticed that my result set comes through in lower case as well. Some programs will automatically create upper case co… --- ## [Where are Favorites saved?](https://forums.toadworld.com/t/where-are-favorites-saved/30316)
**Author:** [@rayg73](https://forums.toadworld.com/u/rayg73)\ **Replies:** 2\ **Last updated:** [July 3, 2014, 6:57pm UTC](https://forums.toadworld.com/t/where-are-favorites-saved/30316 "2014-07-03T18:57:52Z")
I had a Toad for SQL Server 6.1 Trial on my old machine with tons of Favorites (I love the feature and use it extensively). I was then given a new laptop and Toad is now installed on it. I went to my old one so that I co… --- ## [Just installed new version of TOAD, getting access violation in module 'oran11.dll'](https://forums.toadworld.com/t/just-installed-new-version-of-toad-getting-access-violation-in-module-oran11-dll/30313)
**Author:** [@CoreyRice](https://forums.toadworld.com/u/CoreyRice)\ **Replies:** 1\ **Last updated:** [July 3, 2014, 9:16am UTC](https://forums.toadworld.com/t/just-installed-new-version-of-toad-getting-access-violation-in-module-oran11-dll/30313 "2014-07-03T09:16:36Z")
Was running TOAD for Oracle v12.1 last week. Tried to run TOAD yesterday and it was expired. So today I downloaded & installed TOAD for Oracle 12.5 (32-bit). Now when I try to connect to a database I get: TOAD Error … --- ## [Show Preview in Toad 12.5](https://forums.toadworld.com/t/show-preview-in-toad-12-5/30337)
**Author:** [@hani.chahelli](https://forums.toadworld.com/u/hani.chahelli)\ **Replies:** 4\ **Last updated:** [July 3, 2014, 8:28am UTC](https://forums.toadworld.com/t/show-preview-in-toad-12-5/30337 "2014-07-03T08:28:50Z")
I have installed Toad 12.5 but the Preview pane is not there or is disabled (when you open a script), does anyone know how to turn it back on, unless ofcourse it was removed from this version of Toad. Your prompt attent… --- ## [Winner, winner, chicken dinner!](https://forums.toadworld.com/t/winner-winner-chicken-dinner/30319)
**Author:** [@rjesse](https://forums.toadworld.com/u/rjesse)\ **Replies:** 1\ **Last updated:** [July 2, 2014, 2:40pm UTC](https://forums.toadworld.com/t/winner-winner-chicken-dinner/30319 "2014-07-02T14:40:18Z")
So, there I am, with a request to undo 15,000+ rows updated via 5 UPDATEs that were over 10K lines long each and done incorrectly, in a test environment, or we’ll need to reset the whole environment and start over – a pr… --- ## [TOAD for Oracle 12.5.0.99 - Unable to find Oracle Home](https://forums.toadworld.com/t/toad-for-oracle-12-5-0-99-unable-to-find-oracle-home/30309)
**Author:** [@mark.langdon](https://forums.toadworld.com/u/mark.langdon)\ **Replies:** 3\ **Last updated:** [July 2, 2014, 3:53am UTC](https://forums.toadworld.com/t/toad-for-oracle-12-5-0-99-unable-to-find-oracle-home/30309 "2014-07-02T03:53:50Z")
Hi, I have just installed v12.5.0.99 and upon starting it says I do not have an Oracle Home installed which I do. This works fine with version 10.6.1.3. Is there a way that I can force it to see my Oracle Home? Thanks … --- ## [Cannot modify procedure](https://forums.toadworld.com/t/cannot-modify-procedure/30307)
**Author:** [@sm.sung](https://forums.toadworld.com/u/sm.sung)\ **Replies:** 2\ **Last updated:** [July 1, 2014, 11:58pm UTC](https://forums.toadworld.com/t/cannot-modify-procedure/30307 "2014-07-01T23:58:57Z")
we cannot modify procedure which made before for a database using Toad. but, If we use anoter tool(like orange), we can modify the procedure. Oracle vendor say ’ this is not oracle issue, ask toad vendor’ we tried the… --- ## [Object Search Not Working BETA Toad for Oracle version 12.6.0.11](https://forums.toadworld.com/t/object-search-not-working-beta-toad-for-oracle-version-12-6-0-11/30302)
**Author:** [@armand\_charest](https://forums.toadworld.com/u/armand_charest)\ **Replies:** 2\ **Last updated:** [July 1, 2014, 7:57am UTC](https://forums.toadworld.com/t/object-search-not-working-beta-toad-for-oracle-version-12-6-0-11/30302 "2014-07-01T07:57:35Z")
When you click on Search, Object Search; In the object Search Box I type in SYS which is in just about every single table we have. I clicked on two of my favorite schemas as wells as 1 other schema in the Other Schemas. … --- ## [Authorization?](https://forums.toadworld.com/t/authorization/30301)
**Author:** [@ij0208](https://forums.toadworld.com/u/ij0208)\ **Replies:** 5\ **Last updated:** [July 1, 2014, 7:22am UTC](https://forums.toadworld.com/t/authorization/30301 "2014-07-01T07:22:38Z")
Hi all I realise that I’m probably being very dim, but I’ve just downloaded and installed Toad for Oracle Freeware v12.5 (32-bit) and now it wants an authorization code. All free clues gratefully received. Cheers ian … --- ## [Expiration Date](https://forums.toadworld.com/t/expiration-date/30287)
**Author:** [@alessandrovalra](https://forums.toadworld.com/u/alessandrovalra)\ **Replies:** 5\ **Last updated:** [July 1, 2014, 5:45am UTC](https://forums.toadworld.com/t/expiration-date/30287 "2014-07-01T05:45:44Z")
Why, after download of 12.5 freeware 64-bit version, I get “1 july 2014” (tomorrow!) as expiration date? Thank you --- ## [Toad Data Point Beta 3.6.0.2944 is now available!](https://forums.toadworld.com/t/toad-data-point-beta-3-6-0-2944-is-now-available/30295)
**Author:** [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Replies:** 0\ **Last updated:** [June 30, 2014, 3:35pm UTC](https://forums.toadworld.com/t/toad-data-point-beta-3-6-0-2944-is-now-available/30295 "2014-06-30T15:35:50Z")
Installer is available on the TDA Community website: http://www.toadworld.com/products/toad-data-point/toad\_data\_point\_beta\_program/default.aspx Please note: There is no 64-bit installer anymore. The latest list of fix… --- ## [Toad Studio can't find columns like if the object is invalid](https://forums.toadworld.com/t/toad-studio-cant-find-columns-like-if-the-object-is-invalid/30045)
**Author:** [@malcolm.g.miles](https://forums.toadworld.com/u/malcolm.g.miles)\ **Replies:** 1\ **Last updated:** [June 30, 2014, 12:47pm UTC](https://forums.toadworld.com/t/toad-studio-cant-find-columns-like-if-the-object-is-invalid/30045 "2014-06-30T12:47:09Z")
Every so often get the error “Toad Studio can’t find columns like if the object is invalid” when trying to do a Generate SQL -\> Select command. If I view details on the table the Columns tab is empty while the other tabs… --- ## [Beta Released (12.6.0.11)](https://forums.toadworld.com/t/beta-released-12-6-0-11/30292)
**Author:** [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\ **Replies:** 2\ **Last updated:** [June 30, 2014, 11:52am UTC](https://forums.toadworld.com/t/beta-released-12-6-0-11/30292 "2014-06-30T11:52:17Z")
AWR & Statspack Browsers: You can now specify &InstanceID as a variable in custom charts. When you connect to a RAC instance, the currently selected Instance ID will be substituted into your query. When you connect to a… --- ## [Copy diagram without duplicating entities?](https://forums.toadworld.com/t/copy-diagram-without-duplicating-entities/30289)
**Author:** [@mlynott](https://forums.toadworld.com/u/mlynott)\ **Replies:** 1\ **Last updated:** [June 30, 2014, 11:17am UTC](https://forums.toadworld.com/t/copy-diagram-without-duplicating-entities/30289 "2014-06-30T11:17:48Z")
I want to be able to have a series of diagrams, each one adding new content to the diagram. If I create a diagram, copy and past it, I get duplicated entities, which I don’t want. Can someone recommend a way to do this? … --- ## [Enable Save Passwords Without Re-Installing](https://forums.toadworld.com/t/enable-save-passwords-without-re-installing/30282)
**Author:** [@ld\_pvl](https://forums.toadworld.com/u/ld_pvl)\ **Replies:** 4\ **Last updated:** [June 30, 2014, 7:07am UTC](https://forums.toadworld.com/t/enable-save-passwords-without-re-installing/30282 "2014-06-30T07:07:43Z")
Hi Forum, Firstly I apologize if this question has already been asked. I’ve searched around the forum but couldn’t find a related question - if anyone knows a previous post that answers the question please do link it. I… [Previous page](https://forums.toadworld.com/latest.md?page=470) [Next page](https://forums.toadworld.com/latest.md?page=472)