Skip to main content

I created some User Defined Views for my ODBC driver, but when I use the driver with a linked server, I can’t find them anymore. Is there a way to access them?

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.


Reply