topic QlikView & MS SQL schema missing in QlikView https://community.qlik.com/t5/QlikView/QlikView-MS-SQL-schema-missing/m-p/660390#M675337 <HTML><HEAD></HEAD><BODY><P>Hey, I have Microsoft SQL Server Standard, 11.0.3412.0 database. I have created custom schema.</P><P>If I use Microsoft SQL Server Management Studio, I can see my custom schema tables and views.</P><P>Also all queries work well.</P><P></P><P>I use QlikView 11.20.12235.0 SR5 64-bit Edition.</P><P>QlikView can access the database. However, I cannot see custom schema in QlikView.</P><P>I can see only dbo and sys schema, but not custom schema...</P><P></P><P>Data Source: demoserver</P><P>Database: DB_demo</P><P>Owner: dbo / sys </P><P></P><P></P><P>What is reason for this? Any help?</P></BODY></HTML> Fri, 11 Jul 2014 10:48:42 GMT 2014-07-11T10:48:42Z QlikView & MS SQL schema missing https://community.qlik.com/t5/QlikView/QlikView-MS-SQL-schema-missing/m-p/660390#M675337 <HTML><HEAD></HEAD><BODY><P>Hey, I have Microsoft SQL Server Standard, 11.0.3412.0 database. I have created custom schema.</P><P>If I use Microsoft SQL Server Management Studio, I can see my custom schema tables and views.</P><P>Also all queries work well.</P><P></P><P>I use QlikView 11.20.12235.0 SR5 64-bit Edition.</P><P>QlikView can access the database. However, I cannot see custom schema in QlikView.</P><P>I can see only dbo and sys schema, but not custom schema...</P><P></P><P>Data Source: demoserver</P><P>Database: DB_demo</P><P>Owner: dbo / sys </P><P></P><P></P><P>What is reason for this? Any help?</P></BODY></HTML> Fri, 11 Jul 2014 10:48:42 GMT https://community.qlik.com/t5/QlikView/QlikView-MS-SQL-schema-missing/m-p/660390#M675337 2014-07-11T10:48:42Z Re: QlikView & MS SQL schema missing https://community.qlik.com/t5/QlikView/QlikView-MS-SQL-schema-missing/m-p/660391#M675338 <HTML><HEAD></HEAD><BODY><P>Here is solution for this problem:</P><P>I removed old ODBC Data Source and I remade it again.</P><P>It finds now all schema.</P></BODY></HTML> Fri, 11 Jul 2014 11:16:03 GMT https://community.qlik.com/t5/QlikView/QlikView-MS-SQL-schema-missing/m-p/660391#M675338 2014-07-11T11:16:03Z Re: QlikView & MS SQL schema missing https://community.qlik.com/t5/QlikView/QlikView-MS-SQL-schema-missing/m-p/660392#M675339 <HTML><HEAD></HEAD><BODY><P>Hi Jack, </P><P><BR />Perhaps this thread could help.</P><P><A href="https://community.qlik.com/message/516891">Re: Data Dictionary for SQL Server</A></P></BODY></HTML> Fri, 11 Jul 2014 11:18:02 GMT https://community.qlik.com/t5/QlikView/QlikView-MS-SQL-schema-missing/m-p/660392#M675339 2014-07-11T11:18:02Z