Due to the way that the catalog and schema are used in a linked server, only one schema can be accessed at a time. As User Defined Views are also stored in a different schema, which by default is named UserViews, they aren’t visible in the linked server under the default schema. To access them, you will need to set BrowsableSchemas to UserViews in the DSN, and then restart the SQL Gateway service and refresh the linked server. The User Defined Views will then appear in the linked server.
On a similar note, for data sources that have more than one schema, this solution can also be used to work around the ‘one schema’ limitation in the linked server. Setting BrowsableSchemas to the schema that you are attempting to access will allow the tables and views in that schema to appear. If you wish to work with multiple schemas, it is recommended to have multiple DSNs, each connecting to one specific schema.
