| 259 | 22 Apr 2013 @ 04:32 PDT | Connectivity | Reply | SSIS Teradata data destination very slow | The .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"... |
| 258 | 20 Mar 2013 @ 02:42 PDT | Connectivity | Reply | Visual Studio 2012 Server Explorer does not show Teradata provider | .NET Data Provider for Teradata version 14.10 does not integrate with Visual Studio 2012.
|
| 257 | 20 Mar 2013 @ 02:34 PDT | Connectivity | Reply | Only an ET or null statement is legal after a DDL Statement | You wrote: "The SQL executes fine when run directly against the database using SQL Assistant."
Try "Execute Parallel" (vs. "Execute") in SQL Assistant.
"E... |
| 256 | 14 Mar 2013 @ 01:51 PDT | Connectivity | Reply | Can 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.
|
| 255 | 13 Mar 2013 @ 02:37 PDT | Connectivity | Reply | Which 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... |
| 254 | 01 Mar 2013 @ 07:11 PST | Connectivity | Reply | DECIMAL OUT parameter lost value after SP CALL when after VARCHAR IN parameter | I tried it with the .NET Data Provider for Teradata
//Building connection string
&n... |
| 253 | 01 Mar 2013 @ 06:27 PST | Connectivity | Reply | Unable to connect to TeraData v13.0 from .NET client | It most likely means that you are connecting to wrong server (not Teradata Database); check the "Data Source" and "Port Number".
|
| 252 | 01 Mar 2013 @ 06:20 PST | Connectivity | Reply | teradata .net provider name | The 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 ... |
| 251 | 13 Feb 2013 @ 12:03 PST | Connectivity | Reply | Problem with the Teradata Sessions | Post 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... |
| 250 | 31 Oct 2012 @ 03:41 PDT | Connectivity | Reply | OBIEE sourcing from Teradata nQSError: 43113] Message returned from OBIS | IMO 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... |
| 249 | 03 Oct 2012 @ 09:55 PDT | Connectivity | Reply | Error - 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... |
| 248 | 24 Sep 2012 @ 01:09 PDT | Connectivity | Reply | Teradata 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... |
| 247 | 06 Sep 2012 @ 12:47 PDT | Connectivity | Reply | Support 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 ... |
| 246 | 22 Aug 2012 @ 12:18 PDT | Tools | Reply | TeraData SQL Profiler equivalent? |
See "Chapter 14 tracking Processing Behavior with DBQL" in http://www.info.teradata.com/edownload.cfm?itemid=113480004.
DBQL is an optional feature that you can empl... |
| 245 | 25 Jun 2012 @ 11:50 PDT | Connectivity | Reply | .NET Data Provider, Provider Factory, cannot create DataSource Enumerator |
The .NET Data Provider for Teradata has nothing to do with ODBC or the ODBC Driver for Teradata.
You must use the Microsoft .NET Data Provider for ODBC if you want to use the ODBC Driver to&... |
| 244 | 20 Jun 2012 @ 04:02 PDT | Connectivity | Reply | Install Teradata SQL Assistant |
I have been using the Teradata SQL Assistant (13.0 and higher) on the Microsoft Windows 7 Ultimate x64. The general "Teradata SQL Assistant have issues on 64-Bit OS"&nbs... |
| 243 | 08 Jun 2012 @ 05:51 PDT | Tools | Reply | SQL Assistant 14.01 download availability? |
You cannot download SQL Assistant. You need to upgrade to TTU 14.0.
|
| 242 | 07 Jun 2012 @ 04:57 PDT | Connectivity | Reply | Teradata.Net Provider and Entity Framework Entity Not being filled by Stored Procedure |
Can you post the stack trace and the DDL for WOFDWINT.VIN_VLDN table?
|
| 241 | 07 Jun 2012 @ 03:38 PDT | Connectivity | Reply | .Net Connection String with LDAP |
Use TdConnectionStringBuilder class to build the Connection String; set TdConnectionStringBuilder.AuthenticationMechanism to LDAP.
Data Source=192.168.1.54;User ID=mw;Passwo... |
| 240 | 06 Jun 2012 @ 01:18 PDT | Tools | Reply | SQL Assistant: System.ArgumentOutOfRangeException |
The Exception shown above (see the stack trace) is not related to the Maximum Response Buffer Size.
|
| 239 | 22 May 2012 @ 12:04 PDT | Connectivity | Reply | Delphi - ADO Connection String? |
What is the ODBC Driver for Teradata version?
Try:
Driver={Teradata};DBCName=XXXX;Authentication=LDAP;AuthenticationParameter=userName@@Password;
for additional information about Aut... |
| 238 | 14 May 2012 @ 09:47 PDT | Connectivity | Reply | ADO.Net 13.11.0.1 Provider hangs when trying to create Entity Model in Visual Studio 2010 |
You will need a patch (e-fix) for the Teradata Database. You can either open a customer incident; or upgrade to the latest version/patch-level of the Teradata Database.
|
| 237 | 08 May 2012 @ 03:13 PDT | Connectivity | Reply | Chinese character are not displaying properly |
We have lots of customers in China. Therefore it is very unlikely that the ODBC Driver for Teradata (13.0 and 14.0) has issues with Chinese characters.
However there are lots of differ... |
| 236 | 27 Apr 2012 @ 03:57 PDT | Connectivity | Reply | Chinese character are not displaying properly |
One more option, set the session character set to TCHBIG5_1R0 or SCHGB2312_1T0. Again I am assuming PHP binds/retrieves character data as SQL_C_CHAR.
|
| 235 | 27 Apr 2012 @ 03:28 PDT | Connectivity | Reply | Chinese character are not displaying properly |
A colleague searched the PHP source code for SQL_C_WCHAR; he found no hits. It is possible that PHP binds and retrieves the data as SQL_C_CHAR (i.e. Non-Unicode). If this assumnp... |