#DateForumTypeThreadPost
27115 Nov 2013 @ 12:37 PSTConnectivityReplyHow to connect Teradata in entity data model wizardcasablanca, You can use the Entity Provider for Teradata within Visual Studio 2010. Of course it only supports Entity Framework 3.5 features; i.e. Database First, 3.5 Canonical functions and ...
27005 Nov 2013 @ 05:14 PSTConnectivityReplyproblem with ODBC drivers SQL assistant not workingThere are two version of the ODBC driver on the download center: http://downloads.teradata.com/download/connectivity/odbc-driver/windows it is the file with "_i386" (vs. x8664).  
26930 Oct 2013 @ 10:16 PDTConnectivityReplyproblem with ODBC drivers SQL assistant not workingI am guessing that there is a mismatch between SQL-Assistant (32-bit) and the ODBC Driver (64-bit). Did you install the 32-bit version of the ODBC Driver for Teradata? Also note that you must use ...
26830 Oct 2013 @ 10:10 PDTConnectivityReplyOLE DB Teradata Provider for Windows (64-bit)There is no 64-bit OLE DB Provider for Teradata. You can use "Microsoft OLE DB Provider for ODBC (64-bit)" + "ODBC Driver for Teradata (64-bit)".  
26714 Oct 2013 @ 05:04 PDTConnectivityReplyODBC SQL_ACTIVE_STATEMENTS limit error using Python / pyodbcNo, a hStmt does not equate to a database session. The Teradata Database supports 16 Open Result Sets per session. I am not familiar with pyOdbc. But there must a Release or Close method for ...
26625 Sep 2013 @ 10:29 PDTConnectivityReplyConnection String Basics, VBA to Teradata SQL AssistantYou are trying to use ADO + "Microsoft OLE DB Provider for ODBC" + "ODBC Driver for Teradata" . 1- User ODBC Administrator to setup an ODBC Data Source. You might have one...
26509 Sep 2013 @ 05:50 PDTConnectivityReplyNet. provider Teradata Database 8017What version of SQL Assistant? Are you using ODBC or "Teradata.NET" in SQL Assistant to connect to the Teradata Database? If you are using "Teradata.NET", then you are using the...
26421 Aug 2013 @ 02:12 PDTConnectivityReplyWindows Server 2008 & ODBC 14 driver loading errorICU and ODBC installations modify the PATH environmental variable. I am guessing that the ODBC driver cannot load the ICU DLL(s). Did you restart SIIS and/or OS?
26315 Aug 2013 @ 07:18 PDTConnectivityReplyfailed to connect to Teradata server through C#The properties of the TdConnectionStringBuilder class correspond to the connection string attributes. Therefore you can change your code to builder.DataSource = "myDataSource&q...
26213 Aug 2013 @ 01:01 PDTConnectivityReplyRed Hat ODBC DriversDownload CLI; it has TDICU and TERAGSS http://downloads.teradata.com/download/connectivity/cliv2/linux
26113 Aug 2013 @ 09:18 PDTConnectivityReplyfailed to connect to Teradata server through C#You should use the TdConnectionStringBuilder class; set the Properties of the TdConnectionStringBuilder class and then retrieve the ConnectionString Property. Also see http://developer....
26018 Jul 2013 @ 05:35 PDTConnectivityReplyHow to connect Teradata in entity data model wizardDid you install the .NET Data Provider for Teradata? if not, go to http://downloads.teradata.com/download/connectivity/dot-net-data-provider download the latest version (14.10) and insta...
25922 Apr 2013 @ 04:32 PDTConnectivityReplySSIS Teradata data destination very slowThe .NET Data Provider for Teradata supports batch update (see ADO.NET Batch Update http://msdn.microsoft.com/en-us/library/aadf8fk2.aspx); but most likely the SSIS "ADO.NET Destintation"...
25820 Mar 2013 @ 02:42 PDTConnectivityReplyVisual Studio 2012 Server Explorer does not show Teradata provider.NET Data Provider for Teradata version 14.10 does not integrate with Visual Studio 2012.  
25720 Mar 2013 @ 02:34 PDTConnectivityReplyOnly an ET or null statement is legal after a DDL StatementYou wrote: "The SQL executes fine when run directly against the database using SQL Assistant." Try "Execute Parallel" (vs. "Execute") in SQL Assistant.  "E...
25614 Mar 2013 @ 01:51 PDTConnectivityReplyCan operations to a Teradata DB made via the .NET Data Provider for Teradata participate in a distributed transaction?No; Teradata Database does not support distributed transactions.
25513 Mar 2013 @ 02:37 PDTConnectivityReplyWhich connectivity option should I use?I assume you are asking about the "Microsoft .NET Data Provider for ODBC" and the ".NET Data Provider for Teradata". The answer is very simple; use the ".NET Data Pro...
25401 Mar 2013 @ 07:11 PSTConnectivityReplyDECIMAL OUT parameter lost value after SP CALL when after VARCHAR IN parameterI tried it with the .NET Data Provider for Teradata             //Building connection string        &n...
25301 Mar 2013 @ 06:27 PSTConnectivityReplyUnable to connect to TeraData v13.0 from .NET clientIt most likely means that you are connecting to wrong server (not Teradata Database); check the "Data Source" and "Port Number".
25201 Mar 2013 @ 06:20 PSTConnectivityReplyteradata .net provider nameThe connection string shown above is for the "Microsoft .NET Data Provider for OLE DB". In other words, this ADO.NET Data Provider is a Bridge; it utilizes a native OLE DB Provider under ...
25113 Feb 2013 @ 12:03 PSTConnectivityReplyProblem with the Teradata SessionsPost additional information about your application and the driver (.NET Data Provider, ODBC or JDBC). Are you using Connection Pooling? For example the .NET Data Provider connection pooling does n...
25031 Oct 2012 @ 03:41 PDTConnectivityReplyOBIEE sourcing from Teradata nQSError: 43113] Message returned from OBISIMO the SQL Statement does not use a two-part fully qualified table name (i.e. DatabaseName.TableName); therefore you must change the default database. You can specify the Default Database&nbs...
24903 Oct 2012 @ 09:55 PDTConnectivityReplyError - Only an ET or null statement is legal after a DDL Statement.SQL Assistant executes each statement (separted by semicolon) separately. SQL Assistant can execute Multi-Statements requests also. You must click/select "Execute Parrallel" which g...
24824 Sep 2012 @ 01:09 PDTConnectivityReplyTeradata EntityFramework provider bug?Please post additional information in order to recreate this issue; for example 1- EF version 2- .NET Framework version 3- EDM & how did you create the EDM?  4- Table de...
24706 Sep 2012 @ 12:47 PDTConnectivityReplySupport for Named Parameters in .NET Provider The Teradata Database does not support Named Parameters. The Teradata Database supports a USING clause which is similar to the Named Paramters but not identical; the USING clause does ...

Pages