All Forums Tools
renu.l.b 3 posts Joined 03/10
28 Feb 2014
Issue with SQL assistant

I have installed TD 13 demo version on my machine. When I run teradata service control, I get the expected status message "Teradata is running". When I connect to databse using BTEQ, I am able to connect successfully and run queries. However, when I try to run SQL assistant, the connection times out and PDE state changes to RESET/PDEDUMP. If I try to log in next time I get the error message "Teradata sever can't be reached over the network". Could you please suggest me solution for this? Thank you in advance.

wmmiteff 20 posts Joined 02/11
28 Feb 2014

Try adjusting the connection timeout parameter on your connection and try setting a value for the Data Source DNS Entries property.  For ODBC these are found in options then advanceds on the DSN.  For connections these are found in the advanced tab.
For the connection timeout I have found 60 works good and for Data Source DNS Entries i would try 1 or 2.

You must sign in to leave a comment.