#DateForumTypeThreadPost
34629 Aug 2016 @ 10:44 PDTConnectivityReplyCan you get Teradata.Client.Provider for c#/dot.net just from disk?1- You can install two or more version of the .NET Data Provider for Teradata on you workstation. This concept is called Side-By-Side and the .NET Data Provider for Teradata has supported this feat...
34517 Aug 2016 @ 09:27 PDTConnectivityReplyTeradata Client 15.0 to 15.11 for c# dot.net buildsRight click on the Reference and select Properties; Is the "Specific Version" set to False?  http://stackoverflow.com/questions/24022134/how-exactly-does-the-specific-version-proper...
34405 Aug 2016 @ 09:58 PDTConnectivityReplyConnecting to Teradata through PYODBC on MacLoad the iODBC Data Source Administrator tool; select the Drivers tab and check for the Teradata Driver.  Most likely the Teradata ODBC Driver is not registered with the iODBC Driver Manager. ...
34321 Jun 2016 @ 10:35 PDTConnectivityReplypython / odbc connection to TDWindows or Linux? This might help: http://developer.teradata.com/blog/odbcteam/2016/02/python-with-teradata-odbc  
34221 Jun 2016 @ 10:28 PDTConnectivityReplyCommand line installation for ODBC Driver for Windows 15.00.00.00http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TTU15.10.04&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Tools+and+Utili...
34116 May 2016 @ 10:46 PDTConnectivityReplyCan not connect to TD from SQLA over home network, but can connect using BTEQ!There is an outstanding issue with the private copies of the Visual Studio 2012 libraries in the MS Office 2016. The VS 2012 libraries are out of date and they prevent one of the ODBC DLLs to load.
34021 Mar 2016 @ 12:37 PDTConnectivityReplyExcel 2013 (32 bit) - Teradata ODBC Connectivity issueYou need to create a new Data Source with the 64-bit ODBC Data Source Administrator.  
33918 Feb 2016 @ 06:55 PSTConnectivityReplyODBC ts time stamp for now() select * from TabFoo where X = {fn TIMESTAMPADD( SQL_TSI_DAY, -80, {fn CURRENT_TIMESTAMP})} Note that the CURRENT_TIMESTAMP must be wrapped with FN escape sequence also. The ODBC driver will con...
33818 Feb 2016 @ 06:32 PSTConnectivityReplyAll Connections to Teradata fail with Receive Operation Timed OutPost the stack trace. Can you connect with BTEQ or ODBC (from SQLA)?
33725 Jan 2016 @ 12:27 PSTConnectivityReplyIs it possible to connect to Teradata from Excel without installing Teradata drivers?Are you writing an Excel Add-in with C# or VB.NET? if yes, then you can use the .NET Data Provider for Teradata for connectivity to the Teradata Database; and privately deploy the two Assemblies (T...
33621 Jan 2016 @ 11:03 PSTConnectivityReplyConnect Teradata SQLA using LDAPYou do not need to install OpenLDAP on the clinet machine. You must configure the Teradata Database to authenticate with external authentication. Set the Mechanism to LDAP and specify the User-ID (...
33511 Jan 2016 @ 07:04 PSTToolsReplySQL Assistant 15.00 Cursor lagging problems Did you install the latest version 15.0.0.9? I release notes show a few performance improvements but I am not sure if they are applicable to this case.
33408 Jan 2016 @ 02:23 PSTConnectivityReply.NET provider vs. ODBCYou should contact your DBA to find out if your organization has a service agreement and how to open an incident. 
33308 Jan 2016 @ 02:19 PSTConnectivityReply.NET provider (ver 15.xx), TdCommandBuilder, bulk load, errorNo we did not change the semantics of the Command Timeout. The .NET Data Provider 15.0 was enhanced to support new batch-update scenarios. It might be sending a larger Batch-Update to Teradata Dat...
33207 Jan 2016 @ 06:52 PSTConnectivityReply.NET provider (ver 15.xx), TdCommandBuilder, bulk load, errorThe default Command-Timeout is 30 seconds. How long does it take to execute the command(s) with 14.11.0.1?  The System.Data.Common.DbCommandBuilder class transfers the CommandTimeout from the...
33107 Jan 2016 @ 06:23 PSTConnectivityReply.NET provider vs. ODBCIn our tests the "Microsoft Data Provider for ODBC" is slower than the .NET Data Provider for Teradata. It would be very difficult to analyze your issue remotely. I suggest you open and i...
33004 Jan 2016 @ 04:33 PSTToolsReplyTPT via .NET (C#)This is very old but it might be still applicable: https://tptapiwrapper.codeplex.com/  
32929 Dec 2015 @ 10:26 PSTConnectivityReplyCommandTimeout - Query doesn't abort if in responding stateYou must execute the Query with TdCommand.ExecuteReader() method and must use the TdDataReader to process the Result-set (read one row at a time). TdDataReader.RecordsReturned or TdDataReader.Reco...
32829 Dec 2015 @ 10:22 PSTConnectivityReplyCommandTimeout - Query doesn't abort if in responding stateYou are using ExecuteNonQuery. This method must process the entire result set. You need to use ExecuteReader instead and immediately dispose the DataReader:   using (TdCommand cmd = tdCon....
32722 Dec 2015 @ 02:56 PSTConnectivityReplyCommandTimeout - Query doesn't abort if in responding stateYour application must process the result (DataReader) and it must close/dispose the DataReader to release the spool. I think the Select statement completed and DBS started to send back data to the ...
32611 Dec 2015 @ 06:22 PSTConnectivityReplyCannot find terasso library with MSAccess2013This sounds very similar to the Office 365 issue. Office 365 ships with an older version of Visual Studio C++ Runtime libraries which might explain why BIQuery works but MS Access 2013 does not. I ...
32504 Dec 2015 @ 10:54 PSTConnectivityReply.Net Provider DateTime-Timestamp Data Typehttp://developer.teradata.com/doc/connectivity/tdnetdp/15.11/help/webframe.html#TimestampDetails.html It will show you how to set the Scale (TdParameter.Scale) for Timestamp(6).    
32404 Nov 2015 @ 03:44 PSTConnectivityReplyTeradata odbc connection and tmp space"Create User" DDL statement sets the Permanent, Spool and Temporary space limits. 
32329 Oct 2015 @ 01:57 PDTConnectivityReplyProblems using SET QUERY_BAND from ODBC it works fine in Teradata SQL Assistant, but chokes in ODBC with the message "Only an ET or null statement is legal after a DDL Statement". Are you attempting to execute a Multi-Sta...
32230 Sep 2015 @ 01:33 PDTConnectivityReplyConnecting to TD15 from Visual BasicI recommend that youread section #3 of  http://developer.teradata.com/blog/netfx/2011/12/setup-sql-server-2008-r2-linked-server-to-the-teradata-database Use a UDL file to get the Connection ...

Pages