Difference between revisions of "Database connection string"
m |
|||
| Line 2: | Line 2: | ||
| − | {{ | + | {{todosc|Add connection options}} |
The application server INI File contains two entries necessary to control the access to the database. | The application server INI File contains two entries necessary to control the access to the database. | ||
Revision as of 18:33, 1 September 2014
This is a Technical Instructions topic
The application server INI File contains two entries necessary to control the access to the database.
Contents
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?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.
