This discussion is archived
1 Reply Latest reply: Feb 1, 2013 5:58 AM by nianzhang RSS

odi connect to sql server 2005

nianzhang Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points