Re: Getting General run Error while opening connection for teradata using UFT(error number :-2147467

That error number indicates that the ConnectionString is not valid. Try explicitly stating Provider=MSDASQL; at the beginning of the connection string (that's the ADO provider / bridge for ODBC). In 32-bit environments MSDASQL is the default, but I don't think 64-bit environments have a default.

Re: Getting General run Error while opening connection for teradata using UFT(error number :-2147467

For 64-bit Windows there should be a 64-bit test program tdxodbc.exe in \Program Files\Teradata\Client\vv.mm\bin folder and a 32-bit version in \Program Files (x86)\...

Open a command prompt corresponding to the same "bit-ness" as your UFT. Run the tdxodbc program and it should prompt you for DSN, UID, PWD values and then let you enter a SQL statement such as "SELECT * FROM DBC.DBCInfoV".

But if the error is still -2147467259 (x'80004005') then the failure most likely occurs before the Provider even attempts to invoke the ODBC driver. You'll probably need to get advice from someone who knows more about Microsoft ADO and/or the UFT tool.

Re: Getting General run Error while opening connection for teradata using UFT(error number :-2147467

You may need to get help from someone with more knowledge about Microsoft ADO or the UFT tool in particular. Microsoft's explanation for error -2147467259 implies that it has not even tried to invoke the TD ODBC driver yet.

To verify your ODBC setup:

There should be a tdxodbc.exe command-line test program in the \Program Files\Teradata\Client\xx.yy\bin folder. (For 64-bit systems, there should also be a 32-bit version in \Program Files (x86)\...) Execute that program and it will prompt for the DSN, Username, and Password. (The password will not display.)