8 Replies Latest reply on Jun 18, 2018 9:09 AM by shawkins

    Error Connecting to Teiid (9.0.1) via ODBC

    jrod2016

      Hi,

       

      I get the following error while connecting to Teiid via odbc:

       

      DataSource.Error: ODBC: ERROR [50000] ERROR: TEIID31100 Parsing error: Encountered "[*]from[*] \"adfcorevdb\".\"TestDallas\".\"Product_Catalog\"" at line 1, column 1.
      Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
      org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "[*]from[*] \"adfcorevdb\".\"TestDallas\".\"Product_Catalog\"" at line 1, column 1.
      Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" |
      ERROR [50000] "merge" ...;
      Error while executing the query
      Details:
          DataSourceKind=Odbc
          DataSourcePath=dsn=PostgreSQL35W
          OdbcErrors=Table
      

      I have installed the 64-bit Windows odbc driver as specified here: Chapter 7. ODBC Support

       

      I am using PowerBI as a client. The problem seems to be that the odbc client is issuing a partial sql command while previewing the View

      error-snapshot.png

       

       

      So, the preview is issuing

      " from adfcorevdb.TestDallas.Product_Catalog"
      

      instead of

      "Select * from adfcorevdb.TestDallas.Product_Catalog"
      

       

      Any suggestions/ideas? Could this be a driver issue?

       

      Thanks,

      John