Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Not Loading from access dbase

I had several files QVW's loading from an access database with OLEDB connection.

Simply

Load

field, 1,

fiield 2,

field 3

SQL Select

field, 1,

fiield 2,

field 3

From Products;

When I step through it makes it past the connection string and Set variables on the main page but when it gets to the SQL statement it just sits there forever until I force close the file. Any ideas. It was working before this. I know they did some maintenance on the server - could something have happened?

5 Replies
Gysbert_Wassenaar

Try loading only 100 records to check if it loads anything at all:

First 100

Load Field1, Field2, Field3;

SQL Select Field1, Field2, Field3 from Products;

You can also try using the connection wizard to check if you can connect to the database server to make sure you can actually connect.


talk is cheap, supply exceeds demand
rajeshvaswani77
Specialist III
Specialist III

Hi,

You can run in debug mode and see.

Does it get past the connection string.

thanks,

Rajesh Vaswani

zagzebski
Creator
Creator
Author

Thanks, yes I did run it in debug and it made it past hte connection but then got stuck on the SQL call to the access database.

zagzebski
Creator
Creator
Author

Yeah still doesn't get me anywhere. Thanks for the feedback. I am going to create a brand new file and see if I can get anything to return from one of the tables in the Dbase.

rajeshvaswani77
Specialist III
Specialist III

Hi,

Access normally needs Microsoft OLEDB Jet 4.0 Driver.

Hope you are using the correct driver in your connection string.

thanks,

Rajesh Vaswani