Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
zagzebski
Contributor

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
MVP & Luminary
MVP & Luminary

Re: Not Loading from access dbase

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
Valued Contributor III

Re: Not Loading from access dbase

Hi,

You can run in debug mode and see.

Does it get past the connection string.

thanks,

Rajesh Vaswani

zagzebski
Contributor

Re: Not Loading from access dbase

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
Contributor

Re: Not Loading from access dbase

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
Valued Contributor III

Re: Not Loading from access dbase

Hi,

Access normally needs Microsoft OLEDB Jet 4.0 Driver.

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

thanks,

Rajesh Vaswani