topic Re: Not Loading from access dbase in QlikView

Not Loading from access dbase

zagzebski — Tue, 10 Sep 2013 11:35:42 GMT

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?

Re: Not Loading from access dbase

Gysbert_Wassenaar — Tue, 10 Sep 2013 16:51:57 GMT

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.

Re: Not Loading from access dbase

rajeshvaswani77 — Tue, 10 Sep 2013 18:04:15 GMT

Hi,

You can run in debug mode and see.

Does it get past the connection string.

thanks,

Rajesh Vaswani

Re: Not Loading from access dbase

zagzebski — Tue, 10 Sep 2013 18:23:50 GMT

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.

Re: Not Loading from access dbase

zagzebski — Tue, 10 Sep 2013 18:58:39 GMT

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.

Re: Not Loading from access dbase

rajeshvaswani77 — Wed, 11 Sep 2013 03:25:41 GMT

Hi,

Access normally needs Microsoft OLEDB Jet 4.0 Driver.

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

thanks,

Rajesh Vaswani