Hi All ,

I m trying to connect to TERADATA server from SSIS using .Net Providers\.Net data provider for TERADATA. After giving the server name and credentials i m getting the below error.    

Test connection failed because of an error in initializing the provider.[.Net data provider for teradata][100002] can not create the connection wiyhin the time specified.  

I have googled a lot but did not find any correct solution.I m struggling from last 2 days. Could you please help me in this.

I tried by changing the timeout property from default value 20 to 200 .After that i m getting the below error.

Test connection failed because of an error in initializing provide.[.NET Data Provider for Teradata][115025] Could not resolve Data Source=172.28.130.20 to an available node after 1 attempts.
[socket transport][10060] System.Net.Sockets.Socketexception(0x80004005):A connection attempt failed because the connected party did not properly respond after a period of time,or established connection failed because connected host failed to respond 172.28.130.20:1025 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) at Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List'1 sockets,UtlStopwatchWrapper timer,Int32 timeout,int32 IccTimeout.TdErrorCollection errors)

Please provide solution..

GTREddy

• Edited by Thiru G 12 minutes ago

Try adding an explicit ConnectionTimeout value to your connection string like:

<add key="teradataConString" value="Data Source=myDataSource;User ID=myUser;password=myPass;Max Pool Size=50;Connection Timeout=60;Persist Security Info=True"/>

This value is in seconds and the default is 20s. There is a possibility that you are not getting a new connection within 20s and 100002 is what you get in that case. Try setting it to a higher value and then measure the time it's taking for your to get the connection. 

the best case i see is 3- 5s for a new connection that is extending the pool. 

 https://forums.teradata.com/forum/general/issue-while-connecting-teradata-from-net

I tried as you said by changing the  Connection Timeout=200 but  after that i m getting the below error.

Test connection failed because of an error in initializing provider.[.NET Data Provider for Teradata][115025] Could not resolve Data Source=172.28.130.20 to an available node after 1 attempts.
[socket transport][10060]system.net.sockets.socketexception(0x80004005):A connection attempt failed because the connected party did not properly respond after a period of time,or established connection failed because connected host failed to respond 172.28.130.20:1025 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) at Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List'1 sockets,UtlStopwatchWrapper timer,Int32 timeout,int32 IccTimeout.TdErrorCollection errors)