Web application is generating following error frequently: com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : HY000 206 : Failed to submit request - Connection is already closedRetrying this again in application does not give any error. Is there any possibility that connection pooling thread is closed by the database or by the application?Thanks.

i am new to teradata basically an oracle guy. i want to explore teradata by installing it on windows or linux. is there a place where we can download a stand alone version ? Please help.

Forgive me if I seem a bit ignorant, but a peer has left the team and I'm left trying to pick up the pieces. We recently updated our Teradata drivers, however, now when running the OLE Load module, I get the error message: Deprecated logons are not allowed by administrator. Upgrade client software to latest version. Did we miss a driver somewhere?

Hello!I have SQL query which contains {escape '\'} function.If I use only one {escape '\'} function all works fine and ResultSet is returned.But if I insert two or more {escape '\'} JDBC driver throws exception:java.sql.SQLException: [NCR][Teradata JDBC Driver]:Invalid parameter number: 3 at com.ncr.teradata.StatementParameters.verify(StatementParameters.java:493) at com.ncr.teradata.TeraPreparedStatement.setInt(TeraPreparedStatement.java:354)(This is PreparedStatement with 3 parameters and only 3 values was set.)I tried to run this query via SQL Assistant and query was execute without any problems.Is it problem with JDBC driver ?Can anybody help me?Thanks.

Hi Masters,I just want to know, whether there are any differences in Teradata SQL using JDBC driver.b'cause i have encountered some problems with JDBC driver.Thanks,Teradata Developer

What is the difference between odbc and jdbc drivers?is it just the application calling database ,

Hello. I am trying to upgrade a user's Teradata from 7.1 to 8.1 but the process stops b/c the (old/original) ODBC driver isn't completely removed. I believe that it has to do with the registry wasn't cleaned up in the removal process. We have searched all through the LocalKeys and everywhere and cannot find the ODBC driver anywhere, which leads us to the registry...Some forum users have mentioned that they have seen this happen before, and refer to some documents - but not how to find them, and I cannot find or get to these documents on how to clean up the registry myself, or how to proceed with completely removing the old ODBC.Can someone please help me? Thanks!!!

can anyone pls help me out in this subject.I have a requirement like i have to transfer a huge amount of data from SQL 2000 server to Teradata. I dont have much idea regarding this. Like if u guys tell me how i can achiev this, whether is there is any tool or simulator is there to do this or any other ways.Hoping for the genuine reply.regards,rakesh nc

I had the 1.1 .NET provider running and had SQL Server 2005 using a linked server with it. I upgraded to the 1.2 version and now everything works except the linked server. Any thought on what I need to do to get the linked server back? I have tried deleting it and recreating it, but no joy.R

Does anyone know which wide character functions are available within UDFs written in C?Also, does anyone know if there are variables passed that indicate the characterset of varchars passed to a function? Since characterset does not trigger function overrides, would be useful to have this information without the user being forced to pass it as a param.

Hi,is it possible to update a table while arcmain is backing up .can access locks be used

Hi,Was wondering if someone could explain the steps involved in creating a udf, I know a little c but i'm unsure of the steps on how to create one so Teradata recognizes it as a function. So i guess i'm looking for something on how to create one from step 1.ThanksMichael

Hi, I was trying to install an ODBC driver for Teradata so that I could use Access to connect to teradata server. I went to the website and downloaded the following file:TTU12.0 Windows-i386 tdodbc.12.00.00.00And installed it. After the installation, I found out that I don't have the teradata driver I wanted. And when I was comparing to another computer in which I have ODBC driver installed for teradata, I fould out there are a bunch of dll files I am missing. For example Tdata32.dll. And the installation process doesn't give me any error message. Did I just installed the wrong thing or not? That's the top result when I was choosing to download something for ODBC and Windows XP. Thanks a lot!

Hi, I was trying to install an ODBC driver for Teradata so that I could use Access to connect to teradata server. I went to the website and downloaded the following file:TTU12.0 Windows-i386 tdodbc.12.00.00.00And installed it. After the installation, I found out that I don't have the teradata driver I wanted. And when I was comparing to another computer in which I have ODBC driver installed for teradata, I fould out there are a bunch of dll files I am missing. For example Tdata32.dll. And the installation process doesn't give me any error message. Did I just installed the wrong thing or not? That's the top result when I was choosing to download something for ODBC and Windows XP. Thanks a lot!

is it possible to use UDF where code is kept on mainframe

I installed the is_integer() UDF from http://www.teradataforum.com/is_integer_01.htmby Dennis Calkinsthis function was installed on a database : dbudfdevand this is how we write our sqlsel dbudfdev.is_integer(col1)from devdata.table_nameon some big tables it is taking considerably more time to return the answer set.is there a way to improve the response time?Thanks for your help.

Hi Everyone,I'm trying to get UDF compilation up and running on the Teradata V2R6.1 Demo.I'm looking for some advice on how to best dig into this error: *** Failure 5656 Internal error in UDF/XSP/UDM/UDT compile task. Statement# 1, Info =0upon UDF compilation. I'm running the Teradata V2R6.1 Demo on Windows 2000. Does anyone know of a log file I can look at to find more information? Nothing comes up in the Windows Event Log ...Or, even better - has anyone written up a process on how to get UDF compilation set up on the demo? Or on a new Windows system?Just to let you know what I have done:* I've installed the Visual C++ 2005 Express Edition (VC8.0) and the Visual C++ Toolkit 2003 (VC7.1), and have tried both compilers by changing my 'cufconfig' and restarting the DBS.* I've created a 'tdatuser' and added members to the 'tdatudf' group. I was getting an event log message about the protected mode servers not being able to start - these messages stopped once I created a 'tdatuser' user.Here are my current 'cufconfig' settings. _______ | | | | ___ __ ____ | ____ __|__ ____ | / |/ \ ____| ____| ____| | ____| | --- | / | / | / | | / | | \___ | \____| \____| \____| |__ \____| Release V2R.06.01.01.17 Version 06.01.01.17 UDF GDO Configuration Utility (Mar 2005) Version: 4ModTime: 1186884370SWDistNodeID: 33SourceDirectoryPath: C:\Program Files\NCR\TDAT\tdconfig\Teradata\tdbs_udf\usr\CompilerTempDirectory: C:\Program Files\NCR\TDAT\tdconfig\UDFTemp\UDFLibraryPath: C:\Program Files\NCR\TDAT\tdconfig\udflib\CompilerPath: C:\Program Files\Microsoft Visual C++ Toolkit 2003\bin\cl.exeLinkerPath: C:\Program Files\Microsoft Visual C++ Toolkit 2003\bin\link.exe UDFServerMemPath: C:\Program Files\NCR\TDAT\tdconfig\udfsrv\MaximumCompilations: 10UDFServerTasks: 2SecureServerAMPs: 20ParallelUserServerAMPs: 2SecureServerPEs: 20ParallelUserServerPEs: 2TDSPLibBase: C:\Program Files\NCR\TDAT\tdconfig\tdsplib\SecureGroupMembership: tdatudfAny guesses anyone has would be appreciated. Thanks!

Is ODBC is an alternative way for CLI to connect the Teradata Server?

I'm looking for information of how to set up a Oracle heterogeneous service to connect to teradata. Please help.Thanks,Hoang

I have successfully configured a JDBC connection to Teradata using DbVisualizer (a great tool for browsing all kind of databases).I have used the following connection string:jdbc:teradata://142.122.133.12/DATABASE=SALESwhere SALES is correctly set as the default database.

Does anyone know how to reset the toolbar position on SQL Assistant? I accidentally moved Standard toolbar above the menu. When I move it back to the original position it does not stay there after restating the application.R

Hi ,I am working on setting up on User Login Security. What I am trying to do is to Restrict the IP addresses from which a users can log on. Please give me any pointers to implement such a requirement.

Hi,I need to know if there is any way I could execute a query from within a UDF. I would really appreciate if anyone could help me with this or definiteively say that it cannot be done.

I am connecting to Teradata from a 3rd party application using the Teradata ODBC driver.I am able to connect to Teradata and view a list of available tables and views. However, when I select a particular view I receive the following message, "Failed to retrieve fields from selected database. ODBC static cursors required for snapshot support."It seems that the problem occurrs while scrolling through the resultset. Is the type of cursor specified in the ODBC driver? I couldn't find a parameter in the ODBC Driver PDF document that seemed to set the cursor type from the ODBC Driver GUI.

Hi,i am using .net provider for Teradata 1.2.0.0 (also i tried version 1.1.0.0) with Visual Studio 2005 project.String sConnection = "Data Source=" + sDataSource + ";User ID=" + sUser + ";Password=" + sPassword;DbProviderFactory pf = DbProviderFactories.GetFactory("Teradata.Client.Provider");DbConnection con = pf.CreateConnection();con.ConnectionString = sConnection; con.Open();When i try to op