.TH "GAMMU-SMSD-ODBC" "7" "May 29, 2013" "1.33.0" "Gammu"
.SH NAME
gammu-smsd-odbc \- gammu-smsd(1) backend using ODBC abstraction layer to use any supported database as a message storage
.
.nr rst2man-indent-level 0
.
.de1 rstReportMargin
\\$1 \\n[an-margin]
level \\n[rst2man-indent-level]
level margin: \\n[rst2man-indent\\n[rst2man-indent-level]]
-
\\n[rst2man-indent0]
\\n[rst2man-indent1]
\\n[rst2man-indent2]
..
.de1 INDENT
.\" .rstReportMargin pre:
. RS \\$1
. nr rst2man-indent\\n[rst2man-indent-level] \\n[an-margin]
. nr rst2man-indent-level +1
.\" .rstReportMargin post:
..
.de UNINDENT
. RE
.\" indent \\n[an-margin]
.\" old: \\n[rst2man-indent\\n[rst2man-indent-level]]
.nr rst2man-indent-level -1
.\" new: \\n[rst2man-indent\\n[rst2man-indent-level]]
.in \\n[rst2man-indent\\n[rst2man-indent-level]]u
..
.\" Man page generated from reStructuredText.
.
.SH DESCRIPTION
.sp
New in version 1.29.92.
.sp
ODBC backend stores all data in any database supported by \fI\%ODBC\fP, which
parameters are defined by configuration (see \fIgammu\-smsdrc\fP for description of
configuration options).
.sp
For tables description see \fIgammu\-smsd\-tables\fP.
.sp
This backend is based on \fIgammu\-smsd\-sql\fP.
.SH SUPPORTED DRIVERS
.sp
On Microsoft Windows, Gammu uses native ODBC, on other platforms, \fI\%unixODBC\fP
can be used.
.SH LIMITATIONS
.sp
Due to limits of the ODBC interface, you might have to tweak SQL queries to
work in used SQL server, see \fISQL Queries\fP for more details.
.sp
Partially this can be configured using \fBSQL\fP.
.SH CONFIGURATION
.sp
Before running \fIgammu\-smsd\fP 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.
.sp
You specify data source name (DSN) as \fBHost\fP in
\fIgammu\-smsdrc\fP. The data source is configured depending on your platform.
.sp
On Microsoft Windows, you can find instructions on Microsoft website:
\fI\%http://support.microsoft.com/kb/305599\fP
.sp
For unixODBC this is documented in the user manual:
\fI\%http://www.unixodbc.org/doc/UserManual/\fP
.SH EXAMPLE
.sp
Example configuration:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
[smsd]
service = sql
driver = odbc
host = dsn_of_your_database
sql = sql_variant_to_use
user = username
password = password
.ft P
.fi
.UNINDENT
.UNINDENT
.INDENT 0.0
.INDENT 3.5
.IP "See also"
.sp
\fIgammu\-smsdrc\fP
.UNINDENT
.UNINDENT
.SH AUTHOR
Michal Čihař <michal@cihar.com>
.SH COPYRIGHT
2009-2012, Michal Čihař <michal@cihar.com>
.\" Generated by docutils manpage writer.
.