topic Re: Connection to .accdb file not reloading from Management console in QlikView

Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 10:31:38 GMT

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?

Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 10:36:14 GMT

Hi,

have you insert section access?

In this case you have to insert credential in management console.

C u,

Stefano.

Re: Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 10:39:24 GMT

no i don't have any section access, i actually tested it by just adding the connection fist, for example: ODBC CONNECT 32 TO [testdb;DBQ=B:\directory\testdb.accdb];

it does'nt like the connection or something.

Connection to .accdb file not reloading from Management console

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 10:39:34 GMT

Hi Lambert,

Does that path "B:\directory\testdb.accdb" exist in the Server? If not, you will need to use a UNC path pointing to the shared folder where the testdb.accdb is (something like \\server\sharedresource\file ) Does the folder and the file have modify permissions for the user the QlikView services are running under?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Connection to .accdb file not reloading from Management console

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 10:41:21 GMT

Lambert,

Apart from what I mention below, is the QlikView Server version 10? In version 9 the connection strings are different, so if you are developing using QlikView Desktop 10, but your Server is version 9 you will need to change the connection string. You will need to create the ODBC in the server as well.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 10:52:08 GMT

Hi,

some log message from the managemet could be useful.

C u,

Stefano.

Re: Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 11:05:48 GMT

Hi Miguel,

The path B:\ does exist and does have full permission to the directory where the db is. I use qlikview version 10 on desktop and our server is also 10.

Does it not maybe have something to do with the fact that the qlikview server is 64 bit and the server where the access db resides is 32 bit?

Lambert.

Re: Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 11:06:07 GMT

Hi Miguel,

The path B:\ does exist and does have full permission to the directory where the db is. I use qlikview version 10 on desktop and our server is also 10.

Does it not maybe have something to do with the fact that the qlikview server is 64 bit and the server where the access db resides is 32 bit?

Lambert.

Connection to .accdb file not reloading from Management console

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 11:13:29 GMT

Hi Lambert,

In version 10, as opposed to previous versions, you don't need to install the 32 bit version of QlikView Desktop or Server depeding on the architecture of your driver, and that's why you can force it to be 32 bit or 64 bit. What may be happening is that you don't have Office drivers in your Server (you can download the package here), so the ODBC cannot be created. As far as I know, there are no 64 bit Access drivers in version 2007, but there are for version 2010 here. Is that possible?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 11:36:49 GMT

Thanks,

I'm going to try some things and let you know.

Regards,

Lambert.

Re: Connection to .accdb file not reloading from Management console

Tue, 04 Oct 2011 12:12:00 GMT

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.

Connection to .accdb file not reloading from Management console

bnichol — Thu, 08 Dec 2011 14:19:07 GMT

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.

Re: Connection to .accdb file not reloading from Management console

Fri, 09 Dec 2011 05:13:58 GMT

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

Re: Connection to .accdb file not reloading from Management console

bnichol — Fri, 09 Dec 2011 12:48:16 GMT

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,

Re: Connection to .accdb file not reloading from Management console

Wed, 21 Dec 2011 11:15:57 GMT

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

Connection to .accdb file not reloading from Management console

Wed, 21 Dec 2011 13:51:49 GMT

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

Re: Connection to .accdb file not reloading from Management console

Mon, 16 Jan 2012 09:21:51 GMT

Hi Karen,

I've tried those things you suggested.

Help would be very much appreciated:)

Regards,

Lambert Bandehorst.

Connection to .accdb file not reloading from Management console

Thu, 19 Jan 2012 01:10:18 GMT

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

Re: Connection to .accdb file not reloading from Management console

Thu, 19 Jan 2012 05:46:48 GMT

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.