346 | 29 Aug 2016 @ 10:44 PDT | Connectivity | Reply | Can you get Teradata.Client.Provider for c#/dot.net just from disk? | 1- You can install two or more version of the .NET Data Provider for Teradata on you workstation. This concept is called Side-By-Side and the .NET Data Provider for Teradata has supported this feat... |
345 | 17 Aug 2016 @ 09:27 PDT | Connectivity | Reply | Teradata Client 15.0 to 15.11 for c# dot.net builds | Right click on the Reference and select Properties; Is the "Specific Version" set to False?
http://stackoverflow.com/questions/24022134/how-exactly-does-the-specific-version-proper... |
344 | 05 Aug 2016 @ 09:58 PDT | Connectivity | Reply | Connecting to Teradata through PYODBC on Mac | Load the iODBC Data Source Administrator tool; select the Drivers tab and check for the Teradata Driver. Most likely the Teradata ODBC Driver is not registered with the iODBC Driver Manager. ... |
343 | 21 Jun 2016 @ 10:35 PDT | Connectivity | Reply | python / odbc connection to TD | Windows or Linux?
This might help: http://developer.teradata.com/blog/odbcteam/2016/02/python-with-teradata-odbc
|
342 | 21 Jun 2016 @ 10:28 PDT | Connectivity | Reply | Command line installation for ODBC Driver for Windows 15.00.00.00 | http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TTU15.10.04&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Tools+and+Utili... |
341 | 16 May 2016 @ 10:46 PDT | Connectivity | Reply | Can not connect to TD from SQLA over home network, but can connect using BTEQ! | There is an outstanding issue with the private copies of the Visual Studio 2012 libraries in the MS Office 2016. The VS 2012 libraries are out of date and they prevent one of the ODBC DLLs to load.
|
340 | 21 Mar 2016 @ 12:37 PDT | Connectivity | Reply | Excel 2013 (32 bit) - Teradata ODBC Connectivity issue | You need to create a new Data Source with the 64-bit ODBC Data Source Administrator.
|
339 | 18 Feb 2016 @ 06:55 PST | Connectivity | Reply | ODBC ts time stamp for now() |
select * from TabFoo where X = {fn TIMESTAMPADD( SQL_TSI_DAY, -80, {fn CURRENT_TIMESTAMP})}
Note that the CURRENT_TIMESTAMP must be wrapped with FN escape sequence also. The ODBC driver will con... |
338 | 18 Feb 2016 @ 06:32 PST | Connectivity | Reply | All Connections to Teradata fail with Receive Operation Timed Out | Post the stack trace.
Can you connect with BTEQ or ODBC (from SQLA)?
|
337 | 25 Jan 2016 @ 12:27 PST | Connectivity | Reply | Is it possible to connect to Teradata from Excel without installing Teradata drivers? | Are you writing an Excel Add-in with C# or VB.NET? if yes, then you can use the .NET Data Provider for Teradata for connectivity to the Teradata Database; and privately deploy the two Assemblies (T... |
336 | 21 Jan 2016 @ 11:03 PST | Connectivity | Reply | Connect Teradata SQLA using LDAP | You do not need to install OpenLDAP on the clinet machine. You must configure the Teradata Database to authenticate with external authentication. Set the Mechanism to LDAP and specify the User-ID (... |
335 | 11 Jan 2016 @ 07:04 PST | Tools | Reply | SQL Assistant 15.00 Cursor lagging problems | Did you install the latest version 15.0.0.9? I release notes show a few performance improvements but I am not sure if they are applicable to this case.
|
334 | 08 Jan 2016 @ 02:23 PST | Connectivity | Reply | .NET provider vs. ODBC | You should contact your DBA to find out if your organization has a service agreement and how to open an incident.
|
333 | 08 Jan 2016 @ 02:19 PST | Connectivity | Reply | .NET provider (ver 15.xx), TdCommandBuilder, bulk load, error | No we did not change the semantics of the Command Timeout.
The .NET Data Provider 15.0 was enhanced to support new batch-update scenarios. It might be sending a larger Batch-Update to Teradata Dat... |
332 | 07 Jan 2016 @ 06:52 PST | Connectivity | Reply | .NET provider (ver 15.xx), TdCommandBuilder, bulk load, error | The default Command-Timeout is 30 seconds. How long does it take to execute the command(s) with 14.11.0.1?
The System.Data.Common.DbCommandBuilder class transfers the CommandTimeout from the... |
331 | 07 Jan 2016 @ 06:23 PST | Connectivity | Reply | .NET provider vs. ODBC | In our tests the "Microsoft Data Provider for ODBC" is slower than the .NET Data Provider for Teradata. It would be very difficult to analyze your issue remotely. I suggest you open and i... |
330 | 04 Jan 2016 @ 04:33 PST | Tools | Reply | TPT via .NET (C#) | This is very old but it might be still applicable:
https://tptapiwrapper.codeplex.com/
|
329 | 29 Dec 2015 @ 10:26 PST | Connectivity | Reply | CommandTimeout - Query doesn't abort if in responding state | You must execute the Query with TdCommand.ExecuteReader() method and must use the TdDataReader to process the Result-set (read one row at a time).
TdDataReader.RecordsReturned or TdDataReader.Reco... |
328 | 29 Dec 2015 @ 10:22 PST | Connectivity | Reply | CommandTimeout - Query doesn't abort if in responding state | You are using ExecuteNonQuery. This method must process the entire result set. You need to use ExecuteReader instead and immediately dispose the DataReader:
using (TdCommand cmd = tdCon.... |
327 | 22 Dec 2015 @ 02:56 PST | Connectivity | Reply | CommandTimeout - Query doesn't abort if in responding state | Your application must process the result (DataReader) and it must close/dispose the DataReader to release the spool. I think the Select statement completed and DBS started to send back data to the ... |
326 | 11 Dec 2015 @ 06:22 PST | Connectivity | Reply | Cannot find terasso library with MSAccess2013 | This sounds very similar to the Office 365 issue. Office 365 ships with an older version of Visual Studio C++ Runtime libraries which might explain why BIQuery works but MS Access 2013 does not. I ... |
325 | 04 Dec 2015 @ 10:54 PST | Connectivity | Reply | .Net Provider DateTime-Timestamp Data Type | http://developer.teradata.com/doc/connectivity/tdnetdp/15.11/help/webframe.html#TimestampDetails.html
It will show you how to set the Scale (TdParameter.Scale) for Timestamp(6).
|
324 | 04 Nov 2015 @ 03:44 PST | Connectivity | Reply | Teradata odbc connection and tmp space | "Create User" DDL statement sets the Permanent, Spool and Temporary space limits.
|
323 | 29 Oct 2015 @ 01:57 PDT | Connectivity | Reply | Problems using SET QUERY_BAND from ODBC |
it works fine in Teradata SQL Assistant, but chokes in ODBC with the message "Only an ET or null statement is legal after a DDL Statement".
Are you attempting to execute a Multi-Sta... |
322 | 30 Sep 2015 @ 01:33 PDT | Connectivity | Reply | Connecting to TD15 from Visual Basic | I recommend that youread section #3 of
http://developer.teradata.com/blog/netfx/2011/12/setup-sql-server-2008-r2-linked-server-to-the-teradata-database
Use a UDL file to get the Connection ... |