Home Product Download Purchase Credits Contact
  Download Instructions for SMS API for MSSQL

 

 


Download the File from :  http://www.mig.co.za/Installs/SMSService.zip

Instructions for the WEBSERVICE as follows :-

 

1.   Unzip the file ( RemoteSMSMSSQLInstaller.zip)

2.   In the Config Folder…. RUN THE Setup file.

3.   Then run the SETUP FILE in the Main folder.

4.   This will install two files on your Desktop… The SQL backup file and the Remote SMS ver 5 Config file.

5.   Restore the SQL database backup file  ( You will find it on your desktop called “Remotesms.bak” )

Restore to Database called “RemoteSMS”

This creates 3 Tables called… dbo.inbox , dbo.outbox and dbo.sent

 

Then , Double Click on the Configuration ICON on your Desktop ( Remote SMS V5 Config ) :-
     ( ps..If you do not have an account then you first need to be registered :-  
         click here :-   http://www.smsguys.co.za/newuser.aspx  )

        1.    UserName :  Your Username as registered
2.   Password :   Your password as registered
 
Click the TEST button… Should give you a “MIG WebService API reached and access granted” response

3.   On the Database Connectivity

…Fill in all details required for the MSSQL connection ( Where you just restored the above database )

4.   Check all connections.

5.   Save your settings.

6.   Then …  GO TO WINDOWS SERVICES… AND START THE SERVICE  ( MIG RemoteSMS v5 )

( The Program will now run as a Service and Start automatically if the Server is ever restarted without having to log on)

 

To Test the System:-

 

1.   Go to the SQL table called ..  dbo.outbox

2.   Simply populate the following 4 fields … 
  message_id .. ( Give this field your own id number  )
  recipient ….    ( Cell phone number  ie 0831234567 )

  Message….      ( The actual message.. Note , Maximum 160 characters
                             including spaces .. Also please NO ‘ single quotes allowed )
  isread ….        ( Set this value to 0 (zero)  )

Refresh the table

3.   To Check messages sent or any Replies received, simply look at the other two tables !!!

 

 

This System runs as a Service and will automatically start when your computer is reset.