Data selection wizard shows no table when connecting to SQL Server

Sonja_Bauernfeind — Mon, 14 Sep 2020 14:44:28 GMT

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-issue/23110264#23110264 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.

article Data selection wizard shows no table when connecting to SQL Server in Official Support Articles

Data selection wizard shows no table when connecting to SQL Server

Cause:

Resolution: