I have installed the Postgres ODBC driver as shown in chapter 7 of the Connector manual. When I press the 'test' button in the ODBC admin. tool the connection goes out to lunch and never returns. I have to terminate it using task manager. Same thing if I try to connect from MS Access using a linked table.
I am able to connect via JDBC using Squirrel. The JBOSS console shows the VDB to be up and running.
I am using the same user id and password as connected via JDBC (admin/teiid).
Running JBOSS AS 5.1.0GA on my Windows PC. The PC is Windows XP SP2.
Any suggestions, hints, tricks or help? Are there any logs or debugging that I can turn on that might help to diagnose this?
Thanks for helping me with this!
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