#DateForumTypeThreadPost
7116 Jan 2008 @ 04:43 PSTConnectivityReply.NET Data Provider for Teradata error [Call-Level Interface, Version 2] [303]Also make sure your DataSource conforms to TDPID rules like 8 characters max. CLI enforces this rule but ODBC does not. You can use IP address for the DataSource.
7016 Jan 2008 @ 01:43 PSTConnectivityReply.NET Data Provider for Teradata error [Call-Level Interface, Version 2] [303]I think CLI cannot parse the Logon String which is something like "DataSource/UserId,Password".Do you have BTEQ? Can BTEQ logon to the DataSource?
6927 Nov 2007 @ 03:41 PSTDatabaseReplyHow to create a stored procedure in TeradataI assume you have access to BTEQ.Here are the steps in BTEQ: 1- Logon to Teradata 2- Type ".HELP BTEQ" without the double quotes in BTEQ; the COMPILE command is at the very top. 3- Use COMPILE ...
6831 Oct 2007 @ 01:48 PDTDatabaseReplyJDBC - Problem calling macro with result-setThis is just a guess; Add Select DATE to the very begining of the macro. I think the JDBC driver is looking at the very first Activity Type as oppose to scanning for data retuning Activity Types.
6731 Oct 2007 @ 01:36 PDTConnectivityReplyTable function arguments containing single quotesEscape the single quote with another single quote. select x from table (y('I need single ''quotes'' in here')) as z;
6618 Oct 2007 @ 08:25 PDTAnalyticsReply.Net Provider query timeout expired.Query timeout is controlled through TdCommand.CommandTimeout property. It defaults to 30 seconds. It is very easy to set this value if you are writing a .Net application.Are you using a third party...
6512 Oct 2007 @ 09:57 PDTDatabaseReplybizarre CAST/CASE problemDid you try SubStr(b.sid_cd, 1, 2)?
6409 Oct 2007 @ 02:58 PDTConnectivityReply.Net driverThis is a documented issue in release notes: Note: In a case where the system has an ODBC Driver for Teradata, the ODBC Driver for Teradata installs the TeraSSO.dll in the Windows\System32 dir...
6305 Oct 2007 @ 01:27 PDTConnectivityReplyconvert timestamp field in Teradata into format 'MMM-YYYY'What is Reportstudio?I tried this in BTEQselect CURRENT_TIMESTAMP (FORMAT 'MMM-YYYY'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second.Current TimeStam...
6203 Oct 2007 @ 01:57 PDTUDAReplyTIMESTAMPConceptually there are two differnt algorithms for converting "TIME WITH ZONE" (CURRENT_TIME) to "TIMESTAMP". a) Convert "TIME WITH ZONE" to "TIME" and then add current the System Date to it to ...
6102 Oct 2007 @ 12:34 PDTUDAReplyTIMESTAMPDid you try CURRENT_TIMESTAMP as oppose to CURRENT_TIME?Are CURRENT_TIMESTAMP and CURRENT_DATE also off by 1?
6013 Jul 2007 @ 01:56 PDTConnectivityReply.NET Provider Invalid Connection StringI know the Data Provider has been tested on Japanese machines because it is localized for Japan.Does TdConnectionStringBuilder help with this issue? Did you create Unicode source-code and make sure...
5911 Jul 2007 @ 11:13 PDTConnectivityReply.NET Provider Invalid Connection StringCan you try this? public class Program { static void Main(String[] args) { DbProviderFactory factory = DbProviderFactories.GetFactory("Teradata.Client...
5818 Jun 2007 @ 12:51 PDTToolsReplyFailed to initialize CLI. CLI returned 321 error code.I think there is an OLD version of CLI in Windows\System32 directory. Use the steps in .NET Data Provider for Teradata error [Call-Level Interface,... to diagnose the issue.
5707 Jun 2007 @ 02:22 PDTDatabaseReplysession parameter list.....What do you mean by "session parameters"?For example "Help Session" displays the session properties. But it does not display the port number or the IP address.
5607 Jun 2007 @ 02:18 PDTToolsReply.OLE DB for TeradataThe default port is 1025.
5501 Jun 2007 @ 02:01 PDTAnalyticsReplyAll virtual circuits are currently in useRE: We had tried the TD .NET provider provided on the Teradata site, but this caused issues in the apps where it was not installed (oracle or mssql servers) because it was bound to the application ...
5431 May 2007 @ 01:56 PDTConnectivityReplyTdConnection is not openI suggest you follow the steps in .NET Data Provider for Teradata error [Call-Level interface... and use NQuery initially to test connectivity.I also suggest capturing the error message and the sta...
5322 May 2007 @ 01:31 PDTConnectivityReply.NET Data Provider for Teradata error [Call-Level Interface, Version 2] [303]Error 303 is "BADLOGON Invalid logon string".Earlier versions of CLI did not support IP address as the "Data Source".I suspect you are not using CLI version 4.8.1.4.I suggest: a) Download LISTDLLS...
5210 May 2007 @ 06:55 PDTConnectivityReply.NET providerIt is around 1MB for Teradata database 6.x.
5110 May 2007 @ 01:49 PDTConnectivityReply.NET provider.NET Data Provider sends a message to Teradata Database. Message has physical limits (e.g. size of the message and/or size of the parcels).In another word, number of rows packed into a a message is...
5010 May 2007 @ 01:39 PDTConnectivityReplyHelp need for OLEDB teradata driver1- Add a reference to "System.Data.dll".2- Add a using statement: "using System.Data.OleDb".3- Set the OleDbConnection.ConnectionString property to "Provider=Tdoledb;Data Source=X;User Id=Y;Passwor...
4916 Apr 2007 @ 05:47 PDTConnectivityReplyKeep Inserts and Deletes from returning a recordsetTdDataReader class in the .NET Data Provider for Teradata skips DELETE, INSERT and UPDATE results sets and will stop at the very first data-returning (SELECT) statement.
4813 Apr 2007 @ 04:44 PDTDatabaseReplyCreate UTF-8 database?Teradata supports Server (Column) Character Sets and Session Character Set.The Server/Column Character Sets are: LATIN UNICODE GRAPHIC KANJI1 KANJISJISFor example: Create Table Foo (C01 Intege...
4702 Apr 2007 @ 03:10 PDTConnectivityReplyodbc.issI believe the TTU CDs have the response file.However, you can record a response file using "/r" option: setup.exe Command-Line parameters

Pages