#DateForumTypeThreadPost
6111 Nov 2011 @ 11:16 PSTConnectivityReplyTeradata ODBC driver with Apache/PHP It looks you odbc.ini file pointing to 32-bit ODBC Driver where as PHP is 64-bit.  Update odbc.ini to point to 64-bit driver, usually it is /opt/teradata/client/ODBC_64/lib/tdata.so
6008 Aug 2011 @ 06:41 PDTConnectivityReply[Teradata][ODBC Teradata Driver] SQL request exceeds maximum allowed length of 1 MBYou have to reduce number of rows inserted in one SQLExecDirect() or SQLExecute() call. You do not have to commit after every call. For example, SQLSetConnectAttr(SQL_ATTR_AUTOCOMMIT, SQL_AUTO...
5903 Aug 2011 @ 11:46 PDTConnectivityReply[Teradata][ODBC Teradata Driver] SQL request exceeds maximum allowed length of 1 MBTeradata ODBC Driver returns this error if SQL request text combined with data for parameters(?s) exceeded the allowed limit of 1MB. - Make sure request text is not larger than 1MB in size. - I...
5819 Jul 2011 @ 12:35 PDTConnectivityReplyError: SQL Error:Specified driver could not be loaded due to system error- Make sure you have 13.10.0.x ICU & TeraGSS pkg. installed. - Make sure you have a ODBC DSN created using 64-bit ODBC Administrator. - If you have installed Teradata pkgs. while linked server is...
5723 Jun 2011 @ 05:32 PDTConnectivityReplyLaddered Concurrent Connect and round-robin DNS If DNS returns multiple IP-addresses(based on its defined round-robin scheme), the sequence of IP-addresses will be honored. i.e., LCC attempts the first connection on the first IP-address in th...
5603 May 2011 @ 03:58 PDTConnectivityReplyPerl DBI Driver for Teradata on Linuxhttp://search.cpan.org/~mjevans/DBD-ODBC-1.17/ http://downloads.teradata.com/download/connectivity/odbc-driver/linux DBD::OBDC module included in standard distributions is usually built again...
5519 Apr 2011 @ 02:17 PDTConnectivityReplyAccessing TD using MS Access/Excel - using ldap Before http://downloads.teradata.com/download page is updated with latest versions, you can download 12.0.0.14 from Teradata Software Server accessible via Teradata@your_service
5418 Apr 2011 @ 12:57 PDTConnectivityReplyAccessing TD using MS Access/Excel - using ldap Some of the connectivity problems with LDAP/connection-string were fixed in later ODBC Efixes. Please upgrade to latest ODBC driver, which is 12.0.0.14.
5311 Apr 2011 @ 11:42 PDTConnectivityReplyODBC via MS AccessODBC trace and ODBC driver DSN trace logs can give additional details on the problem. In ODBC DSN trace log, you can find which SQL request(built inside ODBC driver) generated this error. Plea...
5206 Apr 2011 @ 05:43 PDTConnectivityReplyUPGRADE 12 to 13strace is another tool which can give some additional information on the failure. strace -o <log file><executable>
5130 Mar 2011 @ 01:04 PDTConnectivityReplyUPGRADE 12 to 13 You can verify the reason for load failure, if you do ldd /usr/teragss/suselinux-x8664/client/lib/libtdgss.so
5024 Mar 2011 @ 03:16 PDTConnectivityReplyTeradata 13.1 ODBC driver installation on zLinuxSee the other thread http://forums.teradata.com/forum/connectivity/upgrade-12-to-13#comment-14658
4924 Mar 2011 @ 03:15 PDTConnectivityReplyUPGRADE 12 to 13- Install 13.0 Teradata ICU, TeraGSS and ODBC pkgs. in sequence. - set ODBCINI environment variable to point to your odbc.ini, for example, export ODBCINI=/opt/teradata/client/ODBC_64/odbc.ini ...
4823 Mar 2011 @ 04:08 PDTConnectivityReplyTeradata 13.1 ODBC driver installation on zLinuxcan you elaborate what you meant by "not sure, how to make the LD_LIBRARY_PATH work" ?
4723 Mar 2011 @ 03:54 PDTConnectivityReplyUPGRADE 12 to 13 What was the exact error ? Make sure, you have TTU13 TeraGSS and ICU installed.
4618 Mar 2011 @ 05:49 PDTConnectivityReplySQL 2005 64-bit - Teradata Linked server...not working Did you verify the view definition and match it with the SQL request? i.e., if the missing column indeed exist? You can do execute "show view PRD_edw_views.offg" from from SQLA or BTeq
4518 Mar 2011 @ 05:25 PDTConnectivityReplyTeradata ODBC-Connect from PHP (Linux Red Hat)See the other thread http://forums.teradata.com/forum/connectivity/teradata-odbc-driver-with-apachephp
4418 Mar 2011 @ 05:23 PDTConnectivityReplyTeradata DB connection using ODBC Thru IBM Information Server DataStagehow to connect from Linux command line to Teradata using ODBC drviers: - Install Teradata ICU, TeraGSS and ODBC pkgs. in sequence. - set ODBCINI environment variable to point to your odbc.ini, ...
4318 Mar 2011 @ 05:06 PDTConnectivityReplyConnecting from Linux PHP to Teradata using ODBC See the other thread http://forums.teradata.com/forum/connectivity/teradata-odbc-driver-with-apachephp
4218 Mar 2011 @ 05:03 PDTConnectivityReplyTeradata ODBC driver with Apache/PHP Here is some information, how to build/install/configure and when Apache executes PHP as CGI binary : --------------------------------------------------------------------------------------------...
4118 Nov 2010 @ 01:28 PSTConnectivityReplyODBC connection via Perl fails on autocommit on Can you post complete error message ? If you have a "default" DSN in odbc.ini file, try removing it.
4005 Nov 2010 @ 01:49 PDTConnectivityReplyDLL error: continue request submitted but no response to return It looks you need to engage Teradata Customer Support.
3902 Nov 2010 @ 05:01 PDTConnectivityReplyError while loggin in Teradata Demo version- Uninstall ODBC, ICU and TeraGSS. - Install ICU, TeraGSS, ODBC (in the order) of same TTU release.
3802 Nov 2010 @ 01:20 PDTConnectivityReplyODBC V13, 64bit on Linux failed to connect to Teradata V13 Express VM Use the template /opt/teradata/client/ODBC_64/odbc.ini. Modify this odbc.ini to point to your database and set this file to ODBCINI env. variable.
3702 Nov 2010 @ 01:08 PDTConnectivityReplyDLL error: continue request submitted but no response to return - on both the machines, ODBC DSN settings are the same? - on both machines, same database user-id was used? I mean to say, the expected result-set is same when you tried on both the machines? -...

Pages