RE: [Toad Data Point - Discussion Forum] Teradata - regular query OK, same in cross-connect throws error

Toad Data Point
1

Debbie,

Here is bundle.

I did logging, but not sure how to extract the logs. I viewed them, and don’t see anything other than a mysql warning about date formats.

To help isolate the issue, I have restricted the number of data sources to just one (1). I only have a single source identified to Toad Data Point 3.7 (a Teradata database). That is, I am testing a query in cross-connection mode, but there is no second database I am cross-connecting to.

When I am in regular Query Builder, I connect fine, see the tables in Object Browser, and run the query ok.

When I am in cross-connect Query Builder, I connect fine, see the tables in Object Browser, and run the query…….not OK.

I get the message "Got error 4206 ‘{0} Invalid data source definition: The UserId, Password or Account is invalid. ; Not enough inform’ from HUB.

(msg displayed below, assuming picture inserts properly)

Also, as you suggested earlier, I have opened a problem ticket to Support.

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 https://support.quest.com/Manage-Service-Request.

You can also contact Support for assistance to create a new case, please visit
support.quest.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 Data Point 3.7.1.1011 Professional Edition - Trial Override license expires 12/15/2015

10/26/2015 9:55:37 AM

System Information

Operating System

Microsoft Windows 7 Professional 6.1.7601 AMD64

Manufacturer: Microsoft Corporation

Computer Name: U0805041

Windows Directory: C:\Windows

Computer System

Computer Manufacturer Name: LENOVO

Computer Model: 5864A1U

System Type: x64-based PC

Total Physical Memory: 8,051,064 KB

Domain: nordstrom.net

User Name: NORD\y6ik

System Processor

Manufacturer: GenuineIntel

Computer Processor: Intel64 Family 6 Model 37 Stepping 5

CPU Speed: 3.193 GHz

L2 Cache Size: 1 KB

System Bios

BIOS: LENOVO BIOS Rev: 1.0

BIOS Version: LENOVO - 13c

System Time Zone

Time Zone: (UTC-08:00) Pacific Time (US & Canada)

Video Controller

Name: Intel® HD Graphics

Processor: Intel® HD Graphics (Core i5)

Mode: 1280 x 1024 x 4294967296 colors

Video Ram: 3,894,460 KB

PNP Device ID: PCI\VEN_8086&DEV_0042&SUBSYS_305917AA&REV_02\3&11583659&0&10

Status: OK

Environment Variables

ProgramData = C:\ProgramData

COMPUTERNAME = U0805041

UATDATA = C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77

CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files

USERDNSDOMAIN = NORDSTROM.NET

DEFLOGDIR = C:\ProgramData\McAfee\DesktopProtection

APPSRV = f0864p1

ProgramFiles(x86) = C:\Program Files (x86)

PROCESSOR_REVISION = 2505

PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

TMP = C:\Users\y6ik\AppData\Local\Temp

TEMP = C:\Users\y6ik\AppData\Local\Temp

LOCALAPPDATA = C:\Users\y6ik\AppData\Local

PUBLIC = C:\Users\Public

VSEDEFLOGDIR = C:\ProgramData\McAfee\DesktopProtection

DataConnectorLibPath = C:\Program Files\Teradata\Client\14.10\bin;C:\Program Files (x86)\Teradata\Client\14.10\bin\

HOMESITE = ST0864

USERDOMAIN = NORD

Path = C:\Program Files (x86)\Teradata\Client\14.10\ODBC Driver for Teradata\Lib;C:\Oracle\product\11.2.0\client_1\bin;C:\app\y6ik\product\11.2.0\client_2;C:\app\y6ik\product\11.2.0\client_2\bin;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Teradata\Client\14.10\bin;C:\Program Files (x86)\Teradata\Client\14.10\CLIv2;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Git\cmd;C:\Program Files (x86)\Git\bin;C:\Program Files\1E\NomadBranch;C:\ORACLE_INSTANT_CLIENT_11\INSTANTCLIENT_11_2;C:\Program Files (x86)\WebEx\Productivity Tools

PROCESSOR_LEVEL = 6

PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 37 Stepping 5, GenuineIntel

ADSITE = ST0864

TNS_ADMIN = c:\oracle\product\11.2.0\client_1\network\admin

USERDOMAIN_ROAMINGPROFILE = NORD

COPLIB = C:\Program Files\Teradata\Client\14.10\CLIv2;C:\Program Files (x86)\Teradata\Client\14.10\CLIv2\

PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\

PROCESSOR_ARCHITEW6432 = AMD64

CommonProgramFiles = C:\Program Files (x86)\Common Files

HOMEPATH = \

windows_tracing_flags = 3

HOMESHARE = \svm0864home.nordstrom.net\y6ik

ProgramW6432 = C:\Program Files

ProgramFiles = C:\Program Files (x86)

FP_NO_HOST_CHECK = NO

NUMBER_OF_PROCESSORS = 4

SystemRoot = C:\Windows

TOADSYBASE = C:\Program Files (x86)\Quest Software\Toad Data Point 3.3\

SESSIONNAME = Console

CommonProgramW6432 = C:\Program Files\Common Files

SYBASE = C:\Program Files (x86)\Dell\Toad Data Point 3.7

LOGONSERVER = \A0864DC1

USERPROFILE = C:\Users\y6ik

APPDATA = C:\Users\y6ik\AppData\Roaming

HOMEDRIVE = P:

windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log

USERNAME = y6ik

PROCESSOR_ARCHITECTURE = x86

OS = Windows_NT

ComSpec = C:\Windows\system32\cmd.exe

SystemDrive = C:

windir = C:\Windows

ALLUSERSPROFILE = C:\ProgramData

Connection Information

Current Connection:

Y6IK@TD0319PCA

Teradata database

Server version 14.10.2.2

Connected since 10/26/2015 9:53:51 AM

0 of 1 connection in pool active

Connection:

root@localhost

Local Storage database

Server version 2.5.0.93

Connected since 10/26/2015 9:12:29 AM

0 of 4 connections in pool active

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 Data Point 3.7\BouncyCastle.Crypto.dll

Dell.FastETL, Version=7.2.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Dell.FastETL.dll

Dell.NamedPipeRPC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\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 Data Point 3.7\Dell.ToadCommunication.dll

Dell.ToadGeneral, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Dell.ToadGeneral.dll

Devart.Data, Version=5.0.1085.0, Culture=neutral, PublicKeyToken=09af7300eec23701 C:\Windows\assembly\GAC_MSIL\Devart.Data\5.0.1085.0__09af7300eec23701\Devart.Data.dll

Devart.Data.MySql, Version=8.3.293.0, Culture=neutral, PublicKeyToken=09af7300eec23701 C:\Windows\assembly\GAC_MSIL\Devart.Data.MySql\8.3.293.0__09af7300eec23701\Devart.Data.MySql.dll

Devart.Data.Oracle, Version=8.4.293.0, Culture=neutral, PublicKeyToken=09af7300eec23701 C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle\8.4.293.0__09af7300eec23701\Devart.Data.Oracle.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.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.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

dociugcn, Version=4.3.0.448, Culture=neutral, PublicKeyToken=null

FastData, Version=6.0.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\FastData.dll

Ionic.Zip, Version=1.9.1.5, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c C:\Program Files (x86)\Dell\Toad Data Point 3.7\Ionic.Zip.dll

ManagedQP5, Version=5.2.5.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\managedqp5.dll

mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll

MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\MySQL\MySql.Data.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.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Quest.PersistentCache.dll

Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Dell\Toad Data Point 3.7\Quest.Toad.Interop.AxSHDocVw.dll

Quest.VersionControl, Version=1.1.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Quest.VersionControl.dll

QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\QuestElevation.exe

r12dps2d, Version=7.5.0.1011, Culture=neutral, PublicKeyToken=null

SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Dell\Toad Data Point 3.7\SHDocVw.dll

Sybase.AdoNet4.AseClient, Version=16.0.0.3, Culture=neutral, PublicKeyToken=95d94fac46c88e1e C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\SAP\Sybase.AdoNet4.AseClient.dll

Syncfusion.XlsIO.Base, Version=12.2400.0.36, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89 C:\Program Files (x86)\Dell\Toad Data Point 3.7\Syncfusion.XlsIO.Base.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.DirectoryServices.AccountManagement, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.DirectoryServices.AccountManagement\v4.0_4.0.0.0__b77a5c561934e089\System.DirectoryServices.AccountManagement.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.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll

System.ServiceProcess, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.ServiceProcess\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.ServiceProcess.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.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

Teradata.Client.Provider, Version=14.11.0.1, Culture=neutral, PublicKeyToken=76b417ee2e04956c C:\Windows\assembly\GAC_MSIL\Teradata.Client.Provider\14.11.0.1__76b417ee2e04956c\Teradata.Client.Provider.dll

Teradata.Net.Security.Tdgss, Version=14.11.0.1, Culture=neutral, PublicKeyToken=76b417ee2e04956c C:\Windows\assembly\GAC_MSIL\Teradata.Net.Security.Tdgss\14.11.0.1__76b417ee2e04956c\Teradata.Net.Security.Tdgss.dll

Toad, Version=7.5.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\toad.exe

ToadBlue2014, Version=14.1.8.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad Data Point 3.7\ToadBlue2014.dll

ToadConnectionProxy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\ToadConnectionProxy.dll

ToadCore, Version=7.5.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\ToadCore.dll

ToadDB2Provider, Version=6.1.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\DB2\ToadDB2Provider.dll

ToadLocalDB, Version=1.1.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\LocalDB\ToadLocalDB.dll

ToadLocalDBProvider, Version=1.1.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\LocalDB\ToadLocalDBProvider.dll

ToadMySQL, Version=7.5.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\MySQL\ToadMySQL.dll

ToadMySQLProvider, Version=7.5.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\MySQL\ToadMySQLProvider.dll

ToadOdbc, Version=3.7.1.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\Odbc\ToadOdbc.dll

ToadOdbcProvider, Version=3.7.1.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\Odbc\ToadOdbcProvider.dll

ToadOracle, Version=6.0.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\Oracle\ToadOracle.dll

ToadOracleProvider, Version=6.0.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\Oracle\ToadOracleProvider.dll

ToadOracleProxy, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\ToadOracleProxy.dll

ToadPlugin, Version=6.0.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\ToadPlugin.dll

ToadSAPProvider, Version=3.0.0.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\SAP\ToadSAPProvider.dll

ToadSqlServerProvider, Version=6.6.1.1011, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\SqlServer\ToadSqlServerProvider.dll

ToadTeradata, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\Teradata\ToadTeradata.dll

ToadTeradataProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad Data Point 3.7\Plugins\Teradata\ToadTeradataProvider.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

UIAutomationProvider, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\UIAutomationProvider\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationProvider.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.276.15058.36019, C:\Program Files (x86)\Dell\Toad Data Point 3.7\qp5.dll

Licensing

Advanced Analytics add-on

2

What is the support case number?

3

SR Number:3002468

Yesterday had WebEx. No resolution yet.

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Monday, October 26, 2015 7:52 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] RE: [Toad Data Point - Discussion Forum] Teradata - regular query OK, same in cross-connect throws error

RE: RE: [Toad Data Point - Discussion Forum] Teradata - regular query OK, same in cross-connect throws error

Reply by Debbie Peabody

What is the support case number?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

4

I am pretty sure the issue is with the ldap. Are you able to make an ODBC connection with Teradata. A work around would be to use an ODBC connection when using cross-query. Underneath the hood we are trying to make an ODBC connection to Terdata but we must no be able to get the string correct. I believe I saw a post yesterday of another user saying this is how they solved this issue.

Tell your support rep to make a sucbase and i will enter a ticket so we can look into this in the next release.

5

Debbie,

  1. I checked with our Teradata group, and they are asking if Toad Data Point provides the ability for encryption for the TD2 access.

  2. I tried the generic ODBC connection, and it connects, but the Query Builder doesn’t work.

  3. The sucbase you mention (and associated ticket); that is for allowing LDAP connections in a future release?

Thanks,

Lance

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Tuesday, October 27, 2015 6:53 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] RE: [Toad Data Point - Discussion Forum] Teradata - regular query OK, same in cross-connect throws error

RE: RE: [Toad Data Point - Discussion Forum] Teradata - regular query OK, same in cross-connect throws error

Reply by Debbie Peabody

I am pretty sure the issue is with the ldap. Are you able to make an ODBC connection with Teradata. A work around would be to use an ODBC connection when using cross-query. Underneath the hood we are trying to make an ODBC connection to Terdata but we must no be able to get the string correct. I believe I saw a post yesterday of another user saying this is how they solved this issue.

Tell your support rep to make a sucbase and i will enter a ticket so we can look into this in the next release.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

6

There is a “Use database encryption” option on the advanced tab of the connection.

I need more details on item 2. Can you give more detail to your support rep? Screenshots of the DSN and what you see in the object explorer? I might like to have myself and another attend another WebEx.

Yes, QAt-6740 has been entered to support LDAP connections for Cross-Query in a future release.

I still would like to see if we can get the ODBC connection to work for you in the mean time.

7

Debbie,

I was able to have our Teradata group set up a TD2 connection exclusive to me (company standard is LDAP, so thank you for QAt-6740).

There was an additional issue with my 32-bit Oracle client that your support helped me with. Now with TD2 and a clean Oracle 32-bit client, I connect successfully!

Thanks for the assistance!

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Friday, October 30, 2015 8:11 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] RE: [Toad Data Point - Discussion Forum] Teradata - regular query OK, same in cross-connect throws error

RE: RE: [Toad Data Point - Discussion Forum] Teradata - regular query OK, same in cross-connect throws error

Reply by Debbie Peabody

There is a “Use database encryption” option on the advanced tab of the connection.

I need more details on item 2. Can you give more detail to your support rep? Screenshots of the DSN and what you see in the object explorer? I might like to have myself and another attend another WebEx.

Yes, QAt-6740 has been entered to support LDAP connections for Cross-Query in a future release.

I still would like to see if we can get the ODBC connection to work for you in the mean time.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

8

[:)]Yay