Hello everybody,
Windows Server 2008 Enterprise, (SP1)
Trying to create Data Server for MS SQL (IP=192.168.10.7) from the ODI (IP=192.168.10.11). During the installation of ODI the "JavaEE" box was UNCHECKED , so, no weblogic is used.
1. Choosing "com.microsoft.sqlserver.jdbc.SQLServerDriver" as an oiption for JDBC Driver field
2. Filled in the JDBC Url as "jdbc:sqlserver://192.168.10.7:1433;databaseName=TEST" OR just "jdbc:sqlserver://192.168.10.7"
always receving the following error message:
java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.microsoft.sqlserver.jdbc.SQLServerDriver]
at oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(AbstractDataSourceProvider.java:106)
at oracle.odi.core.DataSourceManager$LoginTimeoutDataSourceProviderProxy.configure(DataSourceManager.java:302)
at oracle.odi.core.DataSourceManager.createAndConfigureDataSourceProvider(DataSourceManager.java:228)
at oracle.odi.core.DataSourceManager.access$0(DataSourceManager.java:202)
at oracle.odi.core.DataSourceManager$1.create(DataSourceManager.java:76)
at org.springframework.util.CachingMapDecorator.get(CachingMapDecorator.java:152)
at java.util.Collections$SynchronizedMap.get(Collections.java:1975)
at oracle.odi.core.DataSourceManager.getDataSource(DataSourceManager.java:151)
at oracle.odi.core.OdiInstance.lookupDataSource(OdiInstance.java:814)
at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java:82)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:162)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$4(SnpsDialogTestConnet.java:159)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$4.doInBackground(SnpsDialogTestConnet.java:519)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$4.doInBackground(SnpsDialogTestConnet.java:1)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.microsoft.sqlserver.jdbc.SQLServerDriver]
at oracle.odi.jdbc.datasource.DriverManagerDataSource.setDriverClassName(DriverManagerDataSource.java:176)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.<init>(DriverManagerDataSource.java:108)
at oracle.odi.core.datasource.provider.DriverManagerDataSourceProvider.doCreateDataSource(DriverManagerDataSourceProvider.java:35)
at oracle.odi.core.datasource.provider.AbstractDataSourceProvider.configure(AbstractDataSourceProvider.java:97)
... 16 more
I would appreciate if you could help me.