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: 
Not applicable

Connection to .accdb file not reloading from Management console

I've been having this problem for quite some time now.

My reload attempts from the Qlikview Management Console to an .accdb database fails. I created a system odbc for .mdb and .accdb microsoft access files.When building the script, I have the "Force 32 bit" ticked on. The connection example: ODBC CONNECT32 TO [testdb ;DBQ=B:\directory\testdb.accdb];

If i reload from my machine, it works, but not from the management console.

Any ideas or recommendations?

18 Replies
Not applicable
Author

I don't know i u have spoke about this, but reloading service runs as a user define during the installation... That user is ok?

Otherwise u can try to change tha in windows service management.

C u,

Stefano.

bnichol
Specialist
Specialist

Did you resolve your issue reloading through a QEMC task?

I'm upgrading from QV9 to QV10 and was hoping to use publisher instead of calling QV.exe(32 bit), but I'm experiencing the same issue as you.

Any information would be appreciated.

B

Not applicable
Author

HI there,

The only way I could get it to work was by moving the .accdb database to the server on which QEMC resides.

Create a Microsoft Access ODBC to the .accdb database.

In your script connect to the odbc with “force 32 bit”.

Hope it helps!

Regards,

Lambert Badenhorst

IT Department

Bertie van Zyl (Edms) Bpk

ZZ2 LICENSE STICKER2_60

Hierdie e-pos is uitsluitlik bedoel vir die geadresseerde – Met die oopmaak daarvan word aanvaar dat die volledige kennisgewing soos beskikbaar op die skakel <http://zz2.biz/BvZEposVrywaring.htm> http://zz2.biz/BvZEposVrywaring.htm deur geadresseerde gelees en aanvaar is

This e-mail is solely intended for the addressee. By the opening thereof it is assumed that the full notice as set out in <http://zz2.biz/BvZMailDisclaimer.htm> http://zz2.biz/BvZMailDisclaimer.htm has been read and accepted by the recipient

bnichol
Specialist
Specialist

I forced 32bit using an ODBC connection, but I'm unable to move the database onto the server.

Does the database need to be on the QlikView server?  Are there any alternatives?

Thanks,

B

Not applicable
Author

As far as I’m concerned, the db has to be on the qlik server.

Regards,

Lambert Badenhorst

IT Department

Bertie van Zyl (Edms) Bpk

j0349986 +27 82 574 4693

( +27 15-395 8402

Ê +27 86 662 6421

ZZ2 LICENSE STICKER2_60

Hierdie e-pos is uitsluitlik bedoel vir die geadresseerde – Met die oopmaak daarvan word aanvaar dat die volledige kennisgewing soos beskikbaar op die skakel <http://zz2.biz/BvZEposVrywaring.htm> http://zz2.biz/BvZEposVrywaring.htm deur geadresseerde gelees en aanvaar is

This e-mail is solely intended for the addressee. By the opening thereof it is assumed that the full notice as set out in <http://zz2.biz/BvZMailDisclaimer.htm> http://zz2.biz/BvZMailDisclaimer.htm has been read and accepted by the recipient

Not applicable
Author

Hi,

We have a few Qlikview applications reloading from .accdb files (access 2007) that do not reside on the Qlikview server.  We have Qlikview version 10.  I'm not sure of all of the specifics of the server, but we are using CONNECT32 in the scripts, and we also had to make sure that the user id used to log on to the qlikview server and management console has permissions to the folder where the access database resides.

Our server administrator is out for the holidays, but after that I can put someone in contact with him if we can help?

Happy Holidays!!

Karen

Not applicable
Author

Hi Karen,

I've tried those things you suggested.

Help would be very much appreciated:)

Regards,

Lambert Bandehorst.

Not applicable
Author

Hi Lambert!

Our server guy is out of town this week, but I’d be happy to look at your connect statement for starters and see if I see anything.

Here’s one mistake that we make sometimes… hate to state the obvious, but you never know? Sometimes I use a drive letter mapping in the path to my access database while I’m developing and forget to change it to the full path for production… have you checked that?

Karen

Not applicable
Author

Hi Karen,

Thanks for the hint.

Just to refresh your mind.

We want to establish a connection to a .accdb database residing on a different server than our qlikserver. I use the connect32 statement. i establish a connection when using the desktop version from our qlikserver, but when scheduling it with QEMC it fails.

I'm currently going through a couple of things(permissions on the other server etc.) with a consultant.

Regards,

Lambert Badenhorst.