ODBC Driver for SQL Azure

Connecting Omnis Studio to SQL Azure via ODBC Driver



When using ODBC Driver for SQL Azure in Omnis Studio as a data source, Omnis Studio does not display tables and other objects from dbo schema (it considers them as system ones). To solve the issue, do the following:


  1. After creating a session using Session Manager, in the SQL Browser tab, click Options.

    Using in Omnis Studio

  2. In the opened dialog, check Include System objects and click Save.

    Include System objects

In this case, all the required tables and objects will be displayed by Omnis Studio.

© 2015-2024 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback