NAME

       gammu-smsd-odbc  - gammu-smsd(1) backend using ODBC abstraction layer to use any supported
       database as a message storage

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 gammu-smsdrc for description of configuration options).

       For tables description see gammu-smsd-tables.

       This backend is based on gammu-smsd-sql.

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 gammu-smsdrc. 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

          See also

                 gammu-smsdrc

AUTHOR

       Michal Čihař <michal@cihar.com>

COPYRIGHT

       2009-2012, Michal Čihař <michal@cihar.com>