Products
Ozeki 10
Apps
Chat
SMS Gateway
SMS with Client Software
HTTP API
SMS from/to Database
PHP SMS API
Solutions
C# SMS API
VB.NET SMS API
SQL Logging
MySQL table layout
Oracle table layout
MSSQL table layout
SQL templates
SQL Log Tracking
Keywords
Advanced Traffic Queries
System Database
Robot Controller
Softphone
Connections
Installation guide
Terms and Definitions
SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Technology
Company


Ozeki SMS Gateway
VB.NET SMS API VB.NET SMS API | MySQL table layout MySQL table layout

SQL Logging

You can store log events with Ozeki SMS Gateway for every incoming and outgoing message from your database. It is a useful idea to transform SQL queries to produce various log reports. Customize your log reports for every database connection using an ODBC or OleDb driver.

Start the video

You can specify the SQL logging option with a correct database connection string, which creates a connection to your database with an ODBC or OleDb driver. Then specify the SQL statements to store message traffic information on your database server. These statements can contain keywords as well, which keyword will be replaced just before executing each SQL statement. For example you can INSERT a new row generated from a received message.

Enable logging your SQL queries by clicking 'Edit/Server preferences' from the top menu of Ozeki SMS Gateway. On the new page please select the 'Databases' tabpage and 'Logging database settings' sub-tabpage (Figure 1). Tick 'Enable SQL reporting' to enable SQL logs and do not forget to add the connection string for your database driver.


Figure 1 - How to enable SQL logging

'Log SQL commands into eventlog' should be ticked as default, but it is advised to check it (Figure 2). If you enable this option, the executed SQL statements will be written into the event log during reporting. Here you can read more.


Figure 2 - Set SQL SMS reporting, if not set

You can CREATE the tables for your SQL database if they are not yet created. You can find detailed descriptions for creating MySQL, Oracle or MSSQL table layouts. CREATE TABLE statements await you on the following page.


Copyright © 2000- - Ozeki Informatics Ltd. | info@ozeki.hu | Tel: +36 1 371 0150
Home > Products > Ozeki 10 > Apps > SMS Gateway > SQL Logging
Page: 5776 | Login