1 Reply Latest reply: Feb 1, 2013 7:58 AM by nianzhang RSS

    odi connect to sql server 2005


      I am using ODI I need to load data from a SQL Server 2005 database.

      I have managed to connect to the sql server 2005 using this article.

      Now the problem is how can I set up the physical schema? when the physical schema window opened, I see there are (catalogue), (schema), (work catalogue), (work schema) drop boxes, but they are all empty. And When i clicked on them, it reports Action Denied.

        • 1. Re: odi connect to sql server 2005
          I got this when I tried to create a new physical schema. Is it I am using the wrong jdbc? Now I have put in sqljdbc.jar of 2.0 in my oracledi\drivers\. I have also tried 4.0

          java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 49.0)