#DateForumTypeThreadPost
17111 Aug 2010 @ 06:05 PDTConnectivityReply.NET Teradata Driver in GACI assume "web application" means ASP.NET application. Did you try web.config?
17003 Aug 2010 @ 11:40 PDTConnectivityReply.Net Provider - Column Character SetI agree that Char_type can help in some scenarios. But Teradata Database has a concept of Session Character Set. All Char/VarChar data is converted to Session Character Set before it is send to th...
16928 Jul 2010 @ 10:21 PDTConnectivityReply.Net Provider - Column Character SetTdDataReader.GetSchemaTable method does not return CharType (Character Set not to be confused with Session Character Set). However Columns Schema Collection (TdConnection.GetSchema('Columns' ...) m...
16818 May 2010 @ 04:01 PDTConnectivityReplyHandling Stored Procedure DatasetsI forgot to mention that this custom feature is documented in the help file; see "Returning Data of Output Parameters in a Result Set" in "Stored Procedure Dynamic Result Set" page. This page a...
16718 May 2010 @ 03:50 PDTConnectivityReplyHandling Stored Procedure Datasets.NET Data Provider for Teradata has a custom feature for ad-hoc query tools. For example given the following Stored Procedure: REPLACE PROCEDURE spDelete(IN pCodeToDelete INTEGER, OUT pStatu...
16614 May 2010 @ 10:58 PDTConnectivityReplyHandling Stored Procedure Datasets.NET Data Provider returns Output Parameters as "Output Parameters". That is the TdCommand.Parameters collection must have one or more instances of TdParameter with Parameter.Direction set to Param...
16524 Mar 2010 @ 05:44 PDTConnectivityReplyHow to mention default database when using Teradata OLEDB provider for connection(DSN LESS). I forgot to mention that all connection string attributes are listed in the "Using OLE DB Provider for Teradata" manual in Chpater 2 "Setting Provider String Attribute" section.
16424 Mar 2010 @ 05:41 PDTConnectivityReplyHow to mention default database when using Teradata OLEDB provider for connection(DSN LESS). Change the connection string to Provider=TDOLEDB.1;User ID=YYYYY;Data Source=Server Name; Persist Security Info=false;Password=YYYYYY;Default Database=Y;
16323 Mar 2010 @ 10:55 PDTConnectivityReplyOBDC Segmentation fault / core dump on Solaris ODBC Driver for Teradata ships with DataDirect ODBC Driver Manager; to my knowledge it is not certified with unixODBC Driver Manager. Sorry I have no experience with unixODBC Driver-Manager.
16217 Mar 2010 @ 07:46 PDTConnectivityReplyHow to Call Teradata Stored ProcedureSet the TdCommand.CommandText to the Stored Procedure Name and Set the TdCommand.CommandType to CommandType.StoredProcedure. Data Provider will generate the appropriate CALL statement. Note tha...
16117 Mar 2010 @ 07:27 PDTConnectivityReplyOBDC Segmentation fault / core dump on Solaris Why do you list unixODBC? Are you trying to use unixODBC Driver Manager with ODBC Driver for Teradata?
16017 Mar 2010 @ 07:13 PDTToolsReplyNo Views or Tables in SQL Assistant 13.0I suspect that you do not have access to the Data Dictionary Views. Data Dictionary X-Views return the Objects (Tables, Views …) you have access rights to; for example try "Select * from DBC....
15928 Feb 2010 @ 01:09 PSTConnectivityReplyError while executing Stored ProcedureYes you do need a C/C++ compiler. Search for: Visual Studio Teradata Demo
15828 Feb 2010 @ 01:00 PSTConnectivityReplyODBC parmeter helpDid you try the online help? each dialog box has a "Help" button which displays the online help for each dialog-box. At this point, you must click on each field to see a tooltip-like-window. A...
15722 Jan 2010 @ 02:29 PSTConnectivityReplythe data is screwed when returning special characters in teradata client 13.0Post additional information; for example a) Teradata 13 Driver: Do you mean ODBC Driver? b) Session Character Set: Are you using ASCII session character set or a Unicode (UTF8, UTF16) session ch...
15614 Jan 2010 @ 01:17 PSTConnectivityReplyConnection String for VB.NET OLEDB class?Use ".NET Data Provider for ODBC" not ".NET Data Provider for OLE DB". I suggest ".NET Data Provider for Teradata" if there is no specific requirement to use the ODBC driver.
15518 Dec 2009 @ 01:48 PSTConnectivityReplyTeradata .Net Drivers on Windows 7 Professional 64 Bit.NET Data Provider version 12.0 and higher is 100 percent managed code and does not require CLI, ICU, TeraGSS.I suggest using the latest version of .NET Data Provider; but first check the Teradata ...
15416 Nov 2009 @ 03:03 PSTConnectivityReplyConnection timeout with .NET provider 13.01.NET Data Provider also uses port number 1025 by default. The port number is configurable via the Connection String. It is documented in the Help-File; see TdConnectionStringBuilder.PortNumber or T...
15305 Nov 2009 @ 03:35 PSTConnectivityReplySSIS 2008 Vs Teradata Via .NET DriverI suggest testing the connectivity first using NQuery (Installation Directory\Samples\Bin). The message truncation issue is caused by a socket failure; usually it means that DBS or OS closed/shutdo...
15221 Oct 2009 @ 01:44 PDTThird Party SoftwareReplyTeradata on LinuxYes; see http://developer.teradata.com/database/articles/teradata-express-13-0-family-available
15108 Oct 2009 @ 02:03 PDTConnectivityReplyODBC driver for Windows Itanium 64-bit OSDownload "Supported Platforms and Products version" spreadsheet from:http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy-Results.cfm?pl=&PID=&title=%25&release=&kword=TTU12.0&sbrn=7&nm=Te...
15006 Oct 2009 @ 01:54 PDTConnectivityReplyTeradata Teradata SQL Assistant client installation error in x64 windows systemDid you install ODBC Driver for Teradata 32-bit version? Also include details like SQL Assistant version, ODBC Driver version and etc.
14902 Oct 2009 @ 10:55 PDTConnectivityReplyOLEDB Authentication Connection String Attributea) Create an empty file with UDL extension; for example right click in Windows Explorer, select new and select Text File; now you can rename it to x.udl. b) double-click x.udl file; it should di...
14829 Sep 2009 @ 02:38 PDTConnectivityReplyQuery Timeout again....TdDataAdapter(String, TdConnection) constructor is used to initialize the DataAdapter. Therefore TdDataAdapter creates an internal TdCommand object and initializes it with the SQL String. Set the c...
14717 Sep 2009 @ 01:13 PDTConnectivityReplyDate formatting issues - maybe new ODBCCheck the DateTime Format in the Teradata ODBC Driver Options dialog box. I suspect that you had set it "AAA" before and now it is defaulted to "III". Start from "ODBC DataSource Administrator"; Se...

Pages