Blog

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:

  1. 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.
  2. Open the web.config file in a text editor such as notepad ++.
  3. Do a search to locate the connectionstrings data element beginning with <connectionstrings>
  4. 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>

Data Element Information Example
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!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.