JBossDeveloper

That explains the issue then. That is not a valid statement. Teiid allows SELECT {expression} but not SELECT {table|view} without FROM clause. I am not sure how other databases allow it?

What is the Teiid version you are using?

Can also add

<logger category="org.teiid">
      <level name="TRACE"/>
 </logger>

to standalone-teiid.xml file under "logging" subsystem and restart the server and re-run the use case and attach the server.log file? I think excel is submitting something like "SELECT [] [MSSQLServerAdventureWorksview]" or "SELECT [*] [MSSQLServerAdventureWorksview]" either one of them is wrong syntax for Teiid. But I am uncertain how other databases are handling this (ignore MS-SQLServer, like mysql or Postgres)? It would be super if you got Postgres database, if you could add this database and see what is the behavior?

Ramesh..

How about testing with latest version of the Teiid ?

installing a new version?

Hi, I am running into this issue as well.  It seems that all PostgreSQL ODBC drivers starting with version 09.06.0100 is now issuing "SET DateStyle =" which the Teiid server does not handle.

I have reverted to version 09.06.0400 which is working.

It would be nice if the Teiid server caught up with this so we can keep ODBC drivers current as well.

My Stack is:

Oracle OBIEE

unixODBC

PostgreSQL ODBC

Teiid

Can you log an issue for supporting 09.06.0100?

[TEIID-4950] PostgreSQL Linux ODBC driver v09.06.0100 and newer does not work with Teiid Server 9.1.1 - JBoss Issue Trac…