Teradata connectivity using Teradata.Net.Data.Provider won't work with Visual Studio 2019

Question

Hi,

I have done Visual Studio 2019 SSAS tabular project to fetch data from Teradata using Teradata.Net.Data.Provider, using LDAP. I test the connection and test says success. After creating my sql select to fetch data the query is ending up in IDLE in Teradata server and I get an error saying ..

Failed to save modifications to the server. Error returned: '[.NET Data Provider for Teradata] [115025] Could not resolve Data Source=READATAIP to an available node after 2 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 has failed to respond READATAIP:443

at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult)

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List`1 sockets, UtlStopwatchWrapper timer, Int32 timeout, Int32 lccTimeout, Int32 maxConcurrentSockets, TdErrorCollection errors)

[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 has failed to respond READATAIP:1025

at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult)

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List`1 sockets, UtlStopwatchWrapper timer, Int32 timeout, Int32 lccTimeout, Int32 maxConcurrentSockets, TdErrorCollection errors)

[.NET Data Provider for Teradata] [100002] Cannot create connection within the time specified.. The exception was raised by the IDbConnection interface.

A connection could not be made to the data source with the Name of 'Teradata'.

I also tried connection using Teradata . NET driver using Teradata SQL Assistant and passing same sql query and that works in same machine ... same connection settings than Visual Studio 2019 fails ....

Anybody any ideas ?

Answer 1

Hi @Pasi Tyni ,

It might be an issue of Visual Studio 2019, can you please try to uninstall Visual Studio 2019, and reinstall Visual Studio 2017 to see if it can resolve this issue.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.