When connecting to an Oracle database, you may experience very slow responses when loading the list of Tables or Field in the configuration wizard, or when performing Autofill and Export using the Oracle connection.

This can be caused by a variety of issues:

• Check User Permissions. Make sure the user has access to the required tables and schemas. Users with access to all schemas may experience significant delays when loading table lists as there can be many thousands of tables they have access to. Try switching to a user account whose schema only includes the tables used by SimpleIndex.
• Slow connection between the client and the Oracle server. Check if other Oracle applications on this workstation also experience slowness.
• Issues with client installation. Reinstall or update your Oracle client and ODBC drivers.

In SQL Server, Oracle and MySQL (among others) user logons are associated with a default “schema” that determines which tables and views they can see.

Users may have access to other tables and views that aren’t in their schema. When connecting to the database these tables will show up in the list, but when you try to get the list of fields you get an “Invalid object reference” error.

To reference these tables, use [Schema].[Table] for the table name to explicitly reference the table.

You can also change the user’s default schema on the server to the one matching the table.

A third option is to create a view under the user’s default schema that selects the necessary records.

At the present time you cannot enter [Schema].[Table] in the wizard, so if you need to use this workaround configure the job in the wizard and modify the table name in the old job options screen.

If you have a Search/Retrieval configuration that you want to have Sort by more than one column do the following.

1. Open the configuration pad in Notepad.
2. Search for the option value <SORT_FIELD>
3. Normally there is one value in the section that looks like this:  <SORT_FIELD>FIELD1</SORT_FIELD>
4. Add the fields that you want to search by as the database columns like this:  <SORT_FIELD>[FIELD1],[FIELD2]</SORT_FIELD>

If you would like to create a database string for an Access database that includes a password use this format:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\database.mdb;Jet OLEDB:Database Password=db_password;

You must include the latest SimpleIndex Standalone or Imaging Suite installer with your CDs to enable the search function. Download this file to “C:\ProgramFiles\SimpleIndex\CDFiles\setup.exe” to enable the Media Wizard or update it to the latest version.

This error is usually caused when the data you are trying to insert does not match the data type of the database field. This could be a text value being inserted into a number or date field, or a text value that is longer than the maximum length of the field.

To avoid this error, be sure to use the correct Field Type and/or Template on the Index tab to force the user to enter data in the correct format. You may also need to adjust the data types or lengths for your database fields.

If the database you use to store index information has security access features, you can use these to manage access to documents with SimpleIndex retrieval mode.

In your database, create user accounts and groups and assign them the appropriate permissions to records in your document database.

In SimpleIndex, check the “Require Logon” option on the Logging tab to force the user to logon to the database using the accounts you created. When they search and view documents, they will only be able to access records that the corresponding database user has been assigned access to.

This feature is included in SimpleIndex at no additional cost and is called the Media Wizard.

The Media Wizard is located in the “Scan” file menu and is called Media Wizard. It allows you to burn your images, indexes, a database and a free SimpleSearch viewer for just the CD or DVD. It also provides an easy way to get the maximum amount of information on the media that you want it on.

You set up the Media Wizard by pointing it to your image folder and database and you select the media that you would like to put it on. It then saves a file folder with all the files that you would need in the size of the media you are using in the location that you designate. You then burn these files using the burning application of your choice.