blob: 6617a5c55ecdfe3078a16bb841e3f35f1a6c3bad (
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
|
; This file contains several sections, one for each database type.
; Select here which section has to be used currently,
; i.e. which database you want to use
[Database]
type=bufdataset
; These sections are for the several SQLDB-types of databases:
; PostgreSQL database:
[postgresql]
; The connector specifies the DB-component that has to be used. The 'sql'
; connector tests the SQLDB components
connector=sql
; Here you can give some parameters, which are specific for each connector. The
; SQL connector uses this parameter to specify the connection that should be
; used;
connectorparams=postgresql
; The name of the database. The database could be empty. You only need read and
; write rights.
name=testdb
; user to log in with
user=
; password to log in with
password=
; hostname of the database-server
hostname=127.0.0.1
; MySQL 4.0 database:
[mysql40]
connector=sql
connectorparams=mysql40
name=testdb
user=root
password=
hostname=127.0.0.1
; MySQL 4.1 database:
[mysql41]
connector=sql
connectorparams=mysql41
name=testdb
user=root
password=
hostname=127.0.0.1
; MySQL 5.0 database:
[mysql50]
connector=sql
connectorparams=mysql50
name=testdb
user=root
password=
hostname=127.0.0.1
; MySQL 5.1 database:
[mysql51]
connector=sql
connectorparams=mysql51
name=testdb
user=root
password=
hostname=127.0.0.1
; MySQL 5.5 database:
[mysql55]
connector=sql
connectorparams=mysql55
name=testdb
user=root
password=
hostname=127.0.0.1
; Oracle database:
[oracle]
connector=sql
connectorparams=oracle
name=xe
user=system
password=
hostname=127.0.0.1
; Interbase or Firebird database:
[interbase]
connector=sql
connectorparams=interbase
name=/opt/firebird/data/testdb.fdb
; Default username/password for Interbase/Firebird
; is sysdba/masterkey. Change to your situation.
user=sysdba
password=masterkey
hostname=localhost
; Firebird embedded
; Same as Firebird, except we leave the host name blank
; and specify a db without path.
; Make sure your Firebird embedded library files (.dll/.so/.dylib)
; are installed; e.g. on Windows, you can put them in this
; directory.
; Test code will create db if it doesn't exist; you can
; delete an existing db file before the test to start
; fresh.
[firebirdembedded]
connector=sql
connectorparams=interbase
name=fbembedtest.fdb
user=sysdba
password=masterkey
hostname=
; ODBC database:
[odbc]
connector=sql
connectorparams=odbc
name=testdb
user=root
password=
hostname=127.0.0.1
; SQLite database:
[sqlite]
connector=sql
connectorparams=sqlite3
name=test.db
; MS SQL Server database:
[mssql]
connector=sql
connectorparams=mssql
name=pubs
; If you want to use trusted authentication/SSPI, leave
; user and password blank
user=sa
password=
; You can specify the port after a colon, e.g.
; hostname=mssqlserver:1433
; You can also specify the instance after a backslash, e.g.
; hostname=127.0.0.1\SQLEXPRESS
; See mssqlconn documentation
hostname=127.0.0.1
; Sybase ASE database
[sybase]
connector=sql
connectorparams=sybase
name=testdb
user=sa
password=
; You can specify the port after a colon, e.g.
; hostname=bigbadserver:5000
; See mssqlconn documentation
hostname=127.0.0.1
; TDBf: DBase/FoxPro database:
[dbf]
connector=dbf
; Connectorparams specifies table level/compatibility level:
; 3=DBase III
; 4=DBase IV
; 7=Visual DBase 7 for Windows
; 25=FoxPro
; 30=Visual FoxPro
connectorparams=4
; TDBf: DBase/FoxPro database:
[dbase3]
connector=dbf
connectorparams=3
; TDBf: DBase/FoxPro database:
[dbase4]
connector=dbf
connectorparams=4
; TDBf: DBase/FoxPro database:
[dbase7]
connector=dbf
; 7=Visual DBase 7 for Windows
connectorparams=7
; TDBf: DBase/FoxPro database:
[foxpro]
connector=dbf
; 25=FoxPro
connectorparams=25
; TDBf: DBase/FoxPro database:
[visualfoxpro]
connector=dbf
; 30=Visual FoxPro
connectorparams=25
; MemDS in memory dataset:
[memds]
connector=memds
; BufDataset in memory dataset:
[bufdataset]
connector=bufdataset
; sdfdataset file-based dataset:
[sdfdataset]
connector=sdfds
; subdirectory for the sdf files:
name=sdftest
|
