#DateForumTypeThreadPost
19605 Aug 2011 @ 03:39 PDTConnectivityReply13.11 .Net Provider with Web ApplicationDownload .NET Data Provider version 13.11.0.1; e-fix for this issue.
19501 Aug 2011 @ 11:19 PDTConnectivityReplyEntity Provider for TeradataThe .NET Data Provider version 13.11.0.1 integrates with Visual Studio 2010 and supports EDM generation/wizard. It also has a workaround for generating Entities from Views. Are you using 13.11.0...
19414 Jul 2011 @ 10:57 PDTConnectivityReplyWindows 7 64-bit, SQL 2008R, needs to connect to Teradata using linked serverYou can use 64-bit "Microsoft OLE DB Provider for ODBC" + 64-bit "ODBC Driver for Teradata". "OLE DB Provider for Teradata" is a 32-bit driver.
19305 Jul 2011 @ 10:00 PDTConnectivityReplyTeradata SQL Assistant 13 with Teradata .Net providerWhat version of the .NET Data Provider for Teradata? I suggest upgrading to .NET Data Provider for Teradata version 13.1.0.4 (TTU 13.0) or version 13.11.0.1 (TTU 13.10); download it from: ht...
19219 May 2011 @ 12:16 PDTTeradata ApplicationsReplyHelp needed!Break in the debugger after adapter.Fill and use Visual Studio to investigate the tables in the DataSet. Visual Studio has a Visualizer for DataSet; in the Watch windows type "ds" and then click th...
19126 Apr 2011 @ 04:34 PDTConnectivityReply.NET Teradata Driver in GACUse Assembly.Load to debug "load" failures because Type.GetType(String) returns null in some cases DataTable factories = DbProviderFactories.GetFactoryClasses(); ...
19021 Apr 2011 @ 02:27 PDTConnectivityReplyexecuting imported teradata stored procedure from DATASERVICESUse "ODBC Data Source Administrator" to disable "Call to Exec Conversion". Snippet from the ODBC Manual: Default = Cleared When cleared, ODBC Driver for Teradata converts CALL statements ...
18919 Apr 2011 @ 11:35 PDTConnectivityReply.NET Teradata Driver in GACAt runtime CLR must be able to load Teradata.Client.Provider.dll and Teradata.Net.Security.Tdgss.dll assemblies. CLR hosted within ASP.NET will look for private assemblies in the BIN Directory. ...
18817 Mar 2011 @ 07:00 PDTConnectivityReplyTeradata SQL Assistant ODBC connection cannot find Teradata driver 64bit Windows server 2003 Teradata SQL Assistant is a 32-bit application. 32-bit applications cannot utilize 64-bit drivers. Therefore the solution described above is actually the normal process (i.e. install 32-bit ODBC ...
18714 Feb 2011 @ 05:45 PSTConnectivityReplyCONNECTIVITY ERRORIt is most likely caused by a connectivity issue between the Client (in your case TTU13.0 server) and the Teradata Database. The Data Provider also generates this error when the Teradata Database s...
18608 Feb 2011 @ 01:25 PSTConnectivityReplyMONITOR Processing using the .NET DriverThe .NET Data provider for Teradata does not support MONITOR sessions. I recommend looking at Open API (see Workload Management API: PM/API and Open API). You can utilizie Open API with the .NET D...
18525 Jan 2011 @ 11:52 PSTConnectivityReply.Net provider never listedNQuery invokes DbProviderFactories to get a list of installed Data Providers. DbProviderFactories reads the system.data section in Machine.Config file; it should have an entry for the .NET Data P...
18420 Jan 2011 @ 01:19 PSTConnectivityReplyUsing parameters with stored procedure and .Net ProviderTechnically Macros are not identical to Stored Procedures. Per ADO.NET specification, Macros similar to all other SQL-Statements (not including Stored Procedure) must use parameter markers. A...
18329 Dec 2010 @ 11:09 PSTDatabaseReplyConvert varchar(8) to date in select statementI just tried the following on Teradata 13.0; create table TestCastDate (C01 Integer, C02 VarChar(8)); Insert Into TestCastDate values (1, '19981001'); Insert Into TestCastDate values (2, '1998...
18229 Dec 2010 @ 10:43 PSTDatabaseReplyConvert varchar(8) to date in select statementIs it VarChar(8) or VarChar(10)? The format mentioned in the post is for VarChar(10). Try something like select cast('12199931' as DATE format 'MMYYYYDD');
18122 Dec 2010 @ 12:11 PSTConnectivityReplyNeed Help with Teradata ODBC driver on Oracle/AIXODBC Driver for Teradata User Guide chapter 2 "Configuration for UNIX" describes how to setup a DSN in ODBC.INI file. You can download the ODBC User Guide from: http://www.info.teradata.com/...
18022 Dec 2010 @ 12:01 PSTConnectivityReplyTearadata Client setup for SAS serverI think you are looking for CLI on Solaris 10. Anyway a) locate the Product and Platform in "Teradata Tools and Utilities Supported Platforms and Products" using the URL below: http://www.info....
17903 Dec 2010 @ 10:05 PSTConnectivityReplyUser SQL Server 2008 to connect to TeradataSQL Server Linked Server utilizes OLE DB Providers to access external Data Sources; but it supports/works with Microsoft OLE DB Provider for ODBC (http://msdn.microsoft.com/en-us/library/ms188279.a...
17802 Nov 2010 @ 12:17 PDTToolsReplyANSI Mode in SQL Assistant SQL Assistant does not support explicit transaction in ANSI mode because ODBC specification requires Auto-Commit mode by default; and furthermore there is no SQL command to open an Explicit Transa...
17722 Oct 2010 @ 07:09 PDTConnectivityReplysilent installation of teradata client ( terGSS, tdicu and cliv2) on NT.Download "Teradata Tools and Utilities Installation Guide for Microsoft Windows" from www.info.Teradata.com; this manual has section titled "Installing a Package Silently from the Command Prompt".
17604 Oct 2010 @ 08:14 PDTConnectivityReplyConnecting to Teradata through ASP.NET using C#.NET Data Provider uses TCP/IP to connect to Teradata Database. Do you have network connectivity between the two locations (WAN)? You can use Teradata SQL Assistant with .NET Data Provider to test ...
17504 Oct 2010 @ 08:01 PDTConnectivityReplyODBC or .NET Provider?.NET Data Provider must resolve the "Data Source" name to an IP-Address in order for the Data Provider to establish a socket connection to Teradata Database. The error message is indicating that DN...
17403 Sep 2010 @ 01:47 PDTConnectivityReplyTeradata .net provider for Visual Studio 2010(.Net 4.0)DbProviderFactories reads configuration information from 1- Machine.Config 2- App.Config .NET Data Provider Installation adds information to CLR 2.0 Machine.Config; open Windows\Microsoft....
17326 Aug 2010 @ 12:12 PDTConnectivityReplyTeradata .net provider for Visual Studio 2010(.Net 4.0)Two separate issues: 1- Visual Studio 2010 Integration 2- .NET Framework 4.0 support .NET Data Provider 13.0.0.1 does not automatically integrate with Visual Studio 2010. But it can be u...
17212 Aug 2010 @ 12:54 PDTConnectivityReplyCan't bind VARCHAR variables tru ODBC driver Why do you initialize the dbtype, obtype and dblen after the call to SQLBindParameter? I suggest experimenting with a simple example similar to: http://msdn.microsoft.com/en-us/library/ms7109...

Pages