Browse "Message Database" Questions:

Q8380030: Is it possible to use a SQL 'INSERT' statement to create a new SMS message? What values shoud I use?
Yes you can. Please read the following article for more information: Create a new SMS or e-mail Message directly without using the API.
SMS Messaging Server > Message Database

Q8380100: I just migrated the Message Database to MySQL and now some characters are displayed as '???'. What to do ?
The SMS Messaging Server stores all message data to the database as Unicode. Please check the following: The default charset of the tables have to be set to 'ucs2'; You have to use the MyODBC driver version 5.1 on the client PC. Older versions do not support Unicode.
SMS Messaging Server > Message Database

Q8380010: I noticed that there's wizard to migrate the message database to MS SQL. Is it recommended?
I depends on the SMS/e-mail traffic. An MS SQL database performs much better than MS Access, especially when the database is large (i.e. 50.000 messages or more). With low/medium databases (up to 50.000 messages) an MS Access database will suffice.
SMS Messaging Server > Message Database

Q8380040: Can I use an MS SQL 'Stored Procedure' to send an SMS message?
Yes you can. Please read the following article for more information: Create a new SMS or e-mail Message directly without using the API.
SMS Messaging Server > Message Database

Q8380020: Is it possible to define a failover message database, in case the (primary) message database stops working?
It is not a built-in feature of SMS Messaging Server. You should use ActiveXperts Network Monitor to monitor the SMS Messaging Server message database, and to failover to a secondary message database in case the primary message database fails. Click here for more information about this topic.
SMS Messaging Server > Message Database

Q8380050: Can I migrate the Message Database to MS SQL Server Express Edition? If so, how can it be done?
Yes, MS SQL Express Edition is supported. Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Express Edition database in the 'Host' field. For example, if the name of the database server is named 'DbServer01', and the instance id of the database is named 'SQLExpress', then specify 'DbServer01\SQLExpress'. There's no performance difference between MS SQL Server and ...
SMS Messaging Server > Message Database

Q8380015: The performance of the Message Database is too slow, especially the triggers, and I want to migrate the Message Database, preferably MS SQL Server Express Edition. Is there any performance difference between MS SQL Server and MS SQL Server Express Edition?
No, there's no performance difference between MS SQL Server and MS SQL Server Express Edition. It is strongly recommended to migrate your Message Database to either MS SQL Server or MS SQL Server Express Edition to boost the performance of the Message Database.
SMS Messaging Server > Message Database

Q8380005: Can I send messages by inserting the messages directly through an SQL statement rather than using your API?
Yes, you can. Execute a SQL command like this: INSERT INTO Messages( Body, ToAddress, TypeID, DirectionID, StatusID) VALUES( 'Hello world!', '+316112233445566', 1, 2, 1 ); Please note that'TypeID=1' means: SMS, 'DirectionID=1' means: Outgoing, 'StatusID=1' means: Pending For an explanation of these fields, please check the manual, chapter Message Database Tables).
SMS Messaging Server > Message Database

Q8380012: Can I migrate the report database to MS SQL Server Express Edition? If so, how can it be done?
Yes, MS SQL Express Edition is supported. Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Express Edition database in the 'Host' field. For example, if the name of the database server is named 'DbServer01', and the instance id of the database is named 'SQLExpress', then specify 'DbServer01\SQLExpress'. There's no performance difference between MS SQL Server and ...
SMS Messaging Server > Message Database

ActiveXperts Error codes
Click here to view the full list of ActiveXperts error codes
Contact Support
To contact the ActiveXperts Help Desk, click here.