Thursday, August 25, 2011

Web based SMS Sending Code in ASP.Net without using redirect method

Web based SMS Sending Code in ASP.Net without using redirect method

ASP.NET (vb)  code is given below:


Dim smsText As String
smsText = "YOUR SMS TEXT TO BE SEND"

Dim mobileNumber as string
mobileNumber = 9898989898

strURL = "http://URL_OF_SMS_GATEWAY/SendSMS.aspx?userid=YourUserId&Password=YourPassword&send=SenderCode&TargetMobileNumber=" & mobileNumber & "&SMSText=" & smsText

Dim myRequest As WebRequest = WebRequest.Create(strURL)

' Return the response

Dim myResponse As WebResponse = myRequest.GetResponse()

' Code to use the WebResponse goes here.
' Close the response to free resources.

myResponse.Close()


Wednesday, August 17, 2011

ERROR: MSDTC on server 'servername' is unavailable


ERROR: MSDTC on server 'servername' is unavailable.


MSDTC on server 'servername' is unavailable

By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions:

ERROR: MSDTC on server 'servername' is unavailable.

POSSIBLE SOLUTION : 

On the server where the trigger resides, you need to turn the MSDTC service on.
You can this by clicking

START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. 
Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.