topic Re: Re: Connect to Ms Access files? in QlikView

Connect to Ms Access files?

Tue, 04 Nov 2014 11:16:18 GMT

Hi All,

I have one question.

Can we connect to Ms access data files (.mdb files) which is stored in different server. can we get data from different server?

if yes what are the details required to connect to Ms access database?

Thanks,

Ashok.

Re: Connect to Ms Access files?

ashfaq_haseeb — Tue, 04 Nov 2014 11:19:19 GMT

Hi,

Use complete UNC path.

Regards

ASHFAQ

Re: Connect to Ms Access files?

Tue, 04 Nov 2014 11:24:24 GMT

Hi Mohammed,

Can u elobrate this clearly.

Thanks,

Ashok.

Re: Connect to Ms Access files?

Peter_Cammaert — Tue, 04 Nov 2014 11:26:49 GMT

An UNC path is something like:

\\servername\pathtofiles\database.mdb

Before you can use this kind of path, the database directories must be shared on your network by Windows. See Directory->Properties->Security&Sharing

Re: Re: Connect to Ms Access files?

ashfaq_haseeb — Tue, 04 Nov 2014 11:37:39 GMT

Hi,

Check the attached file with connecting strings

1st one locally

Second one from shared server.

Regards

ASHFAQ

Re: Connect to Ms Access files?

Tue, 04 Nov 2014 11:42:35 GMT

Tx for ur reply,

for that we need to install Ms office software in both server or only enough in storage server.

example:

server1: having mdb files

server2: reading data from server1. in server2 need to install Ms office or not required.

Thanks,

Ashok.

Re: Connect to Ms Access files?

ashfaq_haseeb — Tue, 04 Nov 2014 11:51:38 GMT

No need to install MS office

Enough in storage server

Regards

ASHFAQ

Re: Re: Connect to Ms Access files?

Tue, 04 Nov 2014 12:06:39 GMT

Don't consider this as a silly qusetion.

If we don't install in server2 then how we will create connection string because when we connecting through OLE DB it's not showing that option "OLE DB Provider for MS Access".

See below image in server MS Office not installed.

Re: Connect to Ms Access files?

Peter_Cammaert — Tue, 04 Nov 2014 12:06:45 GMT

If you're asking this question because otherwise you will not be able to configure an OLEDB/ODBC connection to the MS Access database files, then don't worry. You won't need MS Office anywhere.

The ODBC/OLEDB drivers can be downloaded from the Microsoft download site.

Re: Re: Re: Connect to Ms Access files?

ashfaq_haseeb — Tue, 04 Nov 2014 12:14:23 GMT

Hi,

Make sure you select force 32 bit.

OLEDB jet 4.0 comes by default.

If not available then go for Microsoft access database engine drivers.

And you don't need office to be installed to make connection.

Have a look at attached image.

All you have to make sure is your storage folder is accessible from Qlikview server.

Regards

ASHFAQ

Re: Re: Connect to Ms Access files?

Tue, 04 Nov 2014 12:18:12 GMT

SO without connection string how will bring data from other server?????

can u write in steps wise i can understand easly.

Thanks,

Ashok.

Re: Re: Connect to Ms Access files?

ashfaq_haseeb — Tue, 04 Nov 2014 12:21:26 GMT

You need connecting String.

I have for two scenarios.

.MDB file available locally and available on server.

Check for the Notepad attachment in one of my reply to this post.

Regards

ASHFAQ

Re: Connect to Ms Access files?

Peter_Cammaert — Tue, 04 Nov 2014 12:23:11 GMT

You will still need a connection string, of course. But to assemble the connection string in QlikView, you only need proper ODBC/OLE DB drivers installed on your current machine (or on the server if you publish your document on QVS). Download and install the correct ODBC/OLEDB drivers from the microsoft download site.

Once these have been installed, the connect button in the script editor will list new interface, just like when MS Office is installed. Create a connection string from thereon.

Not that OLE DB is simpler than ODBC to setup. For an ODBC connection, you need to first configure one in your machines control panel.

Best,

Peter

Re: Re: Connect to Ms Access files?

Tue, 04 Nov 2014 12:29:58 GMT

Yes,i saw that

my question is when we don't have "OLE DB provider for MS Access" then what needs to select in those provisers list because MS office not installed.

without having that provider how we need to create string.

Re: Connect to Ms Access files?

ashfaq_haseeb — Tue, 04 Nov 2014 12:36:28 GMT

As I say select force. I attached 1 image too.

follow that select Microsoft jet 4.0 OLEDB provider.

If not available download access drivers (Microsoft access database engine ) from Microsoft site.

Hope it helps

Regards

ASHFAQ

Re: Re: Connect to Ms Access files?

its_anandrjs — Tue, 04 Nov 2014 12:37:30 GMT

Hi,

If you have no OLE DB provider you can try with ODBC because in windows ODBC provider available and from there you can access ODBC data source in qlikview by click on User DSN

Regards

Anand

Re: Connect to Ms Access files?

Peter_Cammaert — Tue, 04 Nov 2014 13:34:06 GMT

Install this (either 32-bit or 64-bit version)

Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center

and you will be on your way.