Data selection wizard shows no table when connecting to SQL Server

[Sonja_Bauernfeind]

When creating ODBC/ OLE DB connection from QlikView to SQL Server, data selection wizard in QlikView successfully fetches database and owner lists, but shows no table to select. This happens if the database (schema) name contains a dot (.) character, for example qlikview.1.1.


 

Cause:

This type of issue happens not only to QlikView, but with any OLE DB/ OBDC connection to SQL server. For example, similar issue can be seen when using the same ODBC connection in Excel:



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-is... for more related discussions.

Environment: All QlikView versions 

Resolution:

A work-around solution is to quote the database name with square brackets [ ], for example

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.