; 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 ; Give here the path where the *.dbf file can be generated name=/tmp ; 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