Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Specialist III
Specialist III

Hi,

You can run in debug mode and see.

Does it get past the connection string.

thanks,

Rajesh Vaswani

Highlighted
Creator
Creator

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.

Highlighted
Creator
Creator

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.

Highlighted
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