#DateForumTypeThreadPost
22120 Jan 2012 @ 06:08 PSTConnectivityReplyEntity Provider for Teradata Also refer to: http://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/StoreSchemaMappedToTables.html http://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/we...
22020 Jan 2012 @ 05:59 PSTConnectivityReplyEntity Provider for Teradata See http://developer.teradata.com/blog/dsakai/2011/04/specifying-views-in-the-entity-data-model-edm-wizard  
21918 Jan 2012 @ 10:58 PSTConnectivityReplyProblem executing .net batch program from server Most likely the "Data Source" (i.e. IDW) is not correct. Is th IP Address (i.e. 10.100.203.4) correct?  You said that it worked on your desktop. You can establish a ...
21812 Jan 2012 @ 12:41 PSTConnectivityReplyOdbcParameter TIMESTAMP in .Net C# problem Why do you convert the DateTime to String and then use ASCII encoding to Get the Bytes? This explains the error. If the ".NET Data Provider for ODBC" is anything like the ".NE...
21706 Jan 2012 @ 03:25 PSTConnectivityReplyteradata .net provider usage Copy and paste the sample from: http://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/DevelopingNetDataProviderforTeradataApplications.html Also you should always use the ...
21606 Jan 2012 @ 03:20 PSTConnectivityReplyJava and .net connectors for Teradata The .NET Data Provider for Teradata download: http://downloads.teradata.com/download/connectivity/dot-net-data-provider The .NET Data Provider for Teradata online Docs: http://deve...
21516 Dec 2011 @ 01:19 PSTConnectivityReplyTeradata Erro 8017 using SQL Assistant The Message manual has this explanation: Either the userid, password or account specified is not valid, or they are being used in an invalid manner or from an invalid location, and the ...
21415 Dec 2011 @ 01:09 PSTConnectivityReplySQL Server linked server to Teradata specifying authentication mechanism (LDAP) See my Blog: http://developer.teradata.com/blog/netfx/2011/12/setup-sql-server-2008-r2-linked-server-to-the-teradata-database  
21313 Dec 2011 @ 12:41 PSTDatabaseReplyStoring images/PDF/.. in BLOB See "Importing Data" section in the SQL Assistant Help File. SQLA supports ?B and ?C parameter markers for BLOB and CLOB import data. ?B - The data for this parameter resides i...
21213 Dec 2011 @ 12:29 PSTToolsReplyViewing Images in Teradata Sql Assistant SQL Assistant displays a "LOB Information" dialog box when query returns a BLOB column. Select "Display as picture in Answer set" option in the "LOB Information"&nb...
21109 Dec 2011 @ 12:42 PSTGeneralReplyInserts into table from .NET application See Batch Updates: http://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/AdapterBatchUpdate.html  
21029 Nov 2011 @ 11:40 PSTGeneralReplyStored Procedures - how to handle dynamic result set Did you try "WITH RETURN TO CLIENT" instead of "WITH RETURN ONLY" The documentation states: If you specify TO CLIENT, the result set is returned to the client applica...
20925 Nov 2011 @ 11:13 PSTConnectivityReplyErrors Installing Teradata SQL Assistant Two different issues: 1) Did you resolve the DNS issue? Try "nslookup cmsproda.cmssvc.local" and "nslookup cmsprodacop1.cmssvc.local"; at leaset one of the commands&n...
20817 Nov 2011 @ 07:03 PSTToolsReplySQL Assistant Setup You can use the "Show successful Queries only" option in the "History Filer" dialog box. 1- Right Click in the History Windows. 2- Select "Filter ..." 3...
20717 Nov 2011 @ 06:12 PSTConnectivityReplyTeradata Connectivity Using Windows PowerShell I forgot to mention that you can format the output; for example: 1- .\Invoke-SqlCommand 'Select * from DBC.Tables' $cred | format-Table -auto 2- .\Invoke-SqlCommand 'Select *...
20617 Nov 2011 @ 06:00 PSTConnectivityReplyTeradata Connectivity Using Windows PowerShell param(  [string] $sqlCommand = $(throw "Please specify a query."),         [System.Management.Automation.PsCredential] $credential,   ...
20514 Nov 2011 @ 12:05 PSTConnectivityReplyCalling Teradata sp from .Net The CommandText must be set to the Stored Procedure Name. The CommandType must be set to CommandType.StoredProcedure. You must use the same Session Mode. That is the Ses...
20414 Nov 2011 @ 11:42 PSTConnectivityReply.Net framework version 2.0 3.0 3.5 must be installed before installing .Net data provider for TD. Installation aborted. The .NET Data Provider for Teradata version 13.11 supports the .NET Framework 4.0. However the Installation part of the the Data Provider requires .NET Framework 2.0 SP2, 3.0 SP2 or 3....
20325 Oct 2011 @ 12:27 PDTConnectivityReplyInvalid date/time/timestamp error after upgrading Teradata drivers to 13.10 ODBC Driver has "DateTime Format" option; it controls the Session DateForm. Session DateForm can be set to ANSI or Integer. The Session DateForm impacts the implicit conversi...
20220 Oct 2011 @ 12:41 PDTConnectivityReplyTeradata OLE DB Provider 13.0 64 bit for Windows 2008 is not available Describe "NET ODBC for Teradata"; are you referring to the ".NET Data Provider for Teradata"? Anyway, you can use "Microsoft OLE DB Provider for ODBC" with the ...
20119 Sep 2011 @ 01:28 PDTConnectivityReplyEntity Provider for TeradataAre you having an issue with the Entity Data Model/Wizard? Visual Studio does not support Drag-and-Drop from the Server Explorer to EDMX; right-click on the EDM diagram and select "Update Model f...
20006 Sep 2011 @ 04:18 PDTConnectivityReplyOLEDB Authentication Connection String Attribute h) Open the file (x.udl) with notepad; you will see the complete Connection String.
19906 Sep 2011 @ 04:13 PDTConnectivityReplyName not in HOSTS file error - SASSearch for CLISPB.DAT file on your old PC and copy it to your new PC. CLI reads default configuration information from the CLISPB.data file when application does not specify them. I am guessing ...
19825 Aug 2011 @ 11:50 PDTConnectivityReplyProblem with teradata SQLA 13 'object reference not set'You will find additional information about this error in the SQLAError.txt. I recall at least one other post about a similar isse; see: http://forums.teradata.com/forum/tools/sqla-13-0-0-7-ter...
19705 Aug 2011 @ 06:35 PDTThird Party SoftwareReplyGeospatial data types in BI ToolsTeradata Geospatial types are converted into String. Currently the ADO.NET specification does not support Geospatial data types. ADO.NET or more specifically Entity-Framework will support Geosp...

Pages