#DateForumTypeThreadPost
4606 Feb 2007 @ 10:47 PSTConnectivityReply.NET provider and SSRSRefer to Deploying a Data Processing Extension when you are ready to deploy your extension to the report server.
4506 Feb 2007 @ 09:24 PSTConnectivityReply.NET provider and SSRSNo, the base class ConnectionExtension implements the IDbConnectionExtension interface.
4406 Feb 2007 @ 04:22 PSTConnectivityReply.NET provider and SSRSTo enable the credentials tab and maybe the Cached Report:1- Create Visual C# Class Library Project. Set the project name to YYYY.SSRS.DataExtension. Replace YYYY with your company name. 2- Add R...
4306 Feb 2007 @ 03:36 PSTConnectivityReply.NET provider and SSRSIDbConnectionExtension interface is not part of the ADO.NET specification. This interface is designed for and used by SQL Server Reporting Services. What is a "Cached Report"? Do you mean a report ...
4231 Jan 2007 @ 11:34 PSTToolsReplyRun Query show random X rows and stop the QueryRefer to SAMPLE Clause in Teradata Data Manipulation Statements manual. An example from the manual:Suppose you want to see if your customers are in at least 100 cities. The SELECT statement todo th...
4119 Jan 2007 @ 11:08 PSTConnectivityReplyBUG! i thinkV2R6.2 supports Large Decimals up to 38 precision. V2R6.1 supports Decimals up to 18 precision. I dont think the upgrade will have any impact on Decimal(10).Are you using Record Mode or Indicator M...
4018 Jan 2007 @ 11:23 PSTConnectivityReplyBUG! i thinkI have no experience on Mainframe but know that CLI simply passes the Data (or IndicData) parcel directly to Terdata database. I suggest retrieving the number from Teradata as to compare the Extern...
3916 Jan 2007 @ 09:35 PSTConnectivityReplycontextarea paramter to CLI functionsI assume you are referring to Network CLI. The documentation for network CLI states "four-byte field which may contain any value because it is not used by CLI orthe application program. It is provi...
3816 Jan 2007 @ 09:26 PSTConnectivityReplyBuffering in CLIIt depends on the Table and or Data. For example an Insert might omit some columns and therefore the Data Parcel size is less the max row size. Simplest approach is to calculate the max data parcel...
3715 Jan 2007 @ 11:25 PSTConnectivityReplyBuffering in CLII think REPEAT and PACK are BTEQ features.However, you have to add "PACK" concept to your application. That is decide what is the appropriate packing factor. A Request has a 1MB limit; this limit i...
3615 Jan 2007 @ 11:13 PSTConnectivityReplyvb.Net call to Teradata stored procedureTo change your default database DbCommand cmd = cn.CreateCommand(); cmd.CommandText = "Database DEV_DATA_V"; cmd.ExecuteNonQuery(); cmd.CommanText = "sp_MISRE_Pivot"; cmd.CommandType = Comman...
3512 Jan 2007 @ 12:53 PSTConnectivityReplyBuffering in CLITeradata supports Iterated Requests. This is equivalent to Parameter Array in ODBC.SQL Fundamentals has a section on Iterated Requests. BTEQ also supports Iterated Requests.Basically, application p...
3410 Jan 2007 @ 03:33 PSTConnectivityReplyvb.Net call to Teradata stored procedureRefer to DbParameterCollection Members for information on DbParameterCollection.DbParameterCollection class has one and only one Add method. It simply takes an Object.TdParameterCollection class ...
3309 Jan 2007 @ 01:45 PSTConnectivityReply.Net Data Provider for Tearadata connection problem>>>yes, I taste it with IP and Hostname, but the hostname have more than 8 charcters>>>(22 with domain). Let me see if I understand this correctly. You are using the same exact connection string wi...
3209 Jan 2007 @ 01:32 PSTConnectivityReply.Net Data Provider for Tearadata.NET Data Provider for Teradata system requirements states "Microsoft .NET Framework 2.0". You can use any tool/IDE as long it can load .NET Framework 2.0 assemblies and generate assemblies for .NE...
3109 Jan 2007 @ 01:10 PSTConnectivityReply.Net Data Provider for Tearadata connection problemDo you use the same Connection String in the development environment and in production (Server)?I saw the following line: TdConnection myCon = new TdConnection( "Data Source=IP-adress;User ...
3005 Jan 2007 @ 02:08 PSTConnectivityReplyAdd Teradata .net ADO reference to projectCorFlags.exe is a new utility in .NET Framework 2.0 SDK.It can be used as a dignostic tool; it displays the CLR Header version of the Assembly (.exe or .dll). CLR Header 2.0 indicates .NET Framewor...
2904 Jan 2007 @ 05:21 PSTConnectivityReplyAdd Teradata .net ADO reference to projectWill your application target .NET Framework 1.1 or .NET Framework 2.0?.NET Data Provider for Teradata requires .NET Framework 2.0. It implements abstract classes in System.Data.Common (e.g. DbConne...
2804 Jan 2007 @ 12:07 PSTConnectivityReplyAdd Teradata .net ADO reference to project.NET Data Provider for Teradata requires .NET Framework 2.0 and is certified with Visual Studio 2005. .NET Data Provider for Teradata is not a COM object and will not show up in the COM tab. It sho...
2703 Jan 2007 @ 12:48 PSTConnectivityReplyAdd Teradata .net ADO reference to projectIs you question in reference to the "OLE DB Provider for Teradata" (a.k.a. TDOLEDB)?The .NET Data Provider for Teradata (not TDOLEDB) installation adds a registry entry to \HKEY_LOCAL_MACHINE\SOFTW...
2613 Dec 2006 @ 01:13 PSTAnalyticsReplyNeed datatime informationTeradata has DATE, TIME, TIME WITH ZONE, TIMESTAMP and TIMESTAMP WITH ZONE data types. SQL Server DATETIME maps to Teradata TIMESTAMP data type.I suggest downloading SQL Reference: Data Types and ...
2530 Nov 2006 @ 07:28 PSTConnectivityReplyOLEDB Issues with SSISDid you download TTU8.1 WINDOWS i386 tdoledb.01.04.00.01?
2421 Nov 2006 @ 12:51 PSTConnectivityReplyQuery timeouts(30 Sec) when I use SQL Server 2005 Integration ServicesI think SSIS does not pass the CommandTimeout to the ".NET Data Provider for ODBC".I suggest opening an incident with Microsoft.You can verify that the .NET Data Provider for ODBC supports CommandT...
2320 Nov 2006 @ 02:30 PSTConnectivityReplyConnect to TeraDatabase using Teradata.Client.ProviderJohn,I read your post again. You wrote:"I deleted TeraSSO.Dll from the windows System32 directory my older existing working application based on Teradata ODBC/Microsoft OLEDB is now failing with a ...
2210 Nov 2006 @ 01:30 PSTConnectivityReplyBTEQ ConnectionHost file should have an entry like 100.1.2.3 fooCOP1 Then start BTEQ and type the .logon command as shown below. Note that the TDPID does not include COP1. .logon foo/UseridAlso, in BTEQ you can ...

Pages