-
30. Re: ODBC Connecton to VDB
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?
-
-
32. Re: ODBC Connecton to VDB
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.. -
33. Re: ODBC Connecton to VDB
I'm using :
* Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0
* JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.7.Final-v20160512-1643-B1247
* 64-bit Windows 10 environment
* “psqlodbc_09_05_0200-x64” PostgreSQL ODBC driver
Unfortunately I don't have an access to a Postgre database to make the test....
In the attached file is the server.log.
-
-
-
-
37. Re: ODBC Connecton to VDB
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
-