#DateForumTypeThreadPost
29624 Jul 2014 @ 12:48 PDTConnectivityReplyError inserting null value into nullable field using TdCommandCheck TdCommand.Parameters[2].IsNullable property. I think isNullable is set to false but the application is sending a DbNull to the Teradata Database; resulting in a mismatch between the para...
29521 Jul 2014 @ 10:29 PDTConnectivityReplyNo transaction rollback when using TransactionScope without Complete()Refer to the Teradata Database Messages manual. It states:  3932 Only an ET or null statement is legal after a DDL Statement. Explanation: A DDL statement was issued previously. By ...
29416 Jul 2014 @ 05:26 PDTConnectivityReplyNo transaction rollback when using TransactionScope without Complete()The Teradata Database does not support 2PC or Distributed Transactions. The Data Provider supports local transaction (TdConnection.BeginTransaction, TdTransaction ...). TdTransaction class support...
29314 Jul 2014 @ 07:41 PDTConnectivityReplyProblem with Reconnect using .NET and ODBC drivers.NET Data Provider version 14.11.0.1 does not support Reconnect.  
29202 Jul 2014 @ 12:40 PDTConnectivityReplyteradata lobs are not allowed to be selected in record or indicator modes + SSIS errorSet EnableLobSupport to Yes in the connection string.
29102 Jul 2014 @ 12:34 PDTDatabaseReplyVARCHAR or CHAR columns not appearing in answersheetPost additional information; for example the Teradata Database version, the name of the Tool and the version, the name of the driver and version. For example Teradata Database 14.10.0.1, ...
29007 Jun 2014 @ 06:29 PDTConnectivityReply.Net Provider - Column Character SetDBC.Columns[x] view are obsolete; the replacment system views are DBC.ColumnsV[x]. However you should use HELP COLUMN because DBS.ColumnsV[X] does not return CharType (or any other d...
28904 Jun 2014 @ 06:28 PDTConnectivityReply.Net Provider - Column Character SetA workaround that does not require parsing. The TdDataReader.GetSchemaTable() returns "BaseSchemaName", "BaseTableName" and "BaseColumnName"; you can compose a&nb...
28814 May 2014 @ 04:06 PDTConnectivityReplyWindows .Net (non-ODBC) connection to Teradata using LDAP authenticationIf you need to create a Client Configuration file for LDAP, then you must create the configurtion for the ODBC Driver for Teradata and/or the .NET Data Provider for Teradata; two separate...
28714 May 2014 @ 03:51 PDTConnectivityReply.net Provider did not install into GACDid you look for it in C:\Windows\Assembly directory? or C:\Windows\Microsoft.NET\assembly directory? The Data Provider targets .NET Framework 3.5 SP1; therefore it is in C:\Windows\Assembly\GAC_MS...
28609 May 2014 @ 05:09 PDTConnectivityReplyWhere is the download link for Teradata ODBC Driver 14.10? The ODBC driver is included in "TTU - Windows Install" http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package
28524 Apr 2014 @ 10:50 PDTConnectivityReply.NET data provider - cant see in visual studioThe .NET Data Provider for Teradata version 14.11.0.1 integrates with VS 2010, 2012 and 2013. Did you download and install the 14.11.0.1 version? note that the .NET Data Provider version 14.11 does...
28423 Apr 2014 @ 02:33 PDTConnectivityReplyHow do you connect to a DB View with OData in Visual Studio?Sorry, there is no other workaround for Views (vs. Tables). However you can create an entity based on a "Defining Query": http://msdn.microsoft.com/en-us/data/jj730307.aspx . Th...
28321 Apr 2014 @ 09:59 PDTConnectivityReply.NET data provider - cant see in visual studio.NET Data Provider for Teradata version 14.11.0.1 integrates with Visual Studio 2013 pro. Note that the earlier version (e.g. 14.11.0.0) does not integrate with Visual Studio 2012 or Visual Studio ...
28211 Apr 2014 @ 05:31 PDTConnectivityReplyConnecting to Teradata Express for VMware through local networkThe Data Provider cannot establish a socket connection to port 1025 on 198.168.1.9. Is the gateway up and running?
28111 Apr 2014 @ 05:17 PDTConnectivityReply.net 14.11.00.01 not showing tables/view list in SSISDid you install the .NET Data Provider for Teradata after installing the SQL Server 2012 Data Tools (SSDT)?  SSDT is just Visual Studio 2010 Shell. The .NET Data Provider for Teradata in...
28014 Mar 2014 @ 02:39 PDTConnectivityReplySSIS 2012 OLE DB Teradata provider 'TDOLEDB.1'Refer to http://developer.teradata.com/blog/netfx/2011/12/setup-sql-server-2008-r2-linked-server-to-the-teradata-database It will show you how to use a UD file (e.g. FOO.UDL) to test OLE DB ...
27903 Feb 2014 @ 09:36 PSTConnectivityReply.NET Provider on Mono?It is not fixed. The .NET Data Provider for Teradata does not support MONO at this point. Please describe your need/requirement. At this point MONO support is not on the roadmap.
27830 Jan 2014 @ 12:19 PSTDatabaseReplyError: [.NET Data Provider][101151] Too Many Restrictions SuppliedBTW, I recommend that you post .NET Data Provider related questions to the Connectivity forum.
27730 Jan 2014 @ 10:47 PSTDatabaseReplyError: [.NET Data Provider][101151] Too Many Restrictions SuppliedYou are trying to execute one of the Schema Collections. Please provide additional information; i.e. the name of the schema collection, and the list of Schema Collection Restrictions. I think ...
27625 Jan 2014 @ 02:46 PSTDatabaseReplyConnect VBA to Teradata If you must use VBA, then search for "VBA ADO ODBC and MSDASQL". You will find lots of examples. MS supports VBA but it also provides newer MS Office solutions like Visual Studio&nb...
27522 Jan 2014 @ 06:44 PSTConnectivityReply.Net connection using explicit IP AddressYou must upgrade to the .NET Data Provider version 13.11 or higher. Refer to: http://developer.teradata.com/doc/connectivity/tdnetdp/14.11/webhelp/webframe.html#WhatsNew13110000.html  
27410 Dec 2013 @ 03:33 PSTConnectivityReplyWhich IP will SQL Assistant hit.refer to http://developer.teradata.com/connectivity/articles/laddered-concurrent-connect-lcc-client-performance-improvements It will randomly select one of the nodes; then round robin.
27310 Dec 2013 @ 03:26 PSTConnectivityReplyThe NTLM authentication token is not supportedAre you using the Integrated Security (a.k.a Single-Sign-On) on ASP.NET? You should open an incident if the answer is yes. The Integrated Security uses SPNEGO; the .NET Framework SPNEGO provider w...
27210 Dec 2013 @ 03:16 PSTConnectivityReply.NET Provider on Mono?The .NET Data Provider for Teradata product does not support Mono.  We have never had a request for it. I hope anyone internested in Mono will add their name to this post and describe wh...

Pages