OVD 10g DB Adapter Creation Fails For MS SQL Server with "Driver com.microsoft.sqlserver.jdbc.SQLServerDriver not found"
(Doc ID 1265536.1)
Last updated on FEBRUARY 21, 2019
Applies to:
Oracle Virtual Directory - Version 10.1.4.3.0 and laterInformation in this document applies to any platform.
Information in this document applies to:
OVD 11.1.1.0 to 11.1.2.0
SQL Server DB Adapter, DB adapter, JDBC drivers, SQLServerDriver
Symptoms
Note: This document does not apply to MS SQL Server 2000, which is not certified with OVD 11g. If the same error as shown in this note is returned, the steps below will not help. A potential workaround is to create a view from the MS SQL Server 2000 to a MS SQL Server 2008 instead.
For certification details, reference:
<Document 1365085.1> - How To Find Which Third (3rd) Party LDAP Servers Are Certified With OVD 11g LDAP Adapters? / How To Find Which Third (3rd) Party Databases Are Certified With OVD 11g Database Adapters?
For certification details, reference:
<Document 1365085.1> - How To Find Which Third (3rd) Party LDAP Servers Are Certified With OVD 11g LDAP Adapters? / How To Find Which Third (3rd) Party Databases Are Certified With OVD 11g Database Adapters?
- Creating an OVD database adapter for database type "Microsoft - SQL Server" for Microsoft SQL Server 2005 fails with an error in "New Database Adapter Wizard":
Invalid Database Connection
- "Connection Settings" are correct.
- There is an error in $ORACLE_INSTANCE/diagnostics/logs/OVD/ovd1/diagnostic.log:
[2010-09-17T18:06:16.607+03:00] [octetstring] [ERROR] [OVD-60393] [com.octetstring.vde.admin.services.DatabaseBrowser] [tid: 27] [ecid: <ECID#>,0] Cannot retrieve database schema.[[
java.sql.SQLException: Driver com.microsoft.sqlserver.jdbc.SQLServerDriver not found. Use Manage Server Libraries command to install the correct JDBC drivers on the server.
at com.octetstring.vde.admin.services.DatabaseBrowser.connect(DatabaseBrowser.java:112)
at com.octetstring.vde.admin.services.DatabaseBrowser.getSchemas(DatabaseBrowser.java:265)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |