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

Pasi Tyni 1 Reputation point
2022-04-27T06:46:11.23+00:00

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 ?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,996 Reputation points
    2022-05-03T01:55:40.027+00:00

    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.

    0 comments No comments