Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniels92
Contributor II
Contributor II

connecting to sql server problem

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.

Daniels92_0-1614006153457.png

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

Daniels92_1-1614006264842.png

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

Daniele

PS: sorry for my bad english.

 

Labels (1)
1 Solution

Accepted Solutions
Lucas_Gatling
Support
Support

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

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

4 Replies
Lucas_Gatling
Support
Support

What version of QlikView are you currently using?

If the issue is solved please mark the answer with Accept as Solution.
Daniels92
Contributor II
Contributor II
Author

My version is QlikView April 2020 SR4 - Version 12.50.20400.0

Lucas_Gatling
Support
Support

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

If the issue is solved please mark the answer with Accept as Solution.
Daniels92
Contributor II
Contributor II
Author

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.