Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Send Message for Group and MessageLog problem
sp_NewPost Add Reply sp_NewTopic Add Topic
October 15, 2012
10:11 am
Henk Helmantel

Hi Chris,

The problem turns out to be related to the ODBC driver for Oracle. Since we have tested the Oracle database only with the OLE DB provider we did not run into the problem before. The technical reason of the error is that Oracle does not support the SQL_BIGINT data type. For some reason this is not a problem with the OLE DB provider for Oracle but the ODBC driver generates an error. For the next version of Diafaan SMS Server we will change the data type for numbers to SQL_INTEGER that is supported by all SQL databases that we tested.

As a temporary solution you can use the OLE DB provider for Oracle databases instead of the ODBC driver. Users who purchased a license for Diafaan SMS Server with a support period that is still valid can request an update for the SQL Connector plugin that can be used until the next release of Diafaan SMS Server.

Regards, Henk

October 15, 2012
7:59 am
Chris Leung

Hi Henk

In the Event Log just show the message as follow:

Event Time : 15/10/2012 13:57:09
Source : Oracle Connector
Event Type : Error
Message :

October 13, 2012
9:26 pm
Henk Helmantel

Hi Chris,

Unfortunately, we are not able to test Oracle 9i since it is quite old and the trial cannot be downloaded from Oracle anymore. I'll try to set up an Oracle 11g installation to see if that version has the same problem.

What is the exact error in the Event Log of the SQL Connector that is generated by the Oracle OleDB provider? Maybe this will tell me something about a possible solution.

Regards, Henk

October 13, 2012
11:29 am
Chris Leung

hi Henk ,

i try to add a field using NUMBER(19) but still not work

October 12, 2012
10:33 am
Henk Helmantel

Hi Chris,

To send multiple message, you must add multiple records to the MessageOut database table. It is not possible with the SQL Connector to send multiple messages from one database record.

The OleDB component in the SQL Connector uses the type "OleDbType.BigInt" for the StatusCode, this corresponds to "Number" in Oracle. We have tested the settings with Oracle 10g but not with Oracle 9i.

You could try the Oracle type NUMBER(19), this should correspond exactly with the 64-bit signed BigInt OleDB format.

Regards, Henk

October 12, 2012
8:42 am
Chris Leung

We are installed Diafaan SMS Server Light Version
Our Database is using Oracle 9i

My Problem is :
1. If we have a message to send to 10 people , how can i add the phone number to one record (messageto) ? or i need to insert 10 record to the messageout table ?
2. I create a table messagelog but the server cannot create a record when message is send out , after i remove the field "statuscode" in the console "SMS Log" , then the messagelog can work fine.
the messagelog table is created using your sample provided. i try to add other filed using other datatype but still not work ,
so what datatype can i using ?


SendTime DATE,
ReceiveTime DATE,
StatusCode NUMBER,
StatusText NVARCHAR2(80),
MessageTo NVARCHAR2(80),
MessageFrom NVARCHAR2(80),
MessageText NCLOB,
MessageType NVARCHAR2(80),
MessageId NVARCHAR2(80),
ErrorCode NVARCHAR2(80),
ErrorText NVARCHAR2(80),
Gateway NVARCHAR2(80),
UserId NVARCHAR2(80),
UserInfo NCLOB);

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502