VisualGSM Enterprise User Guide
Visualtron Software Corporation
100
MSSQL:
ORACLE:
VisualGSM Enterprise User Guide
Visualtron Software Corporation
101
5.2.7 The Service Manager displays “Access is denied”.
This means that the COM port is occupied by another
application or the COM port is faulty, or does not exist.
Simply disconnect the other application or switch off any
applications not used.
If the COM port is faulty, change the modem to use
another port. If the physical serial port exists, but is not
detected as a COM port, go to Control Panel
Port and
reassign the port. Sometimes restarting the server machine
will allow Windows to automatically detect and assign the
port.
5.2.8 The Service Manager displays “Cannot initialize
GSM/GPRS modem at COMx”
This will happen if the COM port is detected, but the server
cannot communicate with the modem. Check that the
modem is connected to the correct COM port used by the
server. That the modem is powered on, and the serial
cable is firmly attached to the serial port. The SIM card is in
working condition and properly placed in the modem. If
you are using a GSM/GPRS modem, check that the baud
rate defined in Console
Configuration is 19200 (9600 if
you are using a mobile phone with data cable/115200 if
you are using infrared to establish connection).
VisualGSM Enterprise User Guide
Visualtron Software Corporation
102
5.2.9 The Manager Console displays an error stating “Login
failed for user ‘sa’. Reason: Not associated with a trusted SQL
Server” during logon.
This error occurs if you try to connect to an MSSQL server
with the standard account such as 'sa', while the SQL
Server is configured as Windows authentication only. As we
know, if the server authenticates the connection with
Windows mode, you don't require input any login account
and password. It will utilize the integrated security, which is
authenticated through the account that you login on the
operating system.
If the 'SQL Server and Windows' authentication mode is
chosen, you can access the SQL Server with the integrated
security or by inputting the login account.
To change Authentication mode to ‘SQL Server and
Windows’, simply follow the steps -
VisualGSM Enterprise User Guide
Visualtron Software Corporation
103
a. Start SQL Server Enterprise Manager
b. Expand a server group.
c. Right-click a server containing VisualGSM, and then click
Properties.
d. On the Security tab, under Authentication, click ‘SQL
and Windows’.
VisualGSM Enterprise User Guide
Visualtron Software Corporation
104
5.3 HTTP/Web or ODBC/SQL
Interfacing with VisualGSM
5.3.1 How to interface with VisualGSM Enterprise to send SMS?
VisualGSM is a database application built for Enterprise
usage and the primary method of interfacing with the
server to Send SMS is to use SQL statements. To make life
easier for programmers and users a variety of middleware
applications are available to accept and submit Send SMS
requests to the database. Messages can be sent in
advanced or at a designated time and date.
The default installation will install a CGI - csend.exe, and an
ISAPI DLL (Internet Server Application Program Interface) –
csend.dll to your inetpub\wwwroot\cgi-bin (default
installation path). The CGI can be used on a variety of
web servers besides Window’s IIS (Internet Information
Server). The ISAPI DLL can only be used on IIS.
Visual Basic, Delphi, and Java Developers can make use of
ActiveX and Java components downloadable from
VisualGSM download site to make HTTP calls to the
CGI/ISAPI provided.
Both HTTP and direct database specifications are provided
in detail in the “HTTP and Direct Database Application
Interface Guide” PDF.
Users, administrators and developers that need to send
SMS quickly on an adhoc basis, can send their messages
using the “Send SMS Tab” on the Manager Console (See
section 4.2.5.9 - Send SMS Tab), or via web forms
accessible from START
Program
VisualGSM Enterprise
Server. (See next section).
csend.exe and csend.dll works by accepting SMS send
requests from web server, and then doing an SQL INSERT
into VisualGSM Enterprise database outbox.
VisualGSM Enterprise is also supported by add-on
interfaces such as Email-to-SMS, SMS-to-Fax, Text-to-SMS.
VisualGSM Enterprise User Guide
Visualtron Software Corporation
105
You can either custom build your own interface or order it
from Visualtron at a nominal fee.
5.3.2 I get an HTTP 500 Internal Server Error or no response
when using the web forms / csend.exe / csend.dll. I am using
IIS.
The web form, accessible via the explorer button on the
Manager Console, and from START
Programs
VisualGSM Enterprise Server
Web Send SMS (Simplified)
will post to either csend.exe or csend.dll. Both CGI,
csend.exe, and ISAPI DLL, csend.dll are installed by
default to inetpub/wwwroot/cgi-bin directory. Before
they can work, you need to ensure that cgi-bin is a virtual
directory under Internet Service Manager, and possesses
execution rights. If you are using the ASP scripts to send
your SMS, then the same applies to
inetpub/wwwroot/visualgsm directory.
The default installer will automatically try to configure your
virtual directories using VBS. VBS is disabled or not
available on some systems, and you will need to manually
configure the 2 virtual directories if you want to use
csend.exe/csend.dll/sample ASP scripts. Steps are follows.
Step 1 - Configure Directory Security for
inetpub\wwwroot\VisualGSM and CGI-BIN directory.
Start Internet Service Manager, and right mouse button
click on the VisualGSM folder, select property from the
popup menu.
The steps are as follows:
a) Go to the directory security tab.
b) Click on the Edit button of anonymous access and
authentication control.
c) In authentication method form, click edit button.
d) Assign a user to anonymous user.
Setup directory security:
VisualGSM Enterprise User Guide
Visualtron Software Corporation
106
a) Go to VisualGSM property form.
b) Go to directory security tab.
c) Create an application.
d) Assign "script and executable" permissions to this
application.
e) Click apply button and then ok button.
The same settings must be done for CGI-BIN folder. Last
stop and start the Web Server to activate the new
settings.
Step 2 - NTFS (APPLICABLE ONLY IF YOU ARE USING NTFS).
Method: Open Windows Explorer, right click on the folder
VisualGSM folder and select property. Then go to Security
tab.
The user who has been assigned to web site server
anonymous user (e.g. IUSR_USER) must be assigned read
permission to access this folder.
After read permission has been assigned to web site
server anonymous user, click ok button.
The same settings must be applied to CGI-BIN folder.
5.3.3 My program cannot send SMS using the ActiveX HTTP
and Java program example which I’ve downloaded from
your website.
Before you interface programmatically with the HTTP
listener, csend.exe or csend.dll, you will first need to
ensure it can work by testing using the Web Send
SMS(Simplified) form.
The web form, which is accessible via the explorer button
on the Manager Console, and from START
Programs
VisualGSM Enterprise Server
Web Send SMS (Simplified),
will post to either csend.exe or csend.dll.
Csend.exe and csend.dll can only work if the virtual
directory settings of CGI-BIN is correct. Please refer to
VisualGSM Enterprise User Guide
Visualtron Software Corporation
107
section 5.3.2 for more information.
If you subsequently receive SMS 0000x errors, please refer
to section 5.3.3.
5.3.4 I received an SMS 004 error when I tried to use the Web
Send SMS form.
Usage of the Web form will invoke csend.exe or csend.dll
(depending what you indicate in the HTML). The 2
programs will then do an SQL INSERT into the outbox of
VisualGSM Enterprise database. If the database
username and password set is incorrect, this process will
fail, resulting in SMS 0004 error, as shown in the example
below.
Thus, you will receive an SMS 0004 error if the database
user and password which you have set in Manager
Console, Console
Service Database Connection
Setting is different from the actual.
If you have changed the database username and
password, other than logging on to the Manager Console,
you will need to reset the Service Databaes Connection
Setting so that it will recreate a csend.dat file containing
the new connection informing (encrypted form).
Csend.exe and csend.dll will then read from this file when
processing your outgoing SMS.
copy and paste the error message onto your email along
with some simple description of the events leading to the
problem.
SMS 0004 - Message queue failure. Please check your VisualGSM
Server database.(MS SQL SERVER)
Error returned from ODBC function SQLDriverConnect (NoPrompt)
ODBC Return Code: -1: SQL_ERROR ODBC SqlState: 28000
Native Error Code: 18456 [Microsoft][ODBC SQL Server
Driver][SQL Server]Login failed for user 'sa'. Connection string:
DSN=VisualGSMODBC;UID=sa;PWD=***;
Debug info:Version: OPENODBC(DBEXPress)
VisualGSM Enterprise User Guide
Visualtron Software Corporation
108
path=c:\inetpub\wwwroot\cgi-bin\ File:c:\inetpub\wwwroot\cgi-
bin\csend.dat existed UserName=sa LengthOfPassword=7
databaseName=VGSMDBjoshua DriverName=MS SQL SERVER
DirverType=1 DatabaseServer=win2k before
ConnectionStirng=DriverName=openodbc
Database=VisualGSMODBC User_Name=sa Password=9819371
5.3.5 I received an SMS 006 - Fail to insert SMS record into
LOGLOG table.
There are many reasons for this error to occur, but if you
get a full message as shown below, mprobably the
default database configured for VisualGSMODBC DSN is
not VisualGSM database (default: VGSMDB). To resolve,
please reconfigure VisualGSMODBC.
”SMS 006 - Message queue failure. Please check your
VisualGSM Server database.(MS SQL SERVER).
…
Error returned from ODBC function SQLPrepare ODBC
Return Code: -1: SQL_ERROR ODBC SqlState: 42S02 Native
Error Code: 208 [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'LogLog'. ODBC SqlState:
42000 Native Error Code: 8180 [Microsoft][ODBC SQL
Server Driver][SQL Server]Statement(s) could not be
prepared………….”
