Skip to Content
0

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

Jan 20, 2017 at 01:58 PM

368

avatar image

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)
error.jpg (100.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jan 20, 2017 at 02:32 PM
0

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.

Show 4 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

1

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

0

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

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

1