.net代码在sql server中集成。 [英] .net code Integration in sql server.

问题描述

1）.i在.net中创建一个应用程序
2）.i为该应用程序创建一个程序集

3）.i创建一个存储过程来调用在.net

中的功能它工作正常两个月。之后我得到一个错误信息值.i更改sql server中的temp和tmp路径。从那时起我无法执行该过程。我重新创建组件，它给了我一个错误，记忆不是enougth.i也增加了数据库的大小。我认为创建成功，但这个错误即将到来当我执行程序。

SQL代码： -

1).i create a application in the .net
2).i create a assembly for that application
3).i create a stored procedure to call funcation in the .net
it is working fine for two month.after that i got an error info value .i change the temp and tmp path in sql server.from that time i cannot execute the procedure.i recreate the assembly it give me an error that memeory is not enougth.i increase the size of the database also.i think create successfully but this error is coming when i execute the procedure.
SQL CODE:-

USE [RMS]
GO
/****** Object:  StoredProcedure [dbo].[sendSMSLaneDomesticSMS]    Script Date: 8/6/2013 1:26:55 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[sendSMSLaneDomesticSMS]
    @number [nvarchar](200),
    @msg [nvarchar](max),
    @SMSError [nvarchar](max) OUTPUT
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [RMSDOTNET].[RMSDOTNET.RMSSMSClient].[sendSMSLaneDomesticSMS]
GO

错误

ERROR

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 209.105.227.19:80
   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, Int32 timeout, Exception& exception)
   --- End of inner exception stack trace ---
   at System.Net.HttpWebRequest.GetResponse()
   at RMSDOTNET.RMSSMSClient.SMSGetResponse(String SMS_URL)

推荐答案

linux server.the互联网的问题将来自linux服务器，它阻止了site.add的url到了在linux服务器上打开端口80.该问题将被重新载入

The problem with linux server.the internet will come from the linux server ,it is blocking the site.add the url to the in linux server and open the port 80.the issue will be resloved

这篇关于.net代码在sql server中集成。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！