Difference between revisions of "Database connection string"
(Partial re-write to remove other, un-used, drivers) |
m (→Example database connection string) |
||
| Line 8: | Line 8: | ||
<code> | <code> | ||
ConnectionType=MSSQL | ConnectionType=MSSQL | ||
| + | |||
ConnectionString=ADO?AuxDriver=SQLMCLI10.1;Server=DBServer1;Database=BurnsInjury;UserID=burndbuser;Password=XXXXX | ConnectionString=ADO?AuxDriver=SQLMCLI10.1;Server=DBServer1;Database=BurnsInjury;UserID=burndbuser;Password=XXXXX | ||
</code> | </code> | ||
| Line 15: | Line 16: | ||
<code> | <code> | ||
ConnectionType=MSSQL | ConnectionType=MSSQL | ||
| + | |||
ConnectionString=ADO?AuxDriver=SQLNCLI10.1;Server=DBServer1;Database=BurnsInjury;Integrated Security=SSPI | ConnectionString=ADO?AuxDriver=SQLNCLI10.1;Server=DBServer1;Database=BurnsInjury;Integrated Security=SSPI | ||
</code> | </code> | ||
Revision as of 17:53, 13 June 2016
This is a Technical Instructions topic
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=SQLMCLI10.1;Server=DBServer1;Database=BurnsInjury;UserID=burndbuser;Password=XXXXX
or
ConnectionType=MSSQL
ConnectionString=ADO?AuxDriver=SQLNCLI10.1;Server=DBServer1;Database=BurnsInjury;Integrated Security=SSPI
Alter the values in the string above to reflect your own installation as detailed below.
Driver and AuxDrivers
The driver and auxillary driver is the ADO?AuxDriver=SQLNCLI10.1' part of the connection string. In the above example it is ADO?AuxDriver=SQLNCLI10.1.1 which uses the SQL Native Client.
The following are your choices of drivers depending on what libraries you have available on the server:
- ADO?AuxDriverSQLNCLI10.1 - SQL Native Client
- ADO?AuxDriver=SQLOLEDB.1 - ADO DB Driver
- AnyDAC?AuxDriver=MSSQL - No external driver needed, AnyDAC is a fast, built in SQL Server driver that can be used at any time
If you change any settings in the AquilaServer.ini file, the AquilaServer service must be restarted for the changes to take effect.
