Click here to Skip to main content
15,894,106 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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:-
SQL
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)
Posted
Updated 6-Aug-13 20:23pm
v2

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900