SMS-it support forum    


Welcome to the SMS-it support forum.
Before entering a query/request please search the forum to see if someone else has asked the question before.
Please feel also free to respond to queries from other users if you have experienced the same type of problem and found a solution to it. 
Our support team will monitor this forum and endeavour to provide answers to the queries posted.
Please make sure to post your query to the right forum as there is a separate forum for each application provided by MAW Software.
Show messages for: Last 7 days Last 30 days All (Digest of all)

Back to the forum

On Tuesday , the 06.13.2006, MAW Support wrote at 22:35:21 :

>Send SMS using SQL Server 2000 and get return values

Hi

SMS-it will return 0 if the message was sent successfully or -1 otherwise.
You may check for this error code in your calling application.

IE when submitting through a BAT file:
>>>>>>>>>>>>>>>>>>>>>>>>
REM Run SMS-it
c:\sms-it\sms-it.exe SMST MAW "Hello world"

if not errorlevel 0 goto Fail
goto Success

:Fail
echo SMS-it sending failed.
goto Exit

:Success
echo SMS-it sending succeeded.
:Exit
>>>>>>>>>>>>>>>>>>>>>>>>


I am unfortunately not sure how to check the error code directly in SQL Server.
Alternatvely you may use this BAT file and write the error code into a file, which you then evaluate in SQL Server.

Rds
TL








Post reply:

Name:
E-Mail:
Subject:
Message:
SPAM code displayed
next to this:

CGIForum (C) Markus Triska

Home to