Difference between revisions of "Database connection string"

Revision as of 17:47, 13 June 2016

(STOODO: Add connection options)

The application server INI File contains two entries necessary to control the access to the database.

Example database connection string

ConnectionType=MSSQL ConnectionString=ADO?AuxDriver=SQLOLEDB.1;Server=DBServer1;Database=BurnsInjury;UserID=burndbuser;Password=XXXXX

Alter the values in the string above to reflect your own installation as detailed below.

Driver and AuxDrivers

The driver and auxillary driver are the first two options specified in the connection string. In the above example it is ADO?AuxDriver=SQLOLEDB.1 which uses the SQL OLE DB driver that is part of ADO.

AquilaCRS has it's own, built in database drivers available. We call this technology AnyDAC as it can connect natively to a host of database engines. Our own MSSQL drivers are usually faster than using ADO.

MSSQL

• ADO?AuxDriverSQLNCLI10.1
• ADO?AuxDriver=SQLOLEDB.1
• AnyDAC?AuxDriver=MSSQL

MySQL

• AnyDAC?AuxDriver=MYSQL

Interbase

• IBX;
• AnyDAC?AuxDriver=IB

Firebird

• AnyDAC?AuxDriver=IB

Server, Database and User

Replace the values in the above connection string with your own Server, Database, UserID and Password parameters.

Connection options

MSSSQL

MySQL

Interbase

Firebird

SQLite (local)