When configuring an external class you must configure a connection type.The configuration types are the following:
|
Connection Type |
Description |
|---|---|
|
Local or Linked Server |
Select this option if the OnBase Studio is on the same server as the database you want to connect to and you are able to connect directly to the server on which the external database resides. This option is the preferred method of connecting to a database and provides greater functionality between the two options. Note:
This option is not supported in Oracle databases and will be disabled. |
|
ODBC Connection |
Select this option when you want to connect to a database via an ODBC connection. This option does not allow sorting or filter criteria to be utilized using the associated external class. Note:
It is recommended that if you do not require modification to an external class, the User Name and Password provided for the connection should have read-only access. Note:
If a password contains special characters, those characters will need to be escaped in order to log in successfully. The method to escape characters varies by database type. As an example, if an account associated with a SQL Server database has a special character, like pass;word, the password would need to be enclosed in {}: {pass;word}. |