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
|
