MYSQL Connection

[IanWaterman]

CR2008

Just installed CR2008 and can not work out how to connect to my local MySQL database.

I do not appear to have an ODBC connection in in my ODBC sources in control panel so have concluded I need to use JDBC.

But in the BO Knowledge Base I can only find references to connection to SQL Server. In the JDBC Connection

I need a connection URL, in the KB it shows an example as

com.microsoft.jdbc.sqlserver.//Servernameort#

I know my server name is localhost and port is 3306.
But I have no idea how to set up the first part of the connection string.

Similarly not sure where I find database class name.

I can connect and query database using MySql Administrator. and I can build reports using another Java tool called Pentaho. Just can't work out how to get Crystal to connect.

Thank you

Ian

 

[IanWaterman]

Hi

Made some progress by looking at the XML connection for Pentaho

Have now updated the CRConfig.xml located here.
C:\Program Files\Business Objects\Common\4.0\java
now includes

<JDBC>
<CacheRowSetSize>100</CacheRowSetSize>
<JDBCURL>jdbc:mysql://localhost:3306</JDBCURL>
<JDBCClassName>com.mysql.jdbc.Driver</JDBCClassName>
<JDBCUserName>root</JDBCUserName>


Now when I click the JDBC connection The connection URL and Class name are automatically populated with the above data.

Similarly when I click next the Dialog boxes are showing following

Database - Localhost:3306
UserId - root

However Server is blank and nothing can be entererd.
Can only enter password.

However when click finish I get error

Unknown Database connector error.

So I guess I need to register the class name somewhere

com.mysql.jdbc.Driver

Any suggestions

Ian