Forum Discussion

domagoj's avatar
domagoj
New Member
7 years ago

informix connector error

I am using latest veriosn of Power BI desktop.

My informix server is on windows with DRDA support.

 

I can conenct initaialy and see the list of tables, when I select even only one table, preview never finishes.

I f I click OK then Load screen also never finnishes, I can only click cancel.

 

Later in query editor I can see some syntax errors.

 

DataSource.Error: Microsoft Informix Client: A syntax error has occurred. SQLSTATE=42000 SQLCODE=-201
Details:
    DataSourceKind=Informix
    DataSourcePath=infdb.du.laus.hr;argosy4sdr
    Message=A syntax error has occurred. SQLSTATE=42000 SQLCODE=-201
    ErrorCode=0

 

After many  hours of playing I connected to one of my databases, only diference is that database name is 8 characters long.

***** Is it possible that if name of database is longer thatn 8 chars you  cant connect ?  *****

 

 

 

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi domagoj,

     

    From the error message, it prompted that there might existing some syntax error in your SQL statement. This article shows that such an error can be returned from SQLExecDirect, SQLExecute, SQLPrepare, SQLSetPos. Please run your SQL statement in informix  database itself to find the root cause.

     

    Regards,

    Yuliana Gu

    • domagoj's avatar
      domagoj
      New Member
      7 years ago

      That SQL is generated by Power BI in process of connecting to data soruce, I have no control over it.

       

      As I said it workd with databse whic name is 8 chars or less.

      But that doent make sense, because , on database which has more than 8 chars in databse name it gives the list of tables.

      Does the 8 char limit goet to table name also, I should investigate.....

       

      However is there solution to this limitation ???