Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to create repository connection in ODi using MS SQL Server Database

MaheshGxDec 22 2011 — edited Dec 28 2011

Hi,
I have ODI 11.1.1.3 installed on my machine.
Also MS SQL Server 2008 Express edition is installed on the same machine.
I am trying to create Repository connection using SQl Server.
I have given following values .

JDBC Driver:- com.microsoft.sqlserver.jdbc.SQLServerDriver
URL:- jdbc:sqlserver:V-ODIDEV1\SQLEXPRESS:1433
Username:- sa (Systems built in administrative account )
Password :- Admin#123 ( password for sa)

here V-ODIDEV1 is machine name.
SQLEXPRESS is instance name of Sql Server.

I am getting following Error.

java.lang.IllegalArgumentException: Could not load JDBC driver class [com.microsoft.sqlserver.jdbc.SQLServerDriver]
at oracle.odi.jdbc.datasource.DriverManagerDataSource.setDriverClassName(DriverManagerDataSource.java:159)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.<init>(DriverManagerDataSource.java:92)
at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage.getLocalConnect(MasterCreateRepositoryPage.java:786)

Can anybody help me with this??

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 23 2012

Added on Dec 22 2011

#business-intelligence-applications, #data-integrator, #system-management-and-integration

11 comments

1,740 views