Data selection wizard shows no table when connecting to SQL ServerArticle Number: 000048672 | Last Modified: 2019/01/17
Root cause is that the dot character breaks the interpretation of full table name (database.owner.tablename). This is therefore a native issue of SQL server and the ODBC driver rather than QlikView.
Refer to https://stackoverflow.com/questions/23110263/could-not-find-server-db-name-in-sys-servers-not-dbo-issue/23110264#23110264 for more related discussions.
Environment: All QlikView versions
SQL SELECT * FROM [qlikview.1.1].dbo.sqlwb;
You will need to compose the SQL statement manually without assistance from the data selection wizard though.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.