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
SQL Connector
sp_NewPost Add Reply sp_NewTopic Add Topic
April 30, 2012
12:20 pm
Henk Helmantel
Guest
Guests

Diafaan SMS Server runs as a Windows service under a Local System Account, this account can only access a System DSN and not the User DSN's. If the DSN is added to your User DSN list, Diafaan SMS Server is not able to find it and I think this might be the problem.

To add a System DSN, select the System-DSN tab page in the ODBC manager (you might need administrator credentials to change the System-DSN list).

Regards, Henk

April 30, 2012
9:43 am
Arif
Guest
Guests

Henk Helmantel said:

A connection string for a DSN is very simple, e.g. "DSN=MySQL".

Adding a DSN manually might also give a better error message than "Data source name not found and no default driver specified".

Regards, Henk

Hi Henk ,
I did what you said. When i was creating a DSN, i tested the connection which was successful. I added the connection string "DSM=mysqldiafaan;" in sql connector wizard and i tested . Again , it was failed. Still i found no solution to this.

The ODBC manager said the connection was successful while diafaan said database test failed . I could not figure out what was going on.
Logged details :
DSN=mysqldiafaan;

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

April 26, 2012
6:23 pm
Henk Helmantel
Guest
Guests

Hi Arif,

This error indicates that there is probably something wrong with the MySQL ODBC driver installation or with the connection string you use. You can try adding a Data Source Name (DSN) to the Windows ODBC Manager and use that in your connection string. A connection string for a DSN is very simple, e.g. "DSN=MySQL".

Adding a DSN manually might also give a better error message than "Data source name not found and no default driver specified".

Regards, Henk

April 26, 2012
5:24 pm
Arif
Guest
Guests

Hi Henk , I am evaluating the trial version of diafaan sms server . I got stuck up with a problem when i was trying to connect to the database(mysql). After installing mysql odbc driver , i tried to create a sql connector by following connection string :
Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=smsserver; User=root;Password=;Option=3;
(it does not use password)

When i clicked the TEST button , it says "Database test failed" .

Logged details are :

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=smsserver; User=root;Password=;Option=3;

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I do not know how to configure it with my database. I need quick solution. Please help me to fix it . Thanks in advance.

November 4, 2011
11:27 pm
Mike Ayuso
Guest
Guests

Hi Hank,

All works great now. I have all the loose ends sorted out and have made my presentation to my team. We will be reviewing next couple days before we make the purchase.

November 1, 2011
4:39 pm
Henk Helmantel
Guest
Guests

The names and groups are stored in an SQLite database named WebConnector.sqlite. Every Web Connector has it's own database file that is stored under the folder:
%ProgramData%\Diafaan\Diafaan Message Server\ModuleData\

It is probably best to make a backup of this file before you change it. If something goes wrong, you can restore the WebConnector.sqlite file and restart the Web Connector to reload it.

Regards, Henk

November 1, 2011
4:10 pm
Mike Ayuso
Guest
Guests

What database does the application use. Perhaps I can wrote a small application to populate this for me?

November 1, 2011
3:34 pm
Henk Helmantel
Guest
Guests

The current version of Diafaan SMS Server does not have an import feature for the name- and group lists. It is on the wish list for a future version but at the moment it is not possible to import names and numbers.

Regards, Henk

November 1, 2011
1:39 am
Mike Ayuso
Guest
Guests

Sorry I lost my last question I posted. Will try to requestion.

Populating the messageout table from another source, it sends out the SMS messages fine, so this will work for me. Many thanks.

Since the server does not have any import facility, would I be able to utilize the Scripting Connector to write routines to import data into my contacts list, or would there be another way of doing this. I have about 1500 contacts that I want to put in my contacts and groups.

Regards, Mike

October 28, 2011
9:48 am
Henk Helmantel
Guest
Guests

Hi Mike,

Reply to user means that when an SMS message is received, it is sent to the inbox of the last user that previously sent a message to that number. The result is that users receive the replies of SMS messages in their own inbox. The SMS system does not provide a reliable way to detect replies, so it is not a foolproof solution.

Diafaan SMS Server does not have a direct text file import feature. It is possible to use the Scripting Connector to implement this feature, but that of course requires some programming.

Regards, Henk

October 27, 2011
10:59 pm
Mike Ayuso
Guest
Guests

Hi Hunk,

This all works as you described so well. Many thanks. It would have been nice to see the messages from other connectors such as SQL connector and E-Mail. Eg. I tested sending SMS messages out by adding some records in the mseeageout table from my SQL database and the SMS messages were successfully sent out but there is no way to see these messages in the ARCHIVE Sent Log within the web. I can only see these outgoing messages in the logs within the server only.

2 questions:
1. Under the Web Connector properties, under Receive SMS Tab, what is "Reply to user..." check mark used for?
2. I am trying to figure out a way to upload a text file, comma delimited, or even an Excel file so that I can send out text messages in bulk or in a batch mode. The only thing I can see is if I would write an application that would upload records in the MESSAGEOUT table. Other than that I cannot see anywhere else. Would this be a correct assumption?

Many thanks, Mike

October 27, 2011
9:59 pm
Henk Helmantel
Guest
Guests

A user in the web application of the Web Connector can only see the messages sent by the user, not messages sent by other users (or other connectors).
By default, users other than admin cannot see received messages. You can enable showing received messages in the Inbox of the user when you create a new user or edit an existing user. Just click on Handle received messages and enable Move received SMS messages to inbox.

When you want multiple users to see each other's messages, you can enable the Allow concurrent logins with the same user name and password option in the User privileges page of the Web Connector. Different people can then log on with the same user name and password and see each other's messages.

Regards, Henk

October 27, 2011
8:47 pm
Mike Ayuso
Guest
Guests

Hi Henk,

Many thanks. After creating the tables manually, and having the problem still, I deleted the SQL connector and recreated it and it worked fine. Many thanks.

On another note, from the built in Web interface, I am having difficulty with users other than "admin" for they cannot view any incoming and outgoing SMS messages. For some reason, they can only see SMS messages that they send. I've played with the settings within the server, but can't find anything.

October 27, 2011
10:51 am
Henk Helmantel
Guest
Guests

Hi Mike,

Microsoft SQL Server 2000 does not support the nvarchar(max) data type, for Microsoft SQL Server 2000 it is necessary to create the database tables manually using the SQL CREATE TABLE command in the SQL Server Enterprise Manager, changing nvarchar(max) to nvarchar(1000).

I did a quick test of Diafaan SMS Server with Microsoft SQL Server 2000 and apart from the nvarchar(max) data type everything else seems to work fine. The problem you encounter (Line 1: Incorrect syntax near ",".) could be an indication that is an inconsistency in the database table definitions with the database table properties of the SQL Connector.

For a quick fix you might try the following steps:
- Remove the SQL Connector from Diafaan SMS Server
- Add a new SQL Connector
- On the Create Database page click "Create database" and ignore the errors
- Click "Test" to test if the required database tables are available in the database
- Finish the SQL Connector Wizard setup

Regards, Henk

October 26, 2011
10:10 pm
Mike Ayuso
Guest
Guests

I have been sending and receiving sms using Web Connector and E-Mail Connector with no problems. I am now trying to setup an SQL Connector and having problems.

I am using Microsoft SQL Server 2000. From "Add SQL Connector" Screen I enter the name of the server. I use specific SA user with password and select the SMSServer database. I select the TEST button and it says successful. I select Next to create the database, but had some problems with the creation, so I created the database manually by tweaking the command to create the tables and fields and indexes with no problems. So I select Database name SMSServer and entered all the fields and for each tab of the Properties of the SQL Connector, the "TEST" button says "Succeeded". I saved it.

When the Connector starts and the Status says "SQL Database error". I looked at the logs under the Events Tab and it has the following error (Line 1: Incorrect syntax near ",".)

From my database I added a record to the MessageOut table but nothing happens. No SMS is sent. I believe it's because there is some problem with the SQL database since I created it manually.

For reference when creating the database within the Diafaan SMS server program it gave the following errors and didn't create the tables, etc.

success: CREATE DATABASE SMSServer
-----------------
CREATE TABLE MessageOut (Id int IDENTITY (1,1) PRIMARY KEY, MessageTo nvarchar(80), MessageFrom nvarchar(80), MessageText nvarchar(max), MessageType nvarchar(80), Gateway nvarchar(80), UserId nvarchar(80), UserInfo nvarchar(max), IsRead bit NOT NULL DEFAULT 0)
Line 1: Incorrect syntax near 'max'.
-----------------
CREATE TABLE MessageIn (Id int IDENTITY (1,1) PRIMARY KEY, SendTime datetime NOT NULL DEFAULT getdate(), ReceiveTime datetime, MessageFrom nvarchar(80), MessageTo nvarchar(80), SMSC nvarchar(80), MessageText nvarchar(max), MessageType nvarchar(80), MessagePDU nvarchar(max), Gateway nvarchar(80), UserId nvarchar(80))
Line 1: Incorrect syntax near 'max'.
-----------------
CREATE TABLE MessageLog (Id int IDENTITY (1,1) PRIMARY KEY, SendTime datetime NOT NULL DEFAULT getdate(), ReceiveTime datetime, StatusCode int, StatusText nvarchar(80), MessageTo nvarchar(80), MessageFrom nvarchar(80), MessageText nvarchar(max), MessageType nvarchar(80), MessageId nvarchar(80), ErrorCode nvarchar(80), ErrorText nvarchar(80), Gateway nvarchar(80), MessagePDU nvarchar(max), UserId nvarchar(80), UserInfo nvarchar(max))
Line 1: Incorrect syntax near 'max'.
-----------------
CREATE INDEX IDX_IsRead ON MessageOut (IsRead)
Cannot create an index on 'MessageOut', because this table does not exist in database 'SMSServer'.
-----------------
CREATE INDEX IDX_MessageId ON MessageLog (MessageId, SendTime)
Cannot create an index on 'MessageLog', because this table does not exist in database 'SMSServer'.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 680

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1156

Posts: 3946

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1511