When you first use a database connection, depending on the type of database, Omniscope may prompt you to download and locate the database JDBC driver. Omniscope tracks this location, so you don't need to enter it again.
However, if there are more than one user account running Omniscope on the same machine, then when running as a different user account, these settings won't be available and you or other users on the same machine will be prompted again on first use. This may be inconvenient if configuring a system for multiple user accounts, and can prevent a 'headless' Scheduler Server running as a Windows Service from working.
Use this approach if you have multiple users launching Omniscope Desktop on the same system, and/or wish to push out a configuration centrally to many PCs.
Use this approach if you're using the Windows Service to run the Omniscope Scheduler/Mobile Web Server without a logon session.
Database | propName | Typical propValue |
Ingres/Vectorwise | IngresSqlDriverSearch_driverDir | C:\Program Files\Ingres JDBC Driver\iijdbc.jar |
MySql | MySqlDriverSearch_driverDir | C:\Program Files\MySQL JDBC driver |
Oracle | OracleThinDriverSearch_jarFile | C:\Oracle\product\11.2.0\Db_1\jdbc\lib\ojdbc5.jar |
Postgres | PostgreSqlDriverSearch_driverDir | C:\Program Files\PostgreSQL JDBC Driver\postgresql-8.4-701.jdbc4.jar |
MS SQL Server | SqlServer2008DriverSearch_jarFile | C:\Program Files (x86)\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc4.jar |
Links:
[1] http://kb.visokio.com/kb/installconfig
[2] http://kb.visokio.com/kb/windows-service