Skip to Content

Trouble connecting to MySQL database

We are on 4.1 SP01 Patch 2. I am trying to create a universe based on a MySQL database that is version 5.1.61. I am using an ODBC data source to connect. My desktop where I am running the Information Design Tool is a 64-bit machine with Windows 7 Professional. The server where the CMS is installed is also a 64-bit machine and has Windows Server 2008 R2 Enterprise Service Pack 1.

It seems that I could only create a new Relational Connection if I had a 64-bit ODBC data source on the server. When I clicked the "Test Connection" button as part of the connection creation process it was successful. However, when I opened my newly created connection and clicked the "Test Connection" button it failed.

So I created a 64-bit ODBC data source on my desktop and then when I clicked "Test Connection" it failed again, but for a different reason.

Then I created a 32-bt ODBC data source and clicking the "Test Connection" button results in success.

I also created a Relation Connection Shortcut based on this new relational connection with that same errors along the way and ultimate success.

So things should be good to go, right?. I created a Data Foundation based on the relational connection shortcut. That seemed to work fine, but when I attempt to explore the data foundation I get a cryptic error message, "Error on FreeCursor".

I created a 32-bit ODBC data source on the server, but that made no difference.

So I have two basic questions.

1. Why do I need a 64-bit ODBC data source on the server, but a 32-bit one on my machine?

2. How do I get past this "Error on FreeCursor" error?

Thanks,

Noel

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2014 at 08:18 PM

    Can you check if the user id has all the access to the schema and tables in mysql database? Normally when the connection is established there should not be any more issue while connecting a universe..

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Noel,

      I don't care much about points, I am just happy when I am able to help.

      The information you were looking for are in the PAM - Supported Platforms document.

      You can access them either from https://service.sap.com/pam or from this document BI4.0 Web Intelligence Document Roadmap

      I will probably create a wiki page on how to consume this document, in the meantime I try to give a general explanation here

      Once you open the Supported Platforms document, you need to find the Semantic Layer section, where there is a hyperlink to the document for the supported reporting databases.

      This is an excel spreadsheet, there are different tabs depending on the type of connectivity.

      As you get familiar with it you will find surprising things... what methods are supported and which are not, helpful additional information and so on.

      Thanks!

      Simone

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2014 at 06:38 PM

    The BI 4.1 is a 64 bit installation so it only uses 64 bit ODBC ... However all the client tools including the IDT are 32 bit in nature so when you are trying to connect from your machine using IDT it will need a 32bit ODBC to connect to the database..

    Hope that clarified the first question...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 21, 2014 at 06:32 PM

    Anybody have any thoughts on this?

    Noel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.