topic Re: connecting to sql server problem in QlikView

connecting to sql server problem

Daniels92 — Mon, 26 Jan 2026 21:26:37 GMT

Hi everyone, I have a problem with connectng to sql server. If I connect through OLE DB driver I don't have any issues but if I use ODBC I can't see database table's.

I have configured a schema in my sql server database ("DW"). I don't see this schema if I use ODBC:

I can't ee my tables I can't see nothing! Thank you for your help.

Daniele

PS: sorry for my bad english.

Re: connecting to sql server problem

Lucas_Gatling — Mon, 22 Feb 2021 17:43:39 GMT

What version of QlikView are you currently using?

Re: connecting to sql server problem

Daniels92 — Mon, 22 Feb 2021 18:30:14 GMT

My version is QlikView April 2020 SR4 - Version 12.50.20400.0

Re: connecting to sql server problem

Lucas_Gatling — Mon, 22 Feb 2021 18:42:43 GMT

Have you tried removing the data source schema, and then recreating it to see if the ODBC connection finds it? If not try that.

Re: connecting to sql server problem

Daniels92 — Mon, 22 Feb 2021 20:37:40 GMT

Ok, if I change table's schema, qlikview is able to see the table in the db. So I suppose the issue is on the schema I created. It's very strange.