Adding ADO.Net Connection String to OnBase Application Server Config File

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 ElementInformation Example
DataSourceNameName of You want Datasource to beOnBase
server\instanceDatabase Server Name/ SQL Instance NameS1-db-1/OnBase
databaseNameName of Database on your SQL InstanceOBProd
user nameThe user used to configure your ODBCHSI
passwordThis will be the password used by the above user to connect to sqlPassword used by HSI account
providerNameType of Data Provider in the example we will use SQLSystem.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!

No Comments

Post A Comment