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.
In the Event Log just show the message as follow:
Event Time : 15/10/2012 13:57:09
Source : Oracle Connector
Event Type : Error
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.
hi Henk ,
i try to add a field using NUMBER(19) but still not work
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.
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 ?
CREATE TABLE MessageLog (
Id NUMBER(19) NOT NULL PRIMARY KEY,
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 354
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 519