No suitable driver found when preview universe mysql query on Web Intelligence

[Former Member]

Hi

    I'm a freshman for BO.

    I install the BO 4.0, OS is Window7. and create the connection on universe, but connect is failure and pop up the error, no driver is available,  so I add the system property with classpath=".......mysql_driver.jar", restart the Universe, the connect will be OK. Then I create the query successfully and view the table values will get the DB data correctly.

    I open Web Intelligence to create report use I created query on universe, but if I preview the query, popup the no driver again. Dose anybody tell me where could config the driver for Web Intelligence? Thanks very much.

[Former Member · Accepted solution]

Thansks your help,

I resolved this problem, by config the mysql.sbo file which under

C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc folder.

But still have two problem:

One, if I used my jdbc driver, and how to delegate the system property to jvm? Such as my driver initialize need some properties like "home", etc. Set the properties on Window-System is useless for this case.

Second, if the table name contains ".", universe will quote the table name with "`", where could config this property? I try to config it on "jdbc.sbo" with <Parameter Name="Identifier Quote String">&quot;</Parameter>, but useless.

Thanks

[former_member188911 · Accepted solution]

For the two new problems you should please create separate threads in the Semantic Layer discussions

Thanks

Simone

[Former Member · Accepted solution]

OK, I create new issue about new problem.

Thanks

[former_member188911]

You should install both 32 and 64 bit drivers and create connections for both architectures with the same name, this is explained in the installation manuals that you can find at http://help.sap.com/boall_en

thanks

SC

[Former Member]

were you able to test the universe connection as successful?

What driver are you using in the connection?

Thanks

Mallik

[harshil_joshi]

Can you please attach a snapshot ? ? ?