13 Aug Adding ADO.Net Connection String to OnBase Application Server Config File
In OnBase 18, an ADO.Net Connection straight is required to run the Unity Client. You can make this modification within the Application Server’s web.config file. To do so requires just a few simple steps that take mere minutes to complete but can go a long way to improving your users’ experience. To get started:
- Browse to your web.config file located in your application servers virtual root directory and open it. Unless you have a very customized solution, this file should exist in c:\inetpub\wwwroot\appserver directory.
- Open the web.config file in a text editor such as notepad ++.
- Do a search to locate the connectionstrings data element beginning with <connectionstrings>
- Fill in the Parameters using the guide shown below to successfully populate the placeholders and set up the connection strings for your OnBase enviroment.
Blank Connection String:
<add name=”[DataSourceName]” connectionString=”Data Source=[server\instance];database=[databaseName];User Id=[user name];Password=[password]” providerName=”[providerName]”/> </connectionStrings>
|DataSourceName||Name of You want Datasource to be||OnBase|
|server\instance||Database Server Name/ SQL Instance Name||S1-db-1/OnBase|
|databaseName||Name of Database on your SQL Instance||OBProd|
|user name||The user used to configure your ODBC||HSI|
|password||This will be the password used by the above user to connect to sql||Password used by HSI account|
|providerName||Type of Data Provider in the example we will use SQL||System.Data.SqlClient|
Example of a valid SQL connection string:
<add name=”OnBase” connectionString=”Data Source=s1-db-1\OnBase;dsn=OBProd;User Id=hsi;Password=xxxx” providerName=”System.Data.SqlClient”/>
- Save your Web.config file. Upon saving this, it will boot all users that are connected to this application server out of your system so take extreme caution when doing so. It might be helpful to notify your user base in advance so they’re prepared and you/your colleagues aren’t bombarded with support tickets, calls, and emails.
What other OnBase functionality are you curious about? Is there a feature you’ve stumbled across but aren’t sure how to use? We’re here to help! Just post a comment below and we’ll try to do a future post that addresses your query.
We look forward to hearing from you!