Microsoft Access DataBase Engine not properly installed?

dataservices administration
1

Brand new install:
[list]MS Windows Server 2008 R2 Standard SP1
MS Office Professional Plus 2010
Microsoft Access DataBase Engine 2010 SP1
SAP DS 4.0 SP2 Patch 4[/list] Excel works fine, but every time a DS job tries to read an Excel file, it returns an error:
[list]OLE or COM processing error. Please make sure Microsoft Access DataBase Engine is properly installed: .[/list]Anybody any idea?

klo3010 :belgium: (BOB member since 2009-08-03)

2

Most problems with reading Excel is that there are protected sheets, columns etc. Or freezed panes. Or filters etc.

So make your sheet as simple as possible and try it again.

Or test it with a very plain sheet first.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

3

I don’t think it is a privilege error!!!

How did you installed? Office first and then DS or the other way round?

And, did you restarted the server after the installation?

ganeshxp :us: (BOB member since 2008-07-17)

4

Office is not a requirement for reading excel files. Unless an install of office confuses BODS?

Johannes Vink :netherlands: (BOB member since 2012-03-20)

5

The same error for any type of sheet.
And the install order doesn’t matter either. Office was installed first. But the error hasn’t gone away after a reinstall of Office and of the Microsoft Access DataBase Engine. Re-boot was mandatory after the latter install. Didn’t help.

klo3010 :belgium: (BOB member since 2009-08-03)

6

This is what I read in Software Dependencies of Installation Guide.

ganeshxp :us: (BOB member since 2008-07-17)

7

Ah I see… thanks for that :slight_smile:

With a default install of BODS without any Office install it works fine as the Access engine comes with the BODS install.

Johannes Vink :netherlands: (BOB member since 2012-03-20)