Connect Omnis Studio to ASE

When you use Devart ODBC Driver for ASE in Omnis Studio, tables and other database objects from the dbo schema might not appear in SQL Browser because Omnis Studio treats these as system objects and hides them by default.

To show the required tables and objects, enable system objects in session settings:

1. In your current session, navigate to SQL Browser.

2. Click Options.

Omnis Studio SQL Browser showing a session, with the Options link visible in the Session Manager panel

3. Select Include System Objects.

4. Click Save.

Omnis Studio SQL Object Browser Options dialog with the selected Include System objects option

All required tables and objects from the dbo schema now appear in Omnis Studio.