Sorry for the long delay. I am working on this problem again.
Where do I look in the JBOSS AS console to see if ODBC is started? I have looked thru all of the items in the tree but I don't see anything about ODBC. A screen shot of a correctly working console would be helpful.
Also where would I find the JBOSS AS or TEIID log that would tell me if the ODBC service had been started?
Any help that anyone can give is greatly appreciated!
Admin console does not have information about ODBC port is started or not. But if you see in the log, and in the console window (terminal window) where JBoss AS is started you will see a log message. By default ODBC port is enabled, unless you disabled or port is already taken by another process, Teiid should be able to accept ODBC connections if you got a valid VDB deployed in the Teiid runtime.
I am facing a similar issue where in I have a similar setup. My teeid instance is on linux host and the client is on windows xp sp2. I have set up postgresql odbc driver locally and when I try to import tables from the teiid cdb, I can see the objects (tables, views) but can not see the column names via odbc connection. However all seems to be working when accessed via Squirrel.
Jboss AS - 5.1
Teiid Designer - 7.4
Postgre odbc - 9.01