1127 Feb 2009 @ 02:36 PSTConnectivityReplyWorking with BLOBs with ADO (VB)Correct your connection string to below.Driver=Teradata;DBCName=SERVER;Uid=USER;Pwd=PASS;Extended Properties=""USENATIVELOBSUPPORT=Yes;"";")
1023 Feb 2009 @ 11:19 PSTDatabaseReplyMS ACCESS CONNECTIVITY ISSUE TO TERADATA DATABASEIs it possible that your ODBC DSN for Teradata was configured with a tranlation dll? Check the ODBC DSN under advanced settings.
913 Feb 2009 @ 02:52 PSTConnectivityReplyProblem with data source using adhoc query tool on AIX- run adhoc under truss and see in the output what odbc.ini file is being opened.- export ODBCINI env. variable pointing to the right odbc.ini file.
804 Feb 2009 @ 09:29 PSTDatabaseReplyMultiload Accept Errordo you want to tryDELETE FROM TABLE B WHERE CURRENT_DATE<(&DELDTE - 10);or DELETE FROM TABLE B WHERE CURRENT_DATE<(&DELDTE.-10);
702 Feb 2009 @ 01:05 PSTToolsReplyodbc connectionNeed to see your connection-string. In otherwords, need to know how you are connecting.- is database up and running?- are you able to ping to the database from where your client application is run...
630 Jan 2009 @ 02:07 PSTToolsReplyodbc connectionWhat platform you are on? Is it an ODBC application? (or OLE-DB using ODBC or .NET using ODBC) Need additional information.
529 Jan 2009 @ 09:03 PSTToolsReplySQL Right Justify columnif i is the column,'"'||cast(i as int format 'zzzzz') || '"'
427 Jan 2009 @ 12:57 PSTConnectivityReply.NET and using ParametersI am not aware much .NET, but I believe you need to you use "?" as parameter marker
326 Jan 2009 @ 08:06 PSTToolsReplyconfiguring bteq access without /etc/hosts filesdo you have alias named xxxcop1?, if xxx is your host name.
222 Jan 2009 @ 02:36 PSTConnectivityReply.Net dealing with password expiration- run ODBC Driver in silent mode. Either check the DSN option "Run in Quiet Mode" or use "QUIETMODE=Yes;" in the connection-string. This prevents the dialog box to be displayed on the server, and...
108 Jan 2009 @ 03:26 PSTConnectivityReplyConnecting To Teradata using ODBC in .NETLook in ODBC Driver for Teradata User Guide http://www.info.teradata.com/eDownload.cfm?itemid=082330030In Chapter 4->ODBC Connection Functions->keywords for SQLDriverConnect() and SQLBrowseCo...