The database SQL generation parameters file could not be loaded (MS Access 2007, ODBC) LINUX

[Former Member]

Hi,

I've installed SAP BO SP3 on opensuse11 and when I'm trying to "RUN QUERY"

I got following error:

The database SQL generation parameters file could not be loaded (MS Access 2007, ODBC)

[amitrathi239 · Accepted solution]

Linux is not supported MS Access drivers.In case if you want to run the efashion based queries from BI Launch Pad it's not going to be work.

If you want to run the reports with efashion universe then follow these steps.

1)copy the e-fashion MDB file in your local system.

2)Create efashin DSN in your system.

3)Import the universe and test the connection.

4) open Rich client and run reports.

With above steps you can run the reports only from Rich client.with BI launch Pad it's not going to work.

[Former Member · Accepted solution]

Thank you sir, but could you tell me how can I do the 2 and 3 points?

[amitrathi239 · Accepted solution]

Check if efashion.mdb file is placed under the "installation location\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Samples\Webi" in your local system.If yes then create the ODBC connection, select the driver for Microsoft Access Driver (*.mdb), on the windows machine. Once its done, then select the efashion mdb file in the ODBC connection.. once its done, the connection is ready. in the efashion universe connection under the data source enter the same ODBC setup name.Like if you have created ODBC with name efashion then same name enter the universe connection.

if efashion.mdb file is not placed on this location then copy from the server and place in your system location."installation location\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Samples\Webi".After that follow above steps.

https://www.youtube.com/watch?v=p6iBntoYGOQ

[Former Member · Accepted solution]

So what for is Linux installation? For HANA? or some others database formats we can use in Linux?

[amitrathi239 · Accepted solution]

Yes these are supported.limitation is with Microsoft drivers..

https://archive.sap.com/discussions/thread/3216765