#DateForumTypeThreadPost
12106 Oct 2008 @ 03:59 PDTConnectivityReplyinstalling .net data provider for teradata problemsWindows Vista ships with .NET Framework 3.0. Also .NET Framework 3.5 includes .NET Framework 3.0 and 2.0. Therefore there is no need to install .NET Framework 2.0 or 3.0.Did you select/enable the ...
12024 Sep 2008 @ 02:10 PDTConnectivityReply.NET Provider performanceTdDataAdapter class supports Batch Update, which is a feature of ADO.NET 2.0: http://msdn.microsoft.com/en-us/library/kbbwt18a(VS.80).aspxTdDataAdapter.UpdateBatchSize must be set to a number hi...
11918 Sep 2008 @ 10:37 PDTDatabaseReplyOracle to Teradata Conversion of CharI am not sure if I understand your question. Teradata does not have an NCHAR data type. It has a CHAR data type but you can specify the Characeter Set: Char(2000) Character Set LATIN Char(200...
11810 Sep 2008 @ 08:32 PDTConnectivityReplyChanging session character set from ASCII to UTF8 causes trailing white spaces.UTF8 is a multi-byte character set. Teradata Database will calculate an Export Width based on column character set (Latin, Unicode, KanjiSJIS) and export width (see HELP SESSION) for the session. F...
11728 Aug 2008 @ 03:25 PDTConnectivityReplySQL Server Integration Services (SSIS) and Timeout ErrorsWhat is the error message? I do not fully understand the scenario; but there are few different timeouts.In BIDS: Select Tools -> options Select Business Intelligence Designers Selec...
11628 Aug 2008 @ 02:21 PDTDatabaseReplyTimestamp difference in secondsI think this issue has been discussed before; please search the archives. Two examples of rounding a decimal: Select Cast(3.178 as Decimal(18, 0));This example returns 3. Select Cast(3.678 as Dec...
11528 Aug 2008 @ 02:06 PDTConnectivityReplyTeradatas ODBC connectionDid you experiment with "Maximum Response Buffer Size"? Set the Buffer Size to 64000; it defaults to 8192. It will help if the bottleneck is the latency between Workstation and Teradata database.
11427 Aug 2008 @ 01:39 PDTConnectivityReplyDoes Teradata .Net provider support IA64 machine?Are you using the .NET Data Provider for Teradata with SQL Server on IA64 or some other third party tool on IA64?I am guessing that Machine.config file does not have an entry for Teradata.Client.Pr...
11326 Aug 2008 @ 01:54 PDTDatabaseReplyTimestamp difference in seconds Select (Timestamp'2008-12-10 10:12:00.000000' - Timestamp'2008-12-10 10:10:12.000000') Second(4,6)This example subtracts the two timestamp literals and returns an Interval Second of 108.000000 . ...
11226 Aug 2008 @ 01:13 PDTConnectivityReplyDoes Teradata .Net provider support IA64 machine?ReadeMe file states that it supports .NET Framework x86 and x64. .NET Data Provider version 12.0 is 100 precent managed code. Therefore it might work on IA64 but Teradata does not support it at thi...
11125 Aug 2008 @ 03:05 PDTDatabaseReplyError 3738 String is longer than 31000 charactersTeradata Database Messages manual states: Explanation: Quoted strings cannot be longer than 31000 physical characters. Notes: To insert longer strings, the user must have a USING clause and a DAT...
11022 Aug 2008 @ 03:19 PDTConnectivityReplyTeradata/Microsoft integrationTo my knowledge LINQ to SQL is limited to SQL Server. SQL Server 2008 Reporting Services has built-in support for Teradata database: http://msdn.microsoft.com/en-us/library/cc627532.aspx
10918 Aug 2008 @ 06:56 PDTConnectivityReplySQL Server Integration Services (SSIS) and Timeout ErrorsSwitch to "Data Flow" tab (vs. Control Flow) and select the DataReader source. The Properties window will show CommandTimeout at the very top; it is set to 30 seconds by default.
10806 Aug 2008 @ 01:27 PDTDatabaseReplyPrimary and Foreign Key information in TeradataLook at DBC.Indices view. The IndexType is set to K for Primary Key.IndexType: Returns the type of an index as:• P (Nonpartitioned Primary)• Q (Partitioned Primary)• S (Secondary)• J (join ...
10704 Aug 2008 @ 03:56 PDTAnalyticsReplyOutput parameter in stored procedureTeradata Stored Procedure does not have a 'return' parameter.Teradata SP can have zero or more Input, Output and Input/Output parameters. So use an output parameter to return data back to the client.
10630 Jul 2008 @ 04:37 PDTConnectivityReplyEM_GSSCALLFAILCLI reads the registry to find the path to TeraGSS. Maybe CLI does not have access rights to the registry when running within IIS..NET Data Provider for Teradata 12.0 does not require CLI and it d...
10530 Jul 2008 @ 04:14 PDTConnectivityReplyEM_GSSCALLFAILI thought you mentioned NQuery in your first post; therefore it is not related to IIS. NQuery will run as a 64-bit process on a 64-bit Windows. Are the other Windows Applications on this box 32-bit...
10430 Jul 2008 @ 03:55 PDTConnectivityReplyerror with 64bit teradata .net providerI just ran a test on my 64-bit system. My path is is set to PATH=C:\Program Files\NCR\Common Files\Shared ICU Libraries for Teradata\lib;C:\Program Files (x86)\NCR\Common Files\Shared ICU Libraries...
10330 Jul 2008 @ 03:32 PDTConnectivityReplyerror with 64bit teradata .net providerDoes NQuery startup?If NQuery starts up, then the .NET Data Provider is fine. You can use ListDlls to see that it loaded correctly from the GAC.I would write a simple console application that simpl...
10230 Jul 2008 @ 02:04 PDTConnectivityReplyEM_GSSCALLFAILI am not sure if CLI writes additional information to the Trace file or not. That said I suggest to turn on trace. You must set two environmental variables: a) COPANOMLOG: "COPANOMLOG should be se...
10130 Jul 2008 @ 01:39 PDTConnectivityReplyerror with 64bit teradata .net providerIs a service like IIS loading the .NET Data Provider? if it is a Service, did you restart the service after Installing CLI, ICU and GSS? Also did you install 32-bit and 64-bit versions of CLI, ICU ...
10030 Jul 2008 @ 01:19 PDTConnectivityReplyerror with 64bit teradata .net providerDid you install 64-bit versions of CLI, ICU and GSS?
9929 Jul 2008 @ 03:43 PDTConnectivityReplyupdating teradata through asp.net.NET Data Provider for Teradata ships with Learning Examples. They are in \samples\LearningExamples directory. Review readme.doc first.
9818 Jul 2008 @ 03:18 PDTConnectivityReplyODBC or .NET Provider?Use .NET Data Provider for Teradata.Sample Code: using (TdConnection cn = new TdConnection()) { TdConnectionStringBuilder conStrBuilder = new TdConnectionString...
9702 Jul 2008 @ 02:41 PDTConnectivityReplytdoledb not registered errorDid you restart IIS? I think installation modifies the path to point to "Shared ICU Libraries for Teradata\lib". IIS must be restarted to pickup the new path.

Pages