Toad for SAP Solutions Forum - Toad for SAP Solutions - Toad World
Danny Torres
Follow / 1 Nov 2016 at 2:16pm / Toad for SAP Solutions

We are now on Twitter!!! Contact a Technical Support expert today

Expand content
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

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

554 0 / Create an account to join the discussion.
sonic_spin
Follow / 18 Nov 2015 at 12:22pm / Toad for SAP Solutions
Latest post by on 24 May 2017 at 2:36pm

Toad for SAP Solutions ( IQ connection problem )

Expand content
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...

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.

Unanswered 5572 15 / Create an account to join the discussion.
h.blum
Follow / 3 Mar 2017 at 8:53am / Toad for SAP Solutions
Latest post by on 10 Apr 2017 at 12:08pm

Script not running in Toad but in HANA Studio

Expand content
Hi, 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"...

Hi,

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'
end
from TOP_INVESTMENTS x

And I get not error message / number in Toad from HANA

Holger

Unanswered 489 8 / Create an account to join the discussion.
AzaMull
Follow / 14 Mar 2017 at 6:41pm / Toad for SAP Solutions
Latest post by on 29 Mar 2017 at 2:03am

Tables are locked by 'Toad for SAP 3.1.0.bugs.1109' when using...

Expand content
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...

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

Unanswered 388 4 / Create an account to join the discussion.
thompsojmd
Follow / 2 Feb 2017 at 4:41pm / Toad for SAP Solutions
Latest post by on 2 Feb 2017 at 7:03pm

Can Add/Remove Connection be locked in Connection Manager

Expand content
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...

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.

397 2 / Create an account to join the discussion.
Deandyno
Follow / 30 Jan 2017 at 7:03pm / Toad for SAP Solutions
Latest post by on 31 Jan 2017 at 8:41pm

User database groups

Expand content
Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ? Thanks, Dean

Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ?

Thanks, Dean

Unanswered 397 2 / Create an account to join the discussion.
hcsiu
Follow / 20 Jan 2017 at 2:50am / Toad for SAP Solutions
Latest post by on 20 Jan 2017 at 7:25am

Toad for SAP Solutions 3.0.0.129_Mod. error

Expand content
When we run Toad_for_SAP_Solutions_3.0.0.129_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...

When we run Toad_for_SAP_Solutions_3.0.0.129_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.

Best regards.

421 1 / Create an account to join the discussion.
Deandyno
Follow / 5 Dec 2016 at 6:06pm / Toad for SAP Solutions
Latest post by on 15 Dec 2016 at 3:52am

Query Plan doesn't show

Expand content
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...

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.

707 7 / Create an account to join the discussion.
plankton
Follow / 14 Dec 2016 at 2:06pm / Toad for SAP Solutions
Latest post by on 14 Dec 2016 at 3:00pm

Issue With Executing Multiple Select Statements- Results Are Produced...

Expand content
Hi, I'm new to Toad and am currently using Toad for Sybase version 2.1.0.2921. I need the functionality that was built in for this post ( http://www.toadworld.com/products/toad-for-sap-solutions...

Hi,

I'm new to Toad and am currently using Toad for Sybase version 2.1.0.2921. I need the functionality that was built in for this post (http://www.toadworld.com/products/toad-for-sap-solutions/f/24/t/21931?pi11637=2). Is there an enhancement for Toad for Sybase that would give me this functionality? If not, would I be able to switch to Toad for SAP and still work off of a Sybase-ASE server?

-Thanks

Unanswered 497 2 / Create an account to join the discussion.
h.blum
Follow / 16 Nov 2016 at 2:32pm / Toad for SAP Solutions
Latest post by on 21 Nov 2016 at 10:27am

select statement does not run in Toad for SAP but in HANA studio

Expand content
Hi@all, this script does not run in Toad for SAP ( HANA ) 3.1.0.315 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...

Hi@all,

this script does not run in Toad for SAP ( HANA ) 3.1.0.315

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'
end
from TOP_PROJECTS X;

I get only "SAP HANA Database Error:"

but no error number.

In SAP HANA studio 2 it works.

Any idea ?

740 1 / Create an account to join the discussion.
Omar Romero
Follow / 18 Jul 2016 at 12:23am / Toad for SAP Solutions
Latest post by on 5 Nov 2016 at 12:49am

Cannot connect to SYBASE IQ 16: "Could not load the encryption...

Expand content
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 16.0.0.429 server by Toad 3.1.0.315 in a windows 7 64bit...

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 16.0.0.429 server by Toad 3.1.0.315 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.

Omar Romero

Unanswered 1712 5 / Create an account to join the discussion.
murp1977
Follow / 12 Sep 2016 at 9:26am / Toad for SAP Solutions
Latest post by on 15 Sep 2016 at 8:11am

Toad for Data Analysts

Expand content
Hi All, Could anyone please share Standard Licensing rules for "TOAD for Data Analysts"? I believe that Dell Software has standardised licensing agreements so are the Licensing Rules for...

Hi All,

Could anyone please share Standard Licensing rules for "TOAD for Data Analysts"?

I believe that Dell Software has standardised licensing agreements so are the Licensing Rules for "TOAD for Data Analysts" basically the same across the board for the following also:

  • Toad for Oracle
  • Toad for SQL Server
  • Toad for Data Analysts
  • Toad Data Modeler
  • Toad for MySQL

Regards

1183 1 / Create an account to join the discussion.
theMadMurph
Follow / 11 Aug 2016 at 10:56am / Toad for SAP Solutions
Latest post by on 3 Sep 2016 at 4:21am

Cannot connect to IQ 16 SP11

Expand content
just upgraded to SAP IQ 16.0 SP11 tried to connect to the upgraded server and got the error below ********************************************************************** Exception Information *****...

just upgraded to SAP IQ 16.0 SP11

tried to connect to the upgraded server and got the error below

**********************************************************************
Exception Information
**********************************************************************
Exception: System.ArgumentOutOfRangeException
Message : 'count' must be non-negative.
Parameter name: count
Stack Trace:
at System.String.CtorCharCount(Char c, Int32 count)
at iAnywhere.Data.SQLAnywhere.SAMetaDataCollectionNames.GetNormalizedVersion(String ver, Int32 len)
at iAnywhere.Data.SQLAnywhere.SAMetaDataCollectionNames.GetNormalizedVersion(String verStr)
at iAnywhere.Data.SQLAnywhere.SAConnection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.SAP.SybaseConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

**********************************************************************
NOTE: We are eliminating automatic support case creation by email. Before sending your Support Bundle, ensure your subject line includes an opened CaseID:### or a Service Request ID:###. Without the CaseID or Service Request ID your Support Bundle request will be declined.

The quickest way to open a new service request is through our online Support Portal support.software.dell.com/Manage-Service-Request.

You can also contact Support for assistance to create a new case, please visit support.software.dell.com/.../contact-technical-support. Post case creation you will continue to have all communication options available including email, phone, or through the Support Portal to manage the lifecycle of your case.


**********************************************************************
Support Bundle: Toad for SAP 3.0.0.129 Freeware
11/08/2016 10:44:58
**********************************************************************

**********************************************************************
System Information
**********************************************************************
Operating System
Microsoft Windows 7 Enterprise 6.1.7601 AMD64
Manufacturer: Microsoft Corporation
Computer Name: GB004691AA
Windows Directory: C:\WINDOWS

Computer System
Computer Manufacturer Name: Dell Inc.
Computer Model: OptiPlex 7010
System Type: x64-based PC
Total Physical Memory: 8,272,432 KB

System Processor

Manufacturer: GenuineIntel
Computer Processor: Intel64 Family 6 Model 58 Stepping 9
CPU Speed: 3.201 GHz
L2 Cache Size: 1 KB

System Bios
BIOS: BIOS Date: 06/10/13 14:14:04 Ver: A14.00
BIOS Version: DELL - 1072009

System Time Zone
Time Zone: (UTC+00:00) Dublin, Edinburgh, Lisbon, London

Video Controller
Name: Intel(R) HD Graphics
Processor: Intel(R) HD Graphics Family
Mode: 1920 x 1080 x 4294967296 colors
Video Ram: 2,162,688 KB
PNP Device ID: PCI\VEN_8086&DEV_0152&SUBSYS_05771028&REV_09\3&11583659&0&10
Status: OK

Environment Variables
PROCESSOR_ARCHITEW6432 = AMD64
COMPUTERNAME = 
UATDATA = C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
SYBROOT = C:\Sybase64
HOMEPATH = \
SYBASE_JRE6_64 = C:\Sybase64\Shared\JRE-6_0_24_64BIT
INCLUDE = C:\Sybase64\OCS-15_0\include;C:\Sybase\OCS-15_0\include
PROCESSOR_REVISION = 3a09
FLEXLM_TIMEOUT = 1000000
SystemDrive = C:
PROCESSOR_LEVEL = 6
PUBLIC = C:\Users\Public
SYBASE_JRE7_64 = C:\Sybase\Shared\JRE-7_0_7_64BIT
LIB = C:\Sybase64\DataAccess64\ADONET\dll;C:\Sybase64\DataAccess\ADONET\dll;C:\Sybase64\OCS-15_0\lib;C:\Sybase\DataAccess\ADONET\dll;C:\Sybase\OCS-15_0\lib
SYBASE_JRE6_32 = C:\Sybase64\Shared\JRE-6_0_24_32BIT
JAVA_HOME = C:\Program Files\Java\jre7
ProgramFiles(x86) = C:\Program Files (x86)
Path = C:\ProgramData\Oracle\Java\javapath;C:\Sybase64\ASE-15_0\jobscheduler\bin;C:\Sybase64\ASE-15_0\dll;C:\Sybase64\ASE-15_0\bin;C:\Sybase64\DBISQL\bin;C:\Sybase64\DataAccess64\ADONET\dll;C:\Sybase64\DataAccess\ADONET\dll;C:\Sybase64\DataAccess64\ODBC\dll;C:\Sybase64\DataAccess\ODBC\dll;C:\Sybase64\SCC-3_2\bin;C:\Sybase64\OCS-15_0\lib3p64;C:\Sybase64\OCS-15_0\lib3p;C:\Sybase64\OCS-15_0\dll;C:\Sybase64\OCS-15_0\bin;C:\Sybase\ASE-15_0\jobscheduler\bin;C:\Sybase\ASE-15_0\dll;C:\Sybase\ASE-15_0\bin;C:\Sybase\SCC-3_2\bin;C:\Sybase\DBISQL\bin;C:\Sybase\DataAccess\ADONET\dll;C:\Sybase\DataAccess\ODBC\dll;C:\Sybase\OCS-15_0\lib3p;C:\Sybase\OCS-15_0\dll;C:\Sybase\OCS-15_0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\TortoiseSVN\bin;C:\Tools\apache-maven-3.1.1\bin;C:\Program Files\OpenVPN\bin
SCC_JAVA_HOME = C:\Sybase64\Shared\JRE-6_0_24_32BIT
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
windows_tracing_flags = 3
PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\;c:\Program Files\Microsoft Security Client\MpProvider\
NUMBER_OF_PROCESSORS = 4
SYBASE_JRE_RTDS = C:\Sybase64\Shared\JRE-6_0_24_64BIT
CommonProgramFiles = C:\Program Files (x86)\Common Files
SYBASE_JRE6 = C:\Sybase64\Shared\JRE-6_0_24_64BIT
ProgramData = C:\ProgramData
ProgramW6432 = C:\Program Files
ProgramFiles = C:\Program Files (x86)
FP_NO_HOST_CHECK = NO
SYBASE_OCS = OCS-15_0
SNOW_INVENTORY_HOME = C:\Program Files\INVENTORYCLIENT
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
TOADSYBASE = C:\Sybase64
SESSIONNAME = Console
SystemRoot = C:\WINDOWS
CommonProgramW6432 = C:\Program Files\Common Files
SYBASE = C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0
SCROOT = C:\Sybase64\Shared\Sybase Central 6.0.0
HOMEDRIVE = Q:
SYBASE_JRE7 = C:\Sybase\Shared\JRE-7_0_7_64BIT
windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
SYBASE_WS = WS-15_0
DSQUERY = TOM_ASE
PROCESSOR_ARCHITECTURE = x86
OS = Windows_NT
ComSpec = C:\WINDOWS\system32\cmd.exe
SYBASE_JRE7_32 = C:\Sybase\Shared\JRE-7_0_7_32BIT
SYBASE_ASE = ASE-15_0
windir = C:\WINDOWS
ALLUSERSPROFILE = C:\ProgramData

**********************************************************************
Connection Information
**********************************************************************
No open connections.

**********************************************************************
Loaded Assemblies
**********************************************************************
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a\Accessibility.dll
ActiproSoftware.Docking.WinForms, Version=14.1.322.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Docking.WinForms\14.1.322.0__c27e062d3c1a4763\ActiproSoftware.Docking.WinForms.dll
ActiproSoftware.Shared.WinForms, Version=14.1.322.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\14.1.322.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll
ActiproSoftware.SyntaxEditor.WinForms, Version=14.1.322.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\14.1.322.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
BouncyCastle.Crypto, Version=1.7.4114.6375, Culture=neutral, PublicKeyToken=0e99375e54769942 C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\BouncyCastle.Crypto.dll
Dell.FastETL, Version=7.2.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Dell.FastETL.dll
Dell.NamedPipeRPC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Dell.NamedPipeRPC.dll
Dell.SecTech, Version=4.3.0.448, Culture=neutral, PublicKeyToken=99d4728064788932 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Dell.SecTech\v4.0_4.3.0.448__99d4728064788932\Dell.SecTech.dll
Dell.ToadCommunication, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Dell.ToadCommunication.dll
Dell.ToadGeneral, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Dell.ToadGeneral.dll
DevExpress.BonusSkins.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.BonusSkins.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.BonusSkins.v14.1.dll
DevExpress.Charts.v14.1.Core, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Charts.v14.1.Core\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.Charts.v14.1.Core.dll
DevExpress.Data.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Data.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.Data.v14.1.dll
DevExpress.Utils.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Utils.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.Utils.v14.1.dll
DevExpress.XtraBars.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraBars.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraBars.v14.1.dll
DevExpress.XtraCharts.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraCharts.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraCharts.v14.1.dll
DevExpress.XtraCharts.v14.1.UI, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraCharts.v14.1.UI\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraCharts.v14.1.UI.dll
DevExpress.XtraCharts.v14.1.Wizard, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraCharts.v14.1.Wizard\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraCharts.v14.1.Wizard.dll
DevExpress.XtraEditors.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraEditors.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraEditors.v14.1.dll
DevExpress.XtraGrid.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraGrid.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraGrid.v14.1.dll
DevExpress.XtraPrinting.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraPrinting.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraPrinting.v14.1.dll
DevExpress.XtraTreeList.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraTreeList.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraTreeList.v14.1.dll
DevExpress.XtraVerticalGrid.v14.1, Version=14.1.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraVerticalGrid.v14.1\v4.0_14.1.9.0__b88d1754d700e49a\DevExpress.XtraVerticalGrid.v14.1.dll
FastData, Version=6.0.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\FastData.dll
iAnywhere.Data.SQLAnywhere.v4.0, Version=16.0.0.14424, Culture=neutral, PublicKeyToken=f222fc4333e0d400 C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Plugins\SAP\iAnywhere.Data.SQLAnywhere.v4.0.dll
Ionic.Zip, Version=1.9.1.5, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Ionic.Zip.dll
ManagedQP5, Version=5.2.5.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\managedqp5.dll
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll
PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_32\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35\PresentationCore.dll
PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.dll
PresentationFramework.Aero, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.Aero\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.Aero.dll
Quest.PersistentCache, Version=3.0.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Quest.PersistentCache.dll
Quest.VersionControl, Version=1.1.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Quest.VersionControl.dll
QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\QuestElevation.exe
Sap.Data.Hana.v4.5, Version=1.0.9.0, Culture=neutral, PublicKeyToken=0326b8ea63db4bc4 C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Plugins\SAP\Sap.Data.Hana.v4.5.dll
Sybase.AdoNet4.AseClient, Version=16.0.0.3, Culture=neutral, PublicKeyToken=95d94fac46c88e1e C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Plugins\SAP\Sybase.AdoNet4.AseClient.dll
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Data.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Data.Linq.dll
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll
System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Management.dll
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll
System.Runtime.Serialization.Formatters.Soap, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll
System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll
System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Web.Extensions\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.Extensions.dll
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll
System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll
System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll
Toad, Version=7.6.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\toad.exe
ToadCore, Version=7.6.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\ToadCore.dll
ToadPlugin, Version=6.0.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\ToadPlugin.dll
ToadSAP, Version=3.0.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Plugins\SAP\ToadSAP.dll
ToadSAPHanaProvider, Version=3.0.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Plugins\SAP\ToadSAPHanaProvider.dll
ToadSAPProvider, Version=3.0.0.129, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\Plugins\SAP\ToadSAPProvider.dll
UIAutomationClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationClient\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationClient.dll
UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationTypes\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationTypes.dll
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\WindowsBase\v4.0_4.0.0.0__31bf3856ad364e35\WindowsBase.dll
WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\WindowsFormsIntegration\v4.0_4.0.0.0__31bf3856ad364e35\WindowsFormsIntegration.dll
QP5, Version=5.280.15138.21804, C:\Program Files (x86)\Dell\Toad for SAP Solutions 3.0\qp5.dll
**********************************************************************
Licensing
**********************************************************************
Freeware

ASE
HANA
IQ
Anywhere

1666 7 / Create an account to join the discussion.
schilders
Follow / 24 Aug 2016 at 8:28pm / Toad for SAP Solutions
Latest post by on 29 Aug 2016 at 7:59am

How to Connect to Sybase SQL Anywhere using Toad and a VPN Connec...

Expand content
Hi, I have Toad for SAP Sybase trial version. It's running inside an Azure virtual machine Windows Server 2012 R2. The Azure virtual machine is attached to a virtual network which also has a site...

Hi,

I have Toad for SAP Sybase trial version.  It's running inside an Azure virtual machine Windows Server 2012 R2.  The Azure virtual machine is attached to a virtual network which also has a site to site connection to a physical server.  The site to site connection works and the virtual machine is connected to the Azure network.  

When I input the internal, non-public, IP address of the SQL Anywhere database I am unable to connect.  Does Toad support some type of VPN tunneling or is there a special configuration that is needed to pass the local network IP address and then the internal database IP address?  I've setup SAP Adaptive Server Enterprise on the virtual machine and intend to store data from the on premises database therein.  However, my efforts to connect via VPN have been unsuccessful.  How is this accomplished using Toad for SAP SQL Anywhere?

Thanks for your help and guidance.

Unanswered 2718 2 / Create an account to join the discussion.
Steven Yetter
Follow / 21 Aug 2016 at 8:16am / Toad for SAP Solutions
Latest post by on 22 Aug 2016 at 8:10am

SQL anywhere connection database server not found without a database...

Expand content
We have several SQL anywhere databases on a local area network addressable by TCP-IP that are frequently re-installed with different database names. For years now, I connect to these databases with Sybase...

We have several SQL anywhere databases on a local area network addressable by TCP-IP that are frequently re-installed with different database names.  For years now, I connect to these databases with Sybase Central connection profiles by TCP-IP, server name unspecified, and database blank.  I say 'unspecified' because the connection string contains "ENG=unspecified" in it. I cannot get Toad to connect with default database or blank database.  I get database server not found.  In Sybase Central, I just leave the database name blank. In Sybase Central, when I get a connection error, I can view the connection string. Is there a way to get the Toad connection to work without a database name?

1486 1 / Create an account to join the discussion.
luiso_26879
Follow / 25 Jul 2016 at 5:53pm / Toad for SAP Solutions
Latest post by on 27 Jul 2016 at 8:11pm

Connecting to local SQL Anyware Version 12

Expand content
I can connect to the server SQL Anywhere but on my local pc - C drive CAN NOT. Try many many option unsuccessful. It is always the server name error. I believe TOAD can not connect directly without ODBC...

I can connect to the server SQL Anywhere but on my local pc - C drive CAN NOT.  Try many many option unsuccessful.  It is always the server name error. I believe TOAD can not connect directly without ODBC.

 

Unanswered 1601 5 / Create an account to join the discussion.
LH1026
Follow / 23 Jun 2016 at 12:56pm / Toad for SAP Solutions
Latest post by on 7 Jul 2016 at 10:19am

Transition from Toad for Sybase 2.1.1 to Toad for SAP Solutions 3...

Expand content
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 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.

1754 3 / Create an account to join the discussion.
Nasrinsf
Follow / 16 Jun 2016 at 8:44am / Toad for SAP Solutions
Latest post by on 16 Jun 2016 at 8:59am

schema compare is not available in Toad for Sybase 2.1.0 version

Expand content
Hi, I'm using sybase ASE database with Toad and trying to do a schema comparison between dev and UAT server. But Under "Tools -> Compare" option, I do not find "Schema Compare"...

Hi,

  I'm using sybase ASE database with Toad and trying to do a schema comparison between dev and UAT server.  But Under "Tools -> Compare" option, I do not find "Schema Compare" option. Can you please help me on how to do schema compare in this case.

Unanswered 1630 1 / Create an account to join the discussion.
geoffrey.farrugia
Follow / 30 May 2016 at 2:50pm / Toad for SAP Solutions
Latest post by on 31 May 2016 at 9:56am

Toad for SAP Solutions 3.1.0.315 [ encryption error: unrecognized...

Expand content
To whom it may concern....... Toad for SAP Solutions 3.1.0.315 connection to SYBASE IQ16, upon connection error [encryption error: unrecognized encryption algorithm identifier] using same connection...

To whom it may concern.......

Toad for SAP Solutions 3.1.0.315 connection to SYBASE IQ16, upon connection error [encryption error: unrecognized encryption algorithm identifier]

using same connection from previous version toad 3.0, and it connected just fine. Tried to create a new connection, but still same error.... connection failed. 

other Client software connect with no problem.

Anyone else encountered this problem?

Unanswered 2047 2 / Create an account to join the discussion.
MrianBiller
Follow / 16 May 2016 at 6:50pm / Toad for SAP Solutions
Latest post by on 17 May 2016 at 9:02pm

Toad for Sybase- The Freeware Period has expired

Expand content
I and a few others have Toad for Sybase Xpert Edition 2.1.1. Over the past month or two each of us has gotten a message saying the "Freeware period has expired. Please visit Quest's website to...

I and a few others have Toad for Sybase Xpert Edition 2.1.1. Over the past month or two each of us has gotten a message saying the "Freeware period has expired. Please visit Quest's website to download the latest version." At this point we need to stay on this version and the only workaround I found was recreating my user profile and installing again. Is there a better solution to reinstall Sybase Expert Edition 2.1.1 and not get this message. Severely impacting performance.

2486 3 / Create an account to join the discussion.