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

    odi connect to sql server 2005

    nianzhang
      Hi,

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

      I have managed to connect to the sql server 2005 using this article.
      http://bloggingaboutoracleapplications.org/how-to-connect-an-sql-server-2005-db-to-odi/

      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.

      Thanks,
      Nian
        • 1. Re: odi connect to sql server 2005
          nianzhang
          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)