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?
Best answer by Elizabeth G
View original
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers