Forum Discussion

ldelataille's avatar
ldelataille
New Member
8 years ago

Problem with connection to Sybase IQ database

Hi everyone, I want to connect Power Bi to a Sybase IQ database but when I fill the connection form in the Sybase connector with the Server Name and the database name, a strange error appear. I've...
Need Help
ldelataille's avatar
ldelataille
New Member
8 years ago

Hi Angelia.

Thank you for your reply.

Yes, I installed the SQL Anywhere Driver on my computer, and I followed all the steps that you mentioned. I can access to the connector and fill the identification form but I have an error on the "count parameter". I don't know what it means.

 

Hundreds of Users in my enterprise will use Power BI after this test and I want the procedure to be as easy as possible. That's why I want to use the "Sybase Database Connector" and avoid if possible the use of the ODBC connector.

 

Do you have any idea of what this "count parameter" means in this case ?

Thank you in advance.

Lancelot.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello there!!

 

Did you find the issue ?? I am giving it a try ...

 

PY

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Folks

     

    I htink I have the solution...or at least the track to follow

    SAP provided an OSS note (2491889) which explains that there is probably a bug in the network client. 

    I did not have the chance to test, but I guess, the correction needs to be apply on the server side.

     

    So, the way to connect to SAP IQ without issue is to use ODBC connection defined at the OS level after SQL anywhere has been installed. 

    Then it works...

     

    PY