7 Replies Latest reply on Mar 26, 2012 1:07 PM by rareddy

    ODBC on Windows?

    dvenus

      Hi!

       

      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!

       

      Dave Venus

        • 1. Re: ODBC on Windows?
          rareddy

          David,

           

          Please note that ODBC port number (default 35432) is different than that of JDBC (default 31000) when you are making ODBC connection. I also noticed the above described behavior when I was trying to connect ODBC client to a Teiid on JDBC port.

           

          Hope this helps.

           

          Ramesh..

          • 2. Re: ODBC on Windows?
            dvenus

            Hi!

             

            This is happening when using port 35432. I have it set up as a SYSTEM DSN - does that make a difference? I have attached screen shots of the DSN set up to help diagnose the problem.

             

            Thanks again!

             

            Dave Venus

            • 3. Re: ODBC on Windows?
              rareddy

              David,

               

              SYSTEM DSN should not be a issue. Check and make sure that on the JBoss AS console, Teiid started the ODBC. There should be a log message. Also have you used "localhost" while connecting through JDBC? If the hostname is not resolving correctly use the IP directly like 127.0.0.1

               

              Ramesh..

              • 4. Re: ODBC on Windows?
                dvenus

                Hi!

                 

                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!

                 

                Dave Venus

                • 5. Re: ODBC on Windows?
                  rareddy

                  Dave,

                   

                  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.

                   

                  Ramesh..

                  • 6. Re: ODBC on Windows?
                    vikas252

                    Hi Ramesh

                     

                    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.

                     

                    Other details:

                     

                    Jboss AS - 5.1

                    Teiid Designer - 7.4

                    Postgre odbc  - 9.01

                     

                    Thanks. Vikas

                    • 7. Re: ODBC on Windows?
                      rareddy

                      Vikas,

                       

                      What is the client you are using? Can you try  version 8.4.200 ODBC driver version. This is the version we have lot of testing with. We will move to 9.x version on Teiiid 8.0 version.

                       

                      Ramesh..