#DateForumTypeThreadPost
32103 Aug 2015 @ 03:33 PDTConnectivityReplyCalling Macro from .Net ProviderThere is only one way:   1- Set the TdCommand.Text = "Exec MacroName(?)" and Set the TdCommand.CommandType = CommandType.Text; 2- Add a TdParameter to the TdCommand.Parameter...
32028 Jul 2015 @ 01:36 PDTConnectivityReplyteradata driver upgraded from 12 to 14; excel vba connection string wont work nowADO uses an OLE DB Provider; in this case "Microsoft OLE DB Providr for ODBC" + "ODBC Driver for Teradata". Follow the steps in section 3 of http://developer.teradata.com/blog...
31925 Jun 2015 @ 09:50 PDTToolsReplyBTEQ and the Commit statementIt sounds like a bug in the Teradata Database. However as a workaround, you can use the SQLA Transaction statements: .BeginTx , .CommitTx and .RollbackTx . In this case it will be something like ...
31802 Jun 2015 @ 02:55 PDTConnectivityReply.NET Data Provider Teradata - Session Issue - Volatile TableDid you turn off Connection Pooling? It is enabled by default ("Connection Pooling=False;Data Source=X; ... ").
31729 May 2015 @ 02:09 PDTConnectivityReplyUnable to connect to TERADATA from SSIS ADO.Net source The default login timeout is 20 seconds. The .NET Data Provider for Teradata was not able to login within 20 seconds. You can increase the Connection Timeout: https://developer.teradata.com/doc/co...
31608 May 2015 @ 10:35 PDTConnectivityReplyWhich Teradata drivers support data encryption?https://developer.teradata.com/doc/connectivity/tdnetdp/15.10/webhelp/Teradata.Client.Provider~Teradata.Client.Provider.TdConnectionStringBuilder~DataEncryption.html   Set the TdConnectionSt...
31502 Mar 2015 @ 12:54 PSTConnectivityReplySlow Record Loading into Teradata - with or without PKThis is a Teradata Database error/limit. The application starts a transaction and then attempts to load 1,000,000 rows; each row inserated results in a rowhash lock (the table has a primary-key; i....
31425 Feb 2015 @ 11:40 PSTConnectivityReplySlow Record Loading into Teradata - with or without PKTwo suggestions: 1- Set TdDataAdapter.UpdateBatchSize property to a number greater than 1. It defaults to 1; therefore the DataAdapter is sending on row at a time to the Teradata Database.&nb...
31319 Feb 2015 @ 04:07 PSTDatabaseReplyInsert Bulk data (millions) into Teradata using VS20013, c#You have few choices to improve the performance: 1- Do not hard code values into the Command-Text; Instead pass the parameters using TdCommand.Parameters collection. There are lots of example on M...
31219 Feb 2015 @ 04:01 PSTDatabaseReplyRetrieve millions of records from Teradata into Asp.net applicationThe TdCommand.CommandTimeout property defaults to 30 seconds. You need to set  it to a larger value or Zero to diable the Command-Timeout.
31110 Feb 2015 @ 01:26 PSTConnectivityReplyConnection string of Teradata for Asp.netRefer to the .NET Data Provider for Teradata documentation:  https://developer.teradata.com/doc/connectivity/tdnetdp/14.11/webhelp/Teradata.Client.Provider~Teradata.Client.Provider.TdConnecti...
31002 Feb 2015 @ 02:22 PSTConnectivityReplyHow to connect Teradata in ASP.NET MVC using EFhttps://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/SystemRequirementsandSupportedTeradataVersions.html   You must use VS 2010 if you need to use the .NET Data Provide...
30930 Jan 2015 @ 04:44 PSTConnectivityReplyHow to connect Teradata in ASP.NET MVC using EFYou wrote "VS 203". Do you mean VS 2013 or VS 2003? .NET Data Provider version 13.11.0.1 does not support VS 2003 or VS 2013. Refer to https://developer.teradata.com/doc/connec...
30804 Dec 2014 @ 11:37 PSTConnectivityReplyIs it possible to connect to Teradata from Excel without installing Teradata drivers?It depends on the definition of "without installing Teradata Drivers." You can build an office application or an office add-in with the .NET Data Provider for Teradata. You can add the ....
30704 Nov 2014 @ 01:47 PSTConnectivityReply .NET Executing macro and statement cacheI highly recommend that you set the following TdParameter properties   TdType   Size   Precision   Scale They must match the DDL; for example 1- if Parameter #1 is declare...
30627 Oct 2014 @ 10:25 PDTConnectivityReplyConnections Created (w/ ODBC/.NET) Are Surviving After conn.Close()I recommend that you  switch to the .NET Data Provider for Teradata: http://downloads.teradata.com/download/connectivity/net-data-provider-for-Teradata It is very difficult to debug Microsoft...
30527 Oct 2014 @ 10:08 PDTConnectivityReplyTeradata Connectivity Using Windows PowerShellYou need to modify the Connection String. Refer to this page for a list of valid Connection String attributes: http://developer.teradata.com/doc/connectivity/tdnetdp/15.00/webhelp/webframe.html#Dev...
30421 Oct 2014 @ 06:02 PDTConnectivityReplyHow to execute a stored procedure from vba excelThe Teradata Database does not support Return - Values. It supports IN, OUT and INOUT parameters. Therefore delete the Return-Value parameter: cmdSQLData.Parameters.Append cmdSQLData.CreateParam...
30317 Sep 2014 @ 05:39 PDTConnectivityReplyHaving problem to connect Teradata server instance to ASP .NET MVC 4 Application in a code first approachThe Entity Provider for Teradata supports Entity Framework 3.5. I suggest you try "Database First".
30212 Sep 2014 @ 10:25 PDTConnectivityReplyMS Visio 2010It is a long shot; but are you sure you installed the 64-bit version of the ODBC driver. For example I have 32-bit (ODBC Driver for Teradata 15.00.0.3) and 64-bit version (ODBC Driver for Teradata ...
30121 Aug 2014 @ 05:08 PDTConnectivityReplyQuestion about parameter markers and .netRefer to http://msdn.microsoft.com/en-us/library/system.data.common.dbparameter.sourcecolumn(v=vs.110).aspx the SourceColumn maps a parameter-value to a DataTable column. One or more parameters ca...
30020 Aug 2014 @ 01:14 PDTConnectivityReplyodbc driver trace on windows.The "Windows ODBC Driver Manager" trace feature will capture the Application-to-ODBC-Driver Function calls and the SQL. Refer to MSDN articles; for example http://support.microsoft....
29931 Jul 2014 @ 10:58 PDTConnectivityReplyTeradata ODBC driver installation in LinuxTeraGSS and TDICU are in the tar file.
29828 Jul 2014 @ 10:06 PDTConnectivityReplySending dataset(multiple rows and multiple columns ) from .net to teradata Yes, it is possible. Start with: http://msdn.microsoft.com/en-us/library/aadf8fk2(v=vs.110).aspx   http://developer.teradata.com/doc/connectivity/tdnetdp/15.00/webhelp/webframe.html#Adapte...
29724 Jul 2014 @ 12:57 PDTConnectivityReplyCannot convert from Db.DateTimeOffset to Td.TimeStampWithZoneYou wrote the parameter value was generated using DateTime.Now    change it to DateTimeOffset.Now.  

Pages