Hey, did you catch that redirect? The Toad World URL is now community.toadworld.com. Don't worry -- you'll still find all the same great content here (and more on the way). We're just in the process of giving our Toad World site some well-deserved love. Stay tuned for some more updates coming this way.
Meanwhile, enjoy community.toadworld.com.
You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
Could someone please confirm whether Toad for Sybase Freeware can be used for commercial purposes.
I fill out my information here:
The Zip File downloads fine. (Toad_for_SAP_2017_Full.zip)
Upon attempting to install, it asks for License.
I go to my email inbox. No matter how many times I repeat the download, I never get an email with the license.
(When I clicked the Join button for the Quest community, I got the welcome email soon after)
How can I get a license to complete the install? Thanks
we're using Toad for SAP 18.104.22.1685 and every time someone connects to our servers using toad it opens a new version on the SYBASE IQ server.
this version will be open until the user CLOSES toad or disconnects from the server. -this behavior causes us to have lots of unneeded version on the server.
is it possible to disable this behavior?
there was a way to disable it when using ODBC connections, but as far as i know Toad is using .net connections.
Thanks for the help!
I recently received the "free period ended" message and upgraded to Toad for SAP Solutions 3.1. In Query Builder, when I double click on certain tables (that had no issues in my previous version), I am seeing a "Domain error during explicit conversion of INT value '0' to a BIT field" message. I can click OK and the table shows is added but the table doesn't show all of the fields. These tables were set up by others, I simply query off of them.
Is there no longer a 32-bit version of Toad starting with 3.2? Unfortunately some of our workstations require 32-bit Win7 for in-house applications.
Per subject, does the Toad client offer an option to save multiple (/all) open result sets as a single .xlsx file, under multiple spread sheet tabs?
(A result set on each excel tab)
Thanks in advance,
After successfully make connection to Toad for SAP , when right click on any table to choose anything appear the attached error or when open editor to write query appear the same error
this error appear when working on anything in toad
when try from different machine and different user appear the same error
How can i solve this error
I have installed TSAP 3.2
And in the explorer, all tabs are ok,
but the "views" tab do not show any views.
Parallel with TSAP 3.1 I can see all views.
There is no filter on "views" tab
Hello everyone, I´m new in the forum and in using Toad and I have the following problem: when I´m trying to connect to my SYBASE IQ 22.214.171.1249 server by Toad 126.96.36.1995 in a windows 7 64bit lap-top I set all the right connection parameters but when I try to connect the following message appears: "Could not load the encryption DLL"dbfips16.dll"", I can connect by InteractiveSQL but I really want to use toad, can someone help me with this error?
Thanks in advance and kind regards.
I was using the freeware version 188.8.131.52 without any issue, until the 1 year expiration. I was prompted to download the latest (2016) version 184.108.40.2065.
Upon installation, I immediately found out, while the new version inherited the saved connections, when I connected to the server, it only lists the table names, but cannot retrieve the column definition that normally shows in the bottom of Object Explorer. Instead, I got error message
"Attempt to insert NULL value into column 21 in work table (table id 4288282623); column does not allow NULLS. UPDATE fails."
I found if I close Toad for SAP and restart, the same error message will show up except with a different table id. I tried to use object_name() to get the work table name, only to get Sybase Database Error "Arithmetic overflow during implicit conversion of BIGINT value '4288282623' to a INT field ."I suspect it's some script for creating the work table. I even copied the script from Tools --> Options --> SQL Dictionary --> Db.CommonSql --> DescribeTableColumns from the old version 220.127.116.11. I found it is the same as the new version. I could run the script in 3.0 before, but when I created an editor and pasted the script and run, the very same error message "Attempt to insert NULL value into column 21 in work table (table id 4288282623); column does not allow NULLS. UPDATE fails." shows up.
The target SAP is ASE 16. On another connection to a ASE 15.7 server which the old 3.0 version had no issue on, it will connect to the server but no table will be listed. If I right click at the table area and select Refresh from the drop down, I will get an error "Invalid column name 'sysstat4'".
Is there any way to let me keep using the old but working version 18.104.22.168, instead of the 22.214.171.1245? Or is there any way (such as updating the script) so the work table's column 21 can allow NULL value? In the current state it is not usable.
Can we create hach file from Toad for SAP?
Can we export tables as pcp file?
Can we exported tables as inserted sql statements
Hello Experts -
I wanted to know if Toad for HANA 3.2 supports multi tenant architecture of HANA databases.
As we already know that from HANA 2.0 multi-tenancy is a mandate.
Awaiting replies. Thank you.
this script does not run in Toad for SAP ( HANA ) 126.96.36.1995
select X.COMPETENCE_CENTERS, X.ESTIMATED_PROJECT_COSTS_KEUR, X.IMPACT_ON_EBITDA_PER_YEAR_KEUR, round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1), case when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 0.1 and 0.9 then '0.5' when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 1.0 and 1.9 then '1' when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 2.0 and 2.9 then '2' when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 3.0 and 3.9 then '3' when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 4.0 and 4.9 then '4' when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 5.0 and 5.9 then '5' else '9' endfrom TOP_PROJECTS X;
I get only "SAP HANA Database Error:"
but no error number.
In SAP HANA studio 2 it works.
Any idea ?
this script will not run in Toad but in HANA Studio:
select x."Payback period in year", case when x."Payback period in year" > 0 and x."Payback period in year" <= 1.5 then '1' when x."Payback period in year" > 1.5 and x."Payback period in year" <= 2.5 then '2' else 'x' endfrom TOP_INVESTMENTS x
And I get not error message / number in Toad from HANA
I'm trying to connect to Sybase IQ 16 with Toad for SAP Solutions 3 from my laptop as a client.
After setting up all connection manager fields I’m getting a massage which states... <Database error> <Database server not found>
Do i need an ODBC connection on my laptop (client side?)
Note: with same connection settings Aqua Data Studio connects without any problem.
There is a problem with Toad for SAP which causes issues during production releases which had DDL changes.
How to reproduce:
1, Open Toad -> and connect to a Sybase IQ server via Connection manager
2. Go to View- > Object Explorer.
Now Check for table locks by using sp_iqlocks. You will see shared locks on ALL tables on the server, across all schemas.
Thus, if someone has a Toad session open during the release, any DDL on a tables such as alters, will fail with a table is in use error.
I don't understand why Toad needs to lock all tables .
We have many Toad sessions connected, and this is not feasible for us to control everyone and tell them not to use Toad during the release.
Has anyone come across this issue and do you have solution ?
Version : Licensed Toad for SAP 3.1.0 bugs 1109
I am looking at deploying Toad to a large group of Data Analysts and Developers. Some should have access to production data and some should not. I am wondering if there is anyway to lock the ability to add or remove connections in Connection Manager. I really like the ability to import groups of connections, but I don't want many of the users to be able to change this for security reasons.
Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ?
When we run Toad_for_SAP_Solutions_188.8.131.52_Mod.exe, there is an error message saying:
C:\Users\<userid>\AppData\Roaming\Quest Software\Toad for SAP Solutions 3.0\SQLFormatter\Long Format Leading Comma Uppercase.xml' already exists.
We checked and the xml file is not found.
Please kindly help how to fix this problem.
Thnaks a million.
I see that the Query Plan window was supposed to be fixed in 2.1 version, we're running 3.0 and no information is populated in the Query Plan window.
This is for straight SQL and thru a procedure, nothing in the window in either case.