尝试翻译时出现连接错误 [英] Getting connectivity error when trying to translate

问题描述

尝试通过SQL Server 2008连接到MS转换器时出现以下错误：

" Msg 6522，Level 16，State 1，Procedure spCallTranslator，Line 0

执行期间发生.NET Framework错误用户定义的例程或聚合"spCallTranslator"：

System.Net.WebException：无法连接到远程服务器---> System.Net.Sockets.SocketException：连接尝试失败，因为连接方在一段时间后没有正确响应
，或者由于连接主机无法响应而建立连接失败70.37.92.127:443

System.Net.Sockets.SocketException：

    at System.Net .Sockets.Socket.DoConnect（EndPoint endPointSnapshot，SocketAddress socketAddress）

   at System.Net.ServicePoint.ConnectSocketInternal（Boolean connectFailure，Socket s4，Socket s6，Socket& socket，IPAddress& address，ConnectSocketState state，IAsyncResult
asyncResult，Exception& exception）

System.Net.WebException：

    at System.Net.HttpWebRequest.GetRequestStream（TransportContext& context） ）

  在System.Net.HttpWebRequest.GetRequestStream（）

  在StoredProcedures.GetAccessToken（）

   ; at StoredProcedures.CallTranslator（String txtToTranslate，String txtTranslationFromLanguageCode，String txtTranslationToLanguageCode）

   at StoredProcedures.spCallTranslator（String txtToTranslate，String txtTranslationFromLanguageCode，String txtTranslationToLanguageCode，String& txtTranslated） "

问候，

Nilesh G

解决方案

Hi Nilesh，

IP地址70.37.92.127不是Microsoft Translator的终点。您确定从SQL服务器到https://api.microsofttranslator.com的出站连接吗？

之前是否有效，或者您是否正在开发sp new？

Chris Wendt

Microsoft翻译

Hi,

I am getting the below error when trying to connect to the MS translator via SQL server 2008:

"Msg 6522, Level 16, State 1, Procedure spCallTranslator, Line 0

A .NET Framework error occurred during execution of user-defined routine or aggregate "spCallTranslator":

System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: 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 70.37.92.127:443

System.Net.Sockets.SocketException:

   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)

System.Net.WebException:

   at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)

   at System.Net.HttpWebRequest.GetRequestStream()

   at StoredProcedures.GetAccessToken()

   at StoredProcedures.CallTranslator(String txtToTranslate, String txtTranslationFromLanguageCode, String txtTranslationToLanguageCode)

   at StoredProcedures.spCallTranslator(String txtToTranslate, String txtTranslationFromLanguageCode, String txtTranslationToLanguageCode, String& txtTranslated)"

Regards,

Nilesh G

解决方案

Hi Nilesh,

The IP address 70.37.92.127 is not a Microsoft Translator end point. Are you sure you have outbound connectivity to https://api.microsofttranslator.com from your SQL server?

Did this work before, or are you developing the sp new?

Chris Wendt
Microsoft Translator

这篇关于尝试翻译时出现连接错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！