Difference between revisions of "Database connection string"
(→MSSQL) |
(Partial re-write to remove other, un-used, drivers) |
||
| Line 1: | Line 1: | ||
{{ProductTopic|Technical|Instructions}} | {{ProductTopic|Technical|Instructions}} | ||
| − | |||
| − | |||
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. | ||
| Line 10: | Line 8: | ||
<code> | <code> | ||
ConnectionType=MSSQL | ConnectionType=MSSQL | ||
| − | ConnectionString=ADO?AuxDriver= | + | ConnectionString=ADO?AuxDriver=SQLMCLI10.1;Server=DBServer1;Database=BurnsInjury;UserID=burndbuser;Password=XXXXX |
</code> | </code> | ||
| − | + | or | |
| − | == | + | <code> |
| + | ConnectionType=MSSQL | ||
| + | ConnectionString=ADO?AuxDriver=SQLNCLI10.1;Server=DBServer1;Database=BurnsInjury;Integrated Security=SSPI | ||
| + | </code> | ||
| − | |||
| − | + | 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. | |
| − | |||
| − | |||
[[Category:Admin Help]] | [[Category:Admin Help]] | ||
[[Category:AquilaCRS]] | [[Category:AquilaCRS]] | ||
[[Category:IBID]] | [[Category:IBID]] | ||
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.
