ODBC Backend

Description

New in version 1.29.92.

ODBC backend stores all data in any database supported by ODBC, which parameters are defined by configuration (see SMSD Configuration File for description of configuration options).

For tables description see SMSD Database Structure.

This backend is based on SQL Service.

Supported drivers

On Microsoft Windows, Gammu uses native ODBC, on other platforms, unixODBC can be used.

Limitations

Due to limits of the ODBC interface, you might have to tweak SQL queries to work in used SQL server, see SQL Queries for more details.

Partially this can be configured using SQL.

Configuration

Before running gammu-smsd you need to create necessary tables in the database. You can use examples given in database specific backends parts of this manual to do that.

You specify data source name (DSN) as Host in SMSD Configuration File. The data source is configured depending on your platform.

On Microsoft Windows, you can find instructions on Microsoft website: http://support.microsoft.com/kb/305599

For unixODBC this is documented in the user manual: http://www.unixodbc.org/doc/UserManual/

Example

Example configuration:

[smsd]
service = sql
driver = odbc
host = dsn_of_your_database
sql = sql_variant_to_use
user = username
password = password