aboutsummaryrefslogtreecommitdiff
path: root/libraries/sqliteodbc/README.SLACKWARE
blob: c7e37556813165120c4ec0e1d7474759ee38d5e6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
To setup a SQLite data source using libiodbc do the following steps:

1. Add the driver to /etc/odbcinst.ini:

   [ODBC Drivers]
   SQLite3=Installed

   [SQLite3]
   Description=SQLite3 ODBC Driver
   Driver=/usr/lib/libsqlite3odbc.so
   Setup=/usr/lib/libsqlite3odbc.so
   Threading=2

2. Add a DSN to your private ~/.odbc.ini or the system /etc/odbc.ini
   file:

   [ODBC Data Sources]
   mysqlitedb=SQLite3

   [mysqlitedb]
   Driver=/usr/lib/libsqliteodbc.so
   Description=My SQLite test database
   Database=/home/johndoe/databases/mytest.db
   # optional lock timeout in milliseconds
   Timeout=2000


Alternatively, to setup a SQLite data source using unixODBC:

1. Add the driver to /etc/odbcinst.ini:

   [SQLite3]
   Description=SQLite3 ODBC Driver
   Driver=/usr/lib/libsqlite3odbc.so
   Setup=/usr/lib/libsqlite3odbc.so
   Threading=2

2. Add a DSN to your private ~/.odbc.ini or the system /etc/odbc.ini
   file:

   [mysqlitedb]
   Description=My SQLite test database
   Driver=SQLite3
   Database=/home/johndoe/databases/mytest.db
   # optional lock timeout in milliseconds
   Timeout=2000