How to Set-Up MOBITEK S80 SMS Modem with WinPower UPS software

Applies to:

MOBITEK® S80 for SMS Over 3G Network

STEPS

  1. Connect your laptop/desktop to UPS and MOBITEK S80 Modem to laptop/desktop. Open Winpower UPS software. Go to System menu -> Act as Administrator and enter the password. The default password is “Administrator“. This step is important in order to configure Winpower software setting.

    To change the administrator password (optional), go to System menu -> Modify Administrator Password and enter the new password for administrator.
  2. Go to System menu -> Auto Search Device to search for UPS device automatically.

    Wait for the UPS to be searched.

    When found, the UPS device will be shown in the list. Double-click on it to see the UPS device status.
  3. Go to Tools menu -> SMS Setting to configure the SMS notification for UPS events.
  4. In SMS Setting, set the Com Port for MOBITEK S80 Modem, the Baud Rate to “115200“, and the Format of phone number to “Without National Code“. Enter the phone number for the notification to be sent, click Add button and select the phone number in the list. After that select the abnormal event in the event list that you want to be notified for. Click Test button to test the SMS sent successfully or not. If successful, click OK button.

VB.Net MS SQL Connection String to Handle Windows Authentication and SQL Connection

The VB.Net code should be as follows:-

MSConn = New SqlConnection()
If sAUTHMODE = "WIN" Then
    MSConn.ConnectionString = "Data Source=" & sSERVER & ";Initial Catalog=" & sDATABASENAME & ";User ID=" & sUSERNAME & ";Password=" & sPASSWORD & ";Integrated Security=True" 
ElseIf sAUTHMODE = "SQL" Then
    MSConn.ConnectionString = "Data Source=" & sSERVER & ";Initial Catalog=" & sDATABASENAME & ";User ID=" & sUSERNAME & ";Password=" & sPASSWORD & ";Integrated Security=False"
End If

Otherwise, one of these error messages will appear:-

  • Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
  • Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Own a SMS Gateway that You Can Fulfil Data Privacy and Data Protection

Instead of using 3rd party SMS service provider, you can own a SMS Gateway that can fulfil data privacy and data protection requirements for your Walnut Wellness.

Here is a case study where a wellness solution, MySalam, have their own SMS Gateway — MobiGATE.

MySalam (https://www.mysalam.com.my/b40/info/?url=intro_EN) is national health protection scheme offered by Malaysia government.

MySalam is using MOBITEK®  MobiGATETM as the SMS Gateway to:-

  • send out notification to applicants who are qualified for the scheme;
  • send out claims notices to insured parties on claim status

 

CASE STUDY

  • MySalam.com.my web portal, is hosted in a data centre in Puchong, Malayisa while MOBITEK®  MobiGATETM is located in Micare’s data centre in Shah Alam.
  • Advantages:-
    • MobiGATE can be placed anywhere, co-location or on separate location with the application server;
    • there are no internet connection to MOBITEK System therefore, all messages sent and received are protected and kept private by Micare; and
    • MobiGATE uses SIM card, support up to 8 SIM cards per unit, with SIM card, the SMS Gateway is directly connected with TELCO via GSM or 3G network without relying on internet.

For more information on MOBITEK®  MobiGATETM , visit its product page or contact us.

How to Disable Just-In-Time Debugger

If you received this error message

“Just-In-Time debugging this exception failed with the following error: No installed debugger has Just-In-Time debugging enabled. In Visual Studio, Just-In-Time debugging can be enabled from Tools/Options/Debugging/Just-In-Time.

Check the documentation index for ‘Just-in-time debugging, errors’ for more information.”

Solution is available at https://docs.microsoft.com/en-us/visualstudio/debugger/debug-using-the-just-in-time-debugger?view=vs-2019

MobiGATE is the SMS Gateway for HRWeb.ph

HRweb.ph is a web based Payroll, HRIS, Timekeeping & Solution developed by Sert Technology from the Philippines.

 

MOBITEK® MobiGATE SMS Gateway

HRWeb.ph is using MOBITEK®  MobiGATETM as the SMS Gateway to send out notifications.

 

CASE STUDY

  • HRWeb, web portal, is hosted in a data centre in Singapore, while MOBITEK®  MobiGATETM is located in Sert Technology’s office in Cavite, Philippines.
  • Advantages:-
    • MobiGATE can be placed anywhere on the internet, whether in the data centre, Singapore or in Cavite, Philippines;
    • there are no internet connection to MOBITEK System therefore, all messages sent and received are protected and kept private by Sert Technology; and
    • MobiGATE uses SIM card, support up to 8 SIM cards per unit, with SIM card, the SMS Gateway is directly connected with TELCO via GSM or 3G network without relying on internet.

For more information on MOBITEK®  MobiGATETM , visit its product page.

 

 

How to Solve “You do not have permission to use the bulk load statement”

Applies to: MS SQL Express 2017

Error Message: You do not have permission to use the bulk load statement

Solution: SQL Management Studio (log in as administrator) → Security → Login → Choose username (right-click) → Properties → Server Roles → Check “bulkadmin”

(source: http://stackoverflow.com/questions/32417776/you-do-not-have-permission-to-use-the-bulk-load-statement-error )