Oracle

As mentioned earlier, the data provider for Oracle is not distributed with Logi Info. Use this link to download Oracle Instant Client drivers (navigate to the appropriate version). New for 14.2 Logi Info and SSRM now support Oracle 19c databases.

Virtual Private Database Support

Oracle's Virtual Private Database (VPD) feature enables users to create security policies to control database access at the row and column level, and Logi Info supports this with a special element:

The Vpd Context element, highlighted above, is a child of the Connection.Oracle element. The Vpd Context element has a single Command attribute, which is typically set to the name of a Stored Procedure (SP). This SP is set up by an Oracle DBA to create security policies that control database access. Parameters are supplied to the SP by using one or more child SP Parameter elements, as shown above.

"Oracle x.x.x Client Required" Error

Oracle connections may fail, displaying the Inner Error message "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater." in the Debugging Trace Page. This may occur even though the SQL Query Builder is able to connect to the database, and even though a later version of the Oracle Client has been installed.

A likely cause of this problem is that the account that the web server uses to run your Logi application does not have appropriate fileaccess permissions to the folder that contains the Oracle Client software. That account may be ASPNET, Network Service, an Application Pool account, or another account, depending on your web server configuration. Giving that account Read and Execute permissions for the folder that contains the Oracle client will usually resolve this problem.

The web server must be rebooted after the Oracle client software has been installed.

Oracle 32-bit Software on Windows 64-bit OS

If you're attempting to connect to an Oracle database from a Windows platform using one of the following programmatic interfaces: ODBC, OLEDB, OO4O, or ODP.NET, after installing 32-bit Oracle client software on a 64-bit Windows operating system (OS) you may receive one of the following errors: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-6413: Connection not open. This is because the 64-bit Windows OS installs 32-bit software by default into a folder beneath C:\Program Files (x86) and the presence of parenthesis in the file path is unacceptable to the Oracle software. This is a known bug that Oracle may fix in the future. Until then, you must install the Oracle 32-bit client software somewhere other than the default location.