Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Connecting to a Remote SQL Server
sp_NewPost Add Reply sp_NewTopic Add Topic
October 13, 2014
10:36 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

SMS messages that are sent from a mobile phone or a GSM modem always have the phone number of the SIM card as the sender address.

If you want to send messages with a custom (alphanumeric) sender address then you have to send them with an SMS service provider like Clickatell or an SMS service provider that supports the SMPP protocol.

Regards, Henk

October 10, 2014
5:12 pm
Dhiruj Rambaran
Guest
Guests

Ah all right!@re: Android 4.4 and above. In that case I'll do that. I have another question. What must I do to have my customer receive my text, with my company name displayed (rather than just display my phone number)? I've received some texts from marketers like this. I'm sorry for the ignorant question but I'm really new with all this. Thank you most kindly, Dhiruj

October 10, 2014
1:31 pm
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

I suspect the problem is not that Diafaan SMS Server does not check the messages anymore but that the Android GSM Modem Emulator app does not receive (some) incoming messages from Android.

In Android versions before 4.4, incoming messages are delivered to all the SMS apps one by one. However it is possible that one of the SMS apps blocks (some of) the message so that it is not received by other apps. If that is the case in your Android phone, there is not much you can do about it. If you have installed alternative SMS apps, other than the default Android messaging app, removing them might solve the problem. You should also check whether the option 'Store received messages' in the Android GSM Modem Emulator app is enabled. When this option is set, the Android GSM Modem Emulator app stores all incoming messages, even when the app is not active when the message is received.

In Android 4.4 and higher, the support for multiple SMS apps is improved and all SMS apps should receive all incoming messages. It is also possible to set the Android GSM Modem Emulator app as the default messaging app in Android 4.4. This is a good option if the Android phone is only used with Diafaan SMS Server.

Regards, Henk

October 10, 2014
8:17 am
Dhiruj Rambaran
Guest
Guests

Dear Sir,

I'm so sorry for late reply, but I thought my question was ignored and it's only now that I've come back to the forum and notice your reply! To answer your question unfortunately I did not check the event log. In the end I am, instead, using SQL Server Express on my local machine. I have connected gateway to Android 4.2.2 on a cheap phone. All in all I am very happy with the whole setup. I've been testing a number of days now. However I have been noticing (sometimes) when someone sends a text message to me, it gets completely lost!

My local network (in my office) is not that great but SMS messaging in my country is quite reliable. If I opt to store the message on my mobile (through your app), it stores it.. meaning I do get messages. However it seems the SQL connector/Diafaan PC software does not do a "check" on the mobile thereafter.

I guess what i'm asking is.. is there some sort of 'synchronising feature' where all messages which happen to get to the mobile phone, is then sent to the my SMSserver once a connection is established between my mobile and PC? (both mobile and PC is located on same wi-fi network in the same office). I will check this forum more often now seeing you do reply to queries :)

October 1, 2014
1:43 pm
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Dhiruj Rambaran,

The SQL Connector in Diafaan SMS Server can work with a remote database but in my experience, the Internet connection between the database server and the local server must be very fast and reliable. Otherwise you will probably see a lot of database errors.

There is not much difference between Microsoft SQL Server and Microsoft SQL Server Express, both versions should work OK.

If the SQL Connector does not pick up the messages from the 'MessageOut' table of the remote database, there are probably errors in the event log of the SQL Connector. Do you see any database errors in the event log?

Regards, Henk

October 1, 2014
2:21 am
Dhiruj Rambaran
Guest
Guests

ps: I forgot to add that my remote MS SQL Server is not an express version. However your software recognises it fine.

October 1, 2014
2:19 am
Dhiruj Rambaran
Guest
Guests

Dear Sir,

I have downloaded your lite version for testing purposes and I congratulate you for a fantastic product. It's the exact solution for us!

My question is this... I am uaing the SQL Connector to connect to a MS SQL Express Database on my local machine, using Android as my gateway. Everything works absolutely fine. However, my real server is a remote one located in USA (my local machine is based in Mauritius). I have managed to connect (via the SQL Connector) to my remote SQL Server in USA (via IP Address) and the server and all tables (messageout etc) has been recognised by your software. However when I insert a record into the MessageOut table, no message is sent from my android. Am I missing something important here?

Thank you

Dhiruj

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488