7038: Test metadatabase connection failed

Niklas
Niklas
edited February 11, 2022 in Analytics #1
<p>Hello,</p><p> </p><p>I've installed BIRT iHub on my Windows 7 64bit notebook. Everything works fine.</p><p> </p><p>Now I want to connect an external metadata-database. In my case it's a MySQL-Database, managed by the MySQL Server of XAMPP. I've also configured the jdbc driver (added CLASSPATH).</p><p> </p><p>I can connect and work with my database perfectly with tools like MySQL Workbench and phpmyadmin. If I want to use it as metadata-database, the connection fails.</p><p> </p><p>All parameters which have been set are correct but if I click on "test connection" the following message appears: <strong>(!) 7038: Test metadatabase connection failed.</strong></p><p> </p><p>Can someone help me?</p><p> </p><p>Thank you,</p><p>Niklas</p>

Comments

  • Niklas
    Niklas
    edited May 24, 2014 #2
    No ideas? I really need your help until tuesday.

    Please help me, if you need more informations, ask me.

    Do somewhere exist a documentation about the error numbers?


    Thanks Niklas
  • mwilliams
    mwilliams
    #3
    <p>Sorry for the delay. You're getting this error in BIRT Designer Pro when creating reports to deploy to the iHub? Or somewhere else? Let me know.</p>
    Warning No formatter is installed for the format ipb
  • Niklas
    Niklas
    #4
    <p>Thanks for your answer. </p><p> </p><p>No, I'm getting this error when I what to change the metadatabase in the system console to a MySQL database. I want to use these datas instead of the datas in the internal PostgreSQL database.</p><p>I belive there's an error with the jdbc driver. How I can configure it?</p><p> </p><p>I've added a screenshot.</p><p> </p><p><img src='http://i.imgur.com/35Q9djT.jpg' alt='Posted Image' class='bbc_img' /></p>
  • mwilliams
    mwilliams
    #5
    <p>MySQL is not an option for use as a metadata db, it looks like. SQLServer that you have selected is for Microsoft SQLServer. I don't see a way to add another db type. I'll have to investigate this further and let you know if I find anything out.</p>
    Warning No formatter is installed for the format ipb
  • jneneman
    jneneman E
    #6
    <p>Hi Nicklas,</p><p> </p><p>For iHub3 the options for your metadatabase are PostgreSQL and Oracle.  We have a change request in the works to remove the other options.</p><p> </p><p>Regards,</p><p>Jeffrey Neneman</p><p>[color=rgb(0,0,0);font-family:arial, sans-serif;]Actuate Corporation – The BIRT Companyâ„¢[/color]</p><p>[color=rgb(0,0,0);font-family:arial, sans-serif;]<a data-ipb='nomediaparse' href='http://www.actuate.com'>http://www.actuate.com</a&gt; | <a data-ipb='nomediaparse' href='http://www.birtondemand.com'>http://www.birtondemand.com</a>[/color]</p&gt;
    Warning No formatter is installed for the format ipb

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs