#DateForumTypeThreadPost
14611 Sep 2009 @ 10:45 PDTConnectivityReplyHelp or documentation for .net V12 or V13?.NET Data Provider for Teradata 12.x/13.x ships with two versions of the Help File. One is standalone (.CHM) help file and the other integrates into Visual Studio 2005/2008 Help. Please clarif...
14510 Sep 2009 @ 02:03 PDTConnectivityReplyTrusted Connection in .Net data provider Drivera) The Teradata database version you use with .NET Data Provider for Teradata 12.0 and higher must support Kerberos Authentication and furthermore SPNEGO must be enabled. SPNEGO is not enabl...
14406 Jul 2009 @ 01:38 PDTDatabaseReplyInsufficient memory when I perform a commandThe DataAdapter.InsertCommand.CommandText must be a single-row parameterized query: Insert Into Table1(Field1) Values (?)The DataTable, which serves as input parameter rows, must hold X rows. In ...
14302 Jul 2009 @ 02:00 PDTDatabaseReplyInsufficient memory when I perform a command.NET Data Provider for Teradata supports batch updates.See documentation for DbDataAdapter.UpdateBatchSize in MSDN: http://msdn.microsoft.com/en-us/library/aadf8fk2.aspx http://msdn.microsoft.com...
14224 Jun 2009 @ 08:19 PDTDatabaseReplyConnecting Teradata Database from VB using Microsoft Visual studio 2008I assume you mean VB.NET; you can download ".NET Data Provider for Teradata" from the download center and use it to connect to Teradata Database. Here is the link to download center: http://www.ter...
14112 Jun 2009 @ 02:17 PDTThird Party SoftwareReplyMS SSIS - OLEDB commandYes there is a better way; in this blog [url=http://developer.teradata.com/blog/netfx/2009/06/little-known-secret-about-microsoft-bi-tools-and-teradata][/url]there is a link to "Microsoft Connecto...
14027 May 2009 @ 01:25 PDTConnectivityReplyConnect Teradata to MS Accesstry this: Provider=MSDASQL;Driver={Teradata};DBCName=TDPID;UID=x;PWD=y;Also you can create an ODBC Data Source; the Data Source will hold configuration information and therefore simplifies the con...
13909 Apr 2009 @ 02:08 PDTConnectivityReplyTeradata.Client.Provider.tdException: [Teradata Database] [3939]I do not follow your specific case because I do not see how you can pass "parent" variable at design time to the DataAdapter wizard. "select hierarchy_Name from functionalHierarchy where parent_...
13818 Mar 2009 @ 02:05 PDTConnectivityReply.NET Provider performanceTable DDL that I used:Create table Processed_jobs( MLOAD_NAME CHAR(30), JOB_DATE DATE, JOB_TIME TIME(6), DATABASE_NAME CHAR(30), TABLE_NAME CHAR(30), ROWS_INSERTED DECIMAL(38, 0), DUPLICATE_...
13717 Mar 2009 @ 04:20 PDTConnectivityReply.NET Provider performanceI tried the following sample with .NET Data Provider 13.0; it works. Note that Teradata support Parameter Markers not parameter names. public static void Main(String[] args) { ...
13606 Mar 2009 @ 01:02 PSTConnectivityReply.Net Teradata DriversODBC Driver, .NET Data Provider, OLE DB Provider and CLI use SQL-Connection to Teradata Database. In other word, they all establish a socket connection and use the same wire-protocol.
13524 Feb 2009 @ 07:07 PSTToolsReply.Net TeraData.Client.Provider 13.0.0.0 TdTimeTry this select cast(CAST(TIME as char(10)) as time(0))It will force database to return a TIME data type.
13424 Feb 2009 @ 03:53 PSTToolsReply.Net TeraData.Client.Provider 13.0.0.0 TdTimeI suggest using NQUERY to look at the SchemaTable (TdDataReader.GetSchemaTable) for the query in question.NQuery is in InstallDirectory\Samples\Bin directory; Right-Click in "Results" window and se...
13302 Feb 2009 @ 05:54 PSTConnectivityReply.NET and using ParametersYes, add TdParameter objects in order, corresponding to the Question marks in SQL Text, to the TdParameterCollection object (TdCommand.Parameters property).
13227 Jan 2009 @ 10:05 PSTConnectivityReply.NET and using Parameters.NET Data Provider for Teradata (also ODBC Driver for Teradata) support parameter markers (question mark). They do not support named parameters.For example: class Program { public stat...
13122 Jan 2009 @ 06:36 PSTAnalyticsReply10065 WSA E HOST UNREACH:You mentioned two Domains. Is the Teradata system setup for Kerberos (Active Directory) authentication?Anyway, I do not think it is a Domain issue. Can you ping the Teradata nodes?Usually a Teradat...
13022 Jan 2009 @ 06:22 PSTConnectivityReply.Net dealing with password expiration.NET Data Provider for Teradata ( NOT Microsoft Data Provider for ODBC) fires InfoMessage events when password is expired. Therefore you can trap the "Password Expired" event and prompt the user fo...
12926 Dec 2008 @ 01:56 PSTDatabaseReplyCreate Table - Problem with Data TypesTeradata database supports two different cast syntax: a) CAST(Promo_Type as varchar(10)) b) Promo_type (VarChar(10))
12826 Dec 2008 @ 01:33 PSTDatabaseReplyCombining Parameters of a MacroI suggest: a) Change the macro parameters from Char to VarChar. Otherwise use TRIM to remove the trailing spaces. b) Apply "NOT CASESPECIFIC" if using ANSI session mode.
12722 Dec 2008 @ 04:23 PSTConnectivityReplyCannot find terasso library.See the ReadMe file; I think the following issue might be applicable to your scenario:PROBLEM/ISSUE============ Environment Variable PATH does not get updated after installing a Custom applicati...
12622 Dec 2008 @ 02:14 PSTConnectivityReplyCannot find terasso library."ODBC Driver for Teradata" is not related to DataDirect products/ODBC drivers. I think the PATH must be modified to point to the "ODBC Driver for Teradata\Lib" directory.
12514 Nov 2008 @ 04:10 PSTConnectivityReply.NET Teradata Driver in GAC1- Copy Teradata.Client.Provider.dll from InstallDir\Bin to your application directory.2- Copy Teradata.Net.Security.Tdgss.dll from InstallDir\PrivateAssemblies to your application directory.3- Use...
12410 Oct 2008 @ 08:26 PDTConnectivityReply.net provider for Teradata ErrorDo you have access to BTEQ? It displays the Teradata Database version right after you logon; for example: *** Logon successfully completed. *** Teradata Database Release is 12.00.01.13 ...
12310 Oct 2008 @ 01:20 PDTConnectivityReply.net provider for Teradata ErrorVersion 12.0 is latest version; but check your Database version first. Version 12.0 connects to Teradata Database 6.0, 6.1, 6.2 and 12.0. It does not connect to Teradata database version 5.1 or ear...
12209 Oct 2008 @ 01:34 PDTConnectivityReply.net provider for Teradata Error.NET Data Provider version 1.2 will execute a simple Select statement against DBC.DBCInfo view to retrieve the Teradata Database version. DBC.DbcInfo usually has three rows in it like:InfoKey ...

Pages