550 - 600 of 897 tags for Connectivity

hi ,

I am new to Teradata. I am trying to connect to Teradata DB using teradata driver. i am getting Error in DriverManager.getConnection() Method. I am not able to understand why this is comming. I have tried with the latest driver avaliable in net for teradata.

String url="jdbc:teradata:///AMRROCD"
Class.forName("com.teradata.jdbc.TeraDriver");
Properties x = new Properties();
x.put("user","xxxx");
x.put("password","xxxx");
Connection con = DriverManager.getConnection (url, x);--> I am getting Null Pointer Exception at this line .

hi ,

I am new to Teradata. I am trying to connect to Teradata DB using teradata driver. i am getting Error in DriverManager.getConnection() Method. I am not able to understand why this is comming. I have tried with the latest driver avaliable in net for teradata.

String url="jdbc:teradata:///AMRROCD"
Class.forName("com.teradata.jdbc.TeraDriver");
Properties x = new Properties();
x.put("user","xxxx");
x.put("password","xxxx");
Connection con = DriverManager.getConnection (url, x);--> I am getting Null Pointer Exception at this line .

We would like to create internal incidents in our Incident Management system when Teradata errors occur - Those reported on the AWS today.

This process is in place for errors tracked by MOM/SCOM.

Is it possible to use MOM/SCOM to report the errors generated by Teradata? (Restart, Node down...)

Regards
Klaus.

Hi.

I'm from Teradata Japan.
I'd like to let you know about great library for Teradata-Ruby connection.

We have rocking programmer, he is one of the Ruby commiter, in our PS division and he made the library for Teradata-Ruby connection.

I have installed the icu libraries and GSS client succuessfully but i get the error:
Error 1720 There is a problem with the Windows installer package. A script required for this install could not be run.....Custom action uninstall_pre_version6432, script error 214682823

It works perfect with x86 odbc driver, but failed with x8664 odbc driver.

Does anyone has suggestion on this issue? I had installed tdicu, teragss and td odbc driver.

Error message is 'Specified driver could not be loaded due to system error 126 (Teradata)'

Hi,

I am using TD .NET provider 12.x and have stored procedures. All my SPs have IN & OUT parameters. In my understanding, TD has a strange way to returning the OUT params as a dataset & it works fine. When I have SP that delete records from a table, and also returns OUT params.

When I execute this Sp from .NET, I get a empty dataset (tables = 0). On checking the data, it actually deletes the data correctly. But how can I know that records are deleted? I don't want to unnecessarily check the data for delete confirmation.

any help is appreciated. Thanks.

SP Code:

Are there any restrictions using MERGE via ODBC? I have MERGE statement which returns an error:

"[NCR][ODBC Teradata Driver][Teradata Database] The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specfication primary index and partition column(s)."

I connect to Teradata using ODBC and I would like to create very simple stored procedure. When I call SQLPrepare I receive error "[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: Invalid SQL Statement.", but when I call the same CREATE PROCEDURE... statement using SQLExecDirect then it works.

Hi,

Can someone pls help with the following.

Teradata service control is not able to retrieve session info as part of the verification step mentioned in the getting started manual. I followed the below steps to install TDW 12.0 today first time on my laptop with WINDOWS XP.

1. Installed all softwares listed. Installation was successful except .NET Framework 2.0 SP1, which threw an error while installing it. Restarted the system.
2. started the Teradata DB initiator thru Services.msc.

Hi,

When I tried to install the Teradata ODBC Driver 13.0.0.2(64 Bit) in the Windows 2008 R2 and tried to run through the QlikView, Iam getting this error "Error: SQL Error:Specified driver could not be loaded due to system error 126: The specified module could not be found. (Teradata, C:\Program Files\Teradata\Client\13.0\ODBC Driver for Teradata\Lib\tdata32.dll)."

I found that the file is available in the specified location. Please clarify whether Teradata ODBC driver 64 bit is compatible with the windows 2008 R2.

The Release Note of "Teradata .NET Data Provider 13.01.00.01" says it support OSs below. Then it means this version will not support R2 editions?

Client Operating Systems:
Microsoft Windows 2000 SP4
Microsoft Windows XP Professional SP2 x86
Microsoft Windows Server 2003 x86
Microsoft Windows Server 2008 Standard x86 Edition
Microsoft Windows Server 2008 Enterprise x86 Edition
Microsoft Windows Vista Enterprise SP1 x86 Edition

Microsoft Windows XP Professional x64 Edition
Microsoft Windows Server 2003 x64 Edition
Microsoft Windows Server 2008 Standard x64 Edition

Hello,

I have an application in linux which needs connect to teradata database via iodbc driver manager. I downloaded the teradata odbc driver and I did a connection test with the iodbctest utility but I couldn't connect and I received an error message with non-printable characters.

Does anyone know where I can find the following info related to the JMS Adapter:
- How many customers do we have using it?
- Best practices or lessons learned?
Thanks!

Hi,

I am working in oracle Pl/Sql
I am new to teradata.
Two months back i did tera data V2R5 exams.
That means i have theoritical knowledge only.

In theory i read so many tools like BTEQ, CLI, etc

Can anyone guide me how i can start and on which tool?
I am in windows platform.

Thanks in advance.

Hi,

I need to provide default database name in the connection string to connnect using Teradata OLEDB provider in ASP.Net.

Currently I am using following String:

in web.config.

But the problem is when I connect using this , I always get connected to Default Database mentioned example say if I have Databases X,Y,Z on same box and X database is set as default I am getting connected to X only while I want to connect to Y database.

Has anyone successfully integrated the TD12 or TD13 .NET provider into VS2010 Beta? I realize it is not going to be supported as VS2010 is still in beta. I can use it, but I was hoping for a little tighter integration on par with VS2008.

R

Hello everybody

Here it is the problem :

I install
- the odbc drivers 12 install on solaris 10 (sparc)
- teradata 12
- unixODBC (2.2.14).

Hi,

I am trying to connect Teradata from Linux Red Hat ( LAMP-Installation ) via ODBC-Driver.
isql works fine, but i cant connect Teradata with PHP.

SQL error : SQl State in 00000 in SQLConnect ...

( Teradata ODBC Version 13.0 - Red Hat 4.0 )

Has anybody working a PHP/Teradata Connection and know a solution ?

Hi,
When i try to call the stored procedure "ACEREWARDS_CUSTOMERPREF(?)", it throws error "something missing between "(" and "?" ", i dont know what it exactly looking for. If i removed the "(?)", it throws "stored procedure does not exists.
I am using Terdata.Client.Provider 13.0 in C#.NET3.5.
Any suggestions.

Hi,I'm trying to install ODBC driver 12.0 on my Windows server. I installed the GSS and the shared libraries. When installing the ODBC driver, it stalled at deleting backup files for over 2 hours. So, I stopped it using task manager. I rebooted and retried the installation. I get the error that "The installation wizard was interrupted. No changes were made to the system. If you want to install this at a later time, please start the wizard again". I tried uninstalling the GSS and shared libraries, rebooted and then reinstall. Same error however many times I try. Please help. This worked on other servers, just this one server. Do I need to clear out registry entries? If so, could you please let me know how to do that and what I need to do?Thanks,VP

Does anyone know where I might find help for ALL the Input paramameters in the ODCB setup for Windows? The User help file I found for ODBC on the Teradata Support site just says "make editing changes". But doesn't say anything in detail about the different parameters, and there's a lot of them!

Hi all,I have installed Teradata Demo version 12.0 in my PC. While i compiled a simple stored procedure the following error was prompted.Error: C/C++ compiler is not installed.Does C/C++ compiler is required for running Stored Procedure?Where can i get this compiler and in which folder should i install in my PC.Thanks,TmrModest.

Dear users,Per recent communication, we are pleased to announce the consolidation/merger of the Teradata Discussion Forums and the Teradata Developer Exchange Forums. The integration of the forums will create a single location - http://forums.teradata.com - for you to participate in Teradata Forums to exchange ideas with your peers and to get access to important Teradata information.We expect the migration to occur on the weekend of February 20th, 2010.We will be migrating across all legacy forum content, and will migrate your user account as well. For users that do not already have an account on Teradata Developer Exchange ( http://developer.teradata.com ), we will create an account using your existing Teradata Forums details, and will generate a new temporary password for you. These new account details will be emailed to you.Please watch for additional notices that will provide information on timing, accessing and using your forum account. To read more about the consolidation visit: http://developer.teradata.com/blog/neilotoole/2010/02/teradata-forums-migration-imminentThank you for your patience during this process, and we look forward to seeing you on the new Teradata Forums.- The Teradata Forums team

Hi,I tried to connect Teradata 12 Database from Red Hat Enterprise Linux v5.2 64 bit. I have installed drivers in this sequence:tdicu__linux_indep.13.00.00.00TeraGSS__linux_i386.13.00.00.00-1tdodbc__linux_x64.13.00.00.02I have also installed but, when I try to connect to my DB i receive the error:Connect failed.Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM003:0: on HDBC] [DataDirect][ODBC lib] Specified driver could not be loadedMy odbc.ini is as follow:----------------------------[ODBC]InstallDir=/opt/teradata/client/ODBC_32/Trace=0TraceDll=/opt/teradata/client/ODBC_32/lib/odbctrac.soTraceFile=/MSTR/bin/odbctrace.outTraceAutoStop=0[ODBC Data Sources]default=tdata.sosvil=tdata.so[svil]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=[default]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=----------------------------My question is: is Teradata ODBC Driver ver.13 (I tried also with 12 and 8) supperted on a Red Hat Enterprise Linux 5.2 64 bit platform?Many thanks in advance.

Is their any free utility to compare tables/data of two different databases (sql server and teradata)?

i have windows server 2008 64 bit version and there i have installed teradata 13 driver. when I run select query the special characters is convert to some junk character but in other machine it works fine. do i have to do any settings on the server specific to language. please help.

This is the connection string an application using VB 6 uses to open a connection: "Driver={Teradata};DBCNAME=" & lsDB & ";UID=" & lsUID & ";pwd=" & lsPWord & ";DATAENCRYPTION=Y;"How do I open a DSNless connection for VB.NET?

I need to query on up to 10,000 different values :SELECT * from MYTABLE where COL1=? OR COL1=? OR COL1=? ...Is there a maximum number of parameters that can be passed, or a maximum length to the query string?Is there any configuration or tuning that might help that type of a query?I understand that I could obtain the same result with multiple query executions with fewer parameters, but the selection is on non-indexed columns therefore each query execution is going to require a full-table scan, so the less query executions the better.Thanks, - Mike

I migrated to Windows 7 64 bit, while every other piece of software works, Teradata doesnt. Its the CLI that doesnt install on Windows 7 no matter what compatibility mode i have it set to.Is Teradata aware of this and is there any solution ?Thanks.

Hi,We are currently working in host mainframe applications that runs on the Teradata database.We have a situation where some of the data are being encrypted in a Unix C application usnig RSA encryption.They also have the decryption routine and the key. Is it possible for us to call this RSA decryption routine in Teradata box.

Test Case:Table INDATA with two column X,Y. Create table OUTDATA with two columns S and D which are sum and difference of X and Y respectively.Using SLQ the problem can be solved easily as CREATE TABLE OUTDATA AS ( SELECT X+ Y AS S, X - Y AS D FROM INDATA ) WITH DATATable INDATA is populated with 100K rows for this experiment.On dual-core Vista laptop (Dell XPS) the SQL statement above takes 0.285 seconds to execute.Java Variable TABLE UDF can be used to do the same calculations. Java class has a function "evaluate" with two inputs and outputs (the complete code is attached);class Example { public static void calculate( double x, double y, double[] sum, double[] diff) { …. }}The SQL query with Java UDF is CREATE TABLE OUTDATA AS ( SELECT * FROM TABLE (evaluate(INDATA.X, INDATA.Y)) AS t ) WITH DATAOn the same hardware the query above takes 42 seconds, i.e. 150 times slower than SQL query without UDF.I tried to investigate further the performance bottleneck. It is not possible to connect java profiler tool to Teradata database so I had to resolve to crude System.nanoTimer() for performance measurements.Here is the summary of the results:Evaluate is called 400K +4 times. (two AMPs) 100K times is called with phase=TBL_INIT 100K times is called with phase=TBL_BUILD and actual row is calculated 100K times is called with phase=TBL_BUILD and SQL exception "02000" is thrown 100K times is called with phase=TBL_FINITime spent within each function400K constructor new Tbl() 4 sec400K getPhase() 6 sec200K tbl.getCtxObject/ tbl.setCtxObject 10 sec100K actual calculations <0.1 sec400K total time within evaluate 22 secTime spend outside of Java within Teradata itself 22 secAs you could see there is a huge overhead for EACH call. For the actual application I would have more input/outputs and 10 mln rows. Even if I assume that overhead does not increase with the number of parameters I would estimate that overhead would take more than one 1 hour on Vista. I have not run the experiments on the actual production Teradata yet. Here are my questions:1. Should I expect the same overhead on production Teradata (i.e. Teradata hardware), may be divided over the number of AMPs?2. Am I doing something wrong and is there a better approach to accomplish the same? 3. Does Teradata have any plans to address the performance bottleneck? Any recommendation how I can minimize the overhead?4. I noticed in the documentation that for C/C++ UDF you can run the functions INPROCESS. I did not find any such option for Java. Does it exist?

Hi all,According to install desc(http://www.presicient.com/tdatdbd/), I installed DBD-Teradata-Cli-12.001 to connect teradata.But it was failure. Could anyone help me to resolve ?Red Hat AS4Perl 5.8.8DBI-1.609Btw, I can connect teradata by using BTEQ in it.[int3336@cnsz040473 DBD-Teradata-Cli-12.001]$ perl Makefile.PL *** Configuring DBD::Teradata::Cli ...***************************************************************** !!!NOTE TO INSTALLERS!!!** DBD::Teradata::Cli will be built using the following* directives:* Libraries: -L/opt/teradata/client/lib -lcliv2 -lnet -lsocket -lresolv -ltdusr.so* Include files: -I/opt/teradata/client/include* Compile flags: -D__error_t_defined=1** If your CLI2 libraries and/or include files are in another* location, please update the TDAT_DBD_CLI_LIB and* TDAT_DBD_CLI_INC environment variables before running* Makefile.PL.****************************************************************Checking for DBI, 1.40 or later ... okNote (probably harmless): No library found for -lnetNote (probably harmless): No library found for -lsocketNote (probably harmless): No library found for -ltdusr.soThe following is for your reference.[int3336@cnsz040473 bin]$ envHOSTNAME=cnsz040473AUTO_DB=ETLTERM=xtermSHELL=/bin/bashHISTSIZE=1000SSH_CLIENT=10.13.50.50 2493 22OLDPWD=/wls/int3336/ETLSSH_TTY=/dev/pts/1USER=int3336LD_LIBRARY_PATH=/usr/odbc/drivers:/usr/odbc/lib:/opt/teradata/client/lib:/opt/te radata/tdicu/lib:/opt/teradata/teragss/redhatlinux-i386/12.00.02.35/libLS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;0 1:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31: *.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:* .bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;3 5:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:AUTO_HOME=/wls/int3336/ETLTMOUT=900MAIL=/var/spool/mail/int3336PATH=/usr/local/bin:/bin:/usr/bin:/wls/int3336/binTD_ICU_DATA=/opt/teradata/tdicu/libAUTO_SERVER=ETL1INPUTRC=/etc/inputrcPWD=/wls/int3336/ETL/binLANG=en_USAUTO_SERVER_IP=10.25.32.16COPLIB=/usr/libTDAT_DBD_CLI_LIB=/opt/teradata/client/libSHLVL=1HOME=/wls/int3336ODBCINI=/wls/int3336/.odbc.iniCOPERR=/usr/libLOGNAME=int3336SSH_CONNECTION=10.13.50.50 2493 10.25.32.16 22LESSOPEN=|/usr/bin/lesspipe.sh %sAUTO_DSN=etlcop1TDAT_DBD_CLI_INC=/opt/teradata/client/includeG_BROKEN_FILENAMES=1AUTO_AGENT_PORT=6346_=/bin/env[int3336@cnsz040473 bin]$ cd /opt/teradata/client/lib[int3336@cnsz040473 lib]$ lsclispb.dat errmsg.cat errmsg.txt libcliv2.so libpm.so libtdusr.so[int3336@cnsz040473 lib]$ cd /opt/teradata/teragss/redhatlinux-i386/12.00.02.35/ lib[int3336@cnsz040473 lib]$ lsjava libgssp2td1.so libldap.so libtdgss.so tcllibgssp2ldap.so libgssp2td2.so libloadtdgss.a libtdstcl.so[int3336@cnsz040473 lib]$ cd /opt/teradata/client/include[int3336@cnsz040473 include]$ lsbtnfyext.h coperr.h dbca2px.h dbcerr.h mldnfyxt.h parcel.h pmddamt.hcliv2if.h coptypes.h dbcarea.h dbchqep.h mosiif.h pmdcomt.h pmtypes.hThanks.Sky

Hi,We have teradata12 installed on my machine. I am trying to connect to teradata from a java application. When i try to connect through JDBC, i can connect. But when we try to connect using jndi, i am getting the error as:Error occured while trying to connect to the databaseInvalid JNDI connection stag : [Teradata JDBC Driver] [TeraJDBC 12.00.00.110] [Error 1000] [SQLState 08S01] Login failure for Connection to 10.20.26.212:1025 Wed Dec 02 16:31:58 GMT+05:30 2009 socket cid=5113f0 sess=0 java.net.UnknownHostException: 10.0.6.212:1025 at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)JNDI is defined as:stag/type=javax.sql.DataSourcestag/driver=com.teradata.jdbc.TeraDriverstag/url=jdbc:teradata://10.20.26.212:1025/dbcstag/user=abcstag/password=abc123Please let me know if i am missing any step.Regards,Rajiv Gupta

I am looking to write a simple UDF in Teradata 13 Express.This method will take in 2 parameters, both of these will be the type ST_Geometry.I am looking for a tutorial which will guide me through the following process:1. Obtaining the C/++ Headers for Teradata2. Writing the Source code (C/++)3. Compiling to what format?4.

I have installed the Teradata .NET driver 13.01 and have tested it using the NDQuery from a desktop machine. The connection to the server works and I am able to run queries also. But, I need to have the driver installed on a server grade machine, and on that machine, the NDQuery app times out and fails when I specify the same connection parameters. I am guessing that firewall is blocking some ports, but am not clear what ports need to be opened.Interestingly enough, there is also an ODBC client installed, which does allow the connection to go through successfully. I was told that the ODBC client communicates on port 1025 which is open for the machine. Does the .NET provider use a different port? Which port? Any other suggestions on what I may try to troubleshoot?Thanks.-vz

Hi all,I want to install teradata expression edition on my windows 7 machine. but it say windows does not support. so what should I do?please helpbig apple

Hi,I am trying to pull somedata from Teradata 12 by SSIS 2008 using .NET provider for Teradata 13...02 on 64Bit Windows Server.I can save and add connection managers (and also "Test Connection" was successful) but when i try to execute my package, it immediately fails by giving the error below:Here is the output window for SSIS Package:------------------------------------------------SSIS package "Import stores.dtsx" starting.Information: 0x4004300A at Stores, SSIS.Pipeline: Validation phase is beginning.Error: 0xC0047062 at Stores, ADO NET Source 1 [9891]: Teradata.Client.Provider.TdException: [.NET Data Provider for Teradata] [115009] Message truncation error, not all data was received. at Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes) at Teradata.Client.Provider.WpTcpTransport.Receive(Buffer buffer, Int32 timeout) at Teradata.Client.Provider.WpSession.Receive(Buffer buffer, Int32 timeout) at Teradata.Client.Provider.WpMessageManager.Receive(Int32 timeout) at Teradata.Client.Provider.WpLogonManager.Action() at Teradata.Client.Provider.WpSession.ManagerAction(WpMessageManager manager, Stopwatch watch, Int32 connectionTimeout) at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password) at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout) at Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout) at Teradata.Client.Provider.ConnectionPool.CreateConnection(UInt32 timeout) at Teradata.Client.Provider.ConnectionPool.GetConnectionFromPool(Object owningObject) at Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString connStr) at Teradata.Client.Provider.TdConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)Error: 0xC0047017 at Stores, SSIS.Pipeline: component "ADO NET Source 1" (9891) failed validation and returned error code 0x80004005.Error: 0xC004700C at Stores, SSIS.Pipeline: One or more component failed validation.Error: 0xC0024107 at Stores: There were errors during task validation.SSIS package "Import stores.dtsx" finished: Failure.The program '[6492] Import stores.dtsx: DTS' has exited with code 0 (0x0).----------------------------------------------------------Anyone has experienced an error like before? I would appreciate any help coz i could'nt find any documentation in Teradata site for this error explaination.Best RegardsOnur

I was given a stats TABLE UDF that worked great on V2R6.2 and it is not returning correct data for Version 12 and I am guessing it is due to the increased stats intervals changes for Version 12.

I need to install a Teradata ODBC driver to run on a Windows Server 2003 Datacenter Edition OS. Our Teradata databases are currently v12. I see Windows IA64 ODBC drivers on the downloads page, but they are in TTU 8 packages. Have all Teradata 64-bit drivers now been packaged together (no longer singling out Itanium 64-bit)?

Hi ,

I am calling teradata tables from JDBC .

I am able to access tables onl with the database_name.table_name .

select * from database_name.table_name ;

not able to access table directly .

But online examples , I have seen table names direclty using .Is there a way.

Hello:

I'm trying to add authenticatio to an OLEDB connction string. What is the correct format?

I'm looking for something like this possibly:

Authentication=ldap;Authentication Parameter=params;

Hello, I'm trying to locate any official or unofficial ODBC drivers to connect from OS X to Teradata. Can anybody point me in the right direction? Thanks, Stefan

Hello, I am creating a reporting application that requires me to connect to a Teradata DW. know on small queries it works great but when it comes to the larger ones is where i have the issues. I know the default is 30 Sec but nothing i do seems to fix the problem. I have tried the TDcommand.connection timeout but it doesn't seem to like me it say the connection does exist even though i just pull info from it on a small query here is a sample: Dim ds As System.Data.DataSet = New System.Data.DataSet Dim OConn As Teradata.Client.Provider.TdConnection = New TdConnection() Dim da As Teradata.Client.Provider.TdDataAdapter Dim sql1 As String = "select names from empolyees" OConn.ConnectionString = "Data Source=Teradatatest.net;User ID=123456;Password=teradata;" da = New Teradata.Client.Provider.TdDataAdapter(sql1, OConn) OConn.Open() Dim cmd As Teradata.Client.Provider.TdCommand = New Teradata.Client.Provider.TdCommand cmd.CommandTimeout = 0 <- errors here "Connection doesn't exist" da.Fill(ds) Me.GridView1.DataSource = ds Me.GridView1.DataBind()as you can see above i am running a query against the TDW and filling a DS which i attach to a Gridview so i can make sure its working. my questions are.1) what am i doing wrong above? 2) can i set the Teradata connection/query timeout another way? as i would rather create the dataset files in VS gui so i can attached to my control instead of coding everything.thanks,Matt

Hi,I have installed Teradata SQL Assistant client in Microsoft Windows server 2003 R2 Enterprise x64 Edition.When I am trying to connect through SQL Assistant it is giving the below error:160: Specified driver could not be loaded due to system error 193 (Teradata).Please help me to resolve this.Thanks in Advance,Santosh

Hi,I am exploring the various options to speed up the data loading to a Teradata database using JDBC Driver.from the description of SESSIONS parm, it looks like, it is applicable to only FastLoad and FastExport mode of operation.Is that interpretation correct?

Hi All,

Currently I'm trying to execute the sample code provided by Teradata 12 ODBC. When I execute the sample I'm getting below error message. I have installed Teradata 12 express on windows box and trying to establish the connection using ODBC code from Solaris 10. Also on the windows box I have added the Solaris IP address in the hosts file. Let me know if I'm missing any configuration settings or how to solve this issue.

-bash-3.00$ ./adhoc

Enter Data Source Name: mdowner
Enter userID:dbc
Enter password: dbc

Has anyone ever connected a Python based script to Teradata using the ODBC driver on Linux? We have a Sales Consultant trying to work with a prospect and getting seg faults while using the ODBC driver.
ODBC connect string for Teradata Express 12.0:
DRIVER={Teradata};DBCNAME=localhost;UID=dbc;PWD=dbc;QUIETMODE=YES;

We migrated to a new production Windows ETL server and a new ODBC version 3.01.00.06. There was no change to the d/bTeradata: V2R.05.01.02.43.We now have a job that is returning current_date in a different format and we do not understand why.Until today we could compare a date from a table to the current_date but now the log is showing a new format from the SQL statementCAST(Current_Date as CHAR(10)) AS Actual_DtLOG: Extracted Current_Dt:2009-09-14 Actual Date: 09/09/14 - Extracted Current_Dt Does NOT EQUAL Actual_DtWe run the select in SQL Assistant and see the same format as the script outputselect current_date returns 09/14/2009select current_date (format 'yyyy-mm-dd') returns 09/14/2009select CAST(Current_Date as CHAR(10)) AS Actual_Dt returns 09/09/14 What can we do to get the format to come back as 2009-09-14.

We have downloaded the help file from Teradata and all of the links in it are blank.

Does anyone have a valid HELP or documentation file for "Programming" not just installation for .net 12 or .net 13?

A link would work just as well.

Thank you