OVD 11g Database Adapter To MS SQL Server 2000 Fails With Invalid Database Connection / Log Error: OVD-60393 / Cannot retrieve database schema / com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'sys.schemas'

(Doc ID 1480774.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Virtual Directory - Version 11.1.1.1.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Virtual Directory (OVD) 11g, i.e., 11.1.1.5.

Created a Database adapter in OVD 11.1.1.5.

The database is Microsoft SQL Server 2000.

Downloaded the sqljdbc4.jar file from the Microsoft website and uploaded as library in OVD thru ODSM interface.

Navigated to ODSM's adapter creation UI and  provided all the required connection parameters, but the conenction fails with, e.g.,  Invalid Database Connection.

Below is the OVD log file related portion:

2012-07-31T19:54:00.716-05:00] [octetstring] [ERROR] [OVD-60393] [com.octetstring.vde.admin.services.DatabaseBrowser] [tid: 94] [ecid: 0000JZVfCwCFS8cLpi5EiY1G19yg0000Bd,0] Cannot retrieve database schema.[[
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'sys.schemas'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at com.octetstring.vde.admin.services.DatabaseBrowser.getSchemas(DatabaseBrowser.java:297)

Verified that connection to that Dabase directly using any SQL client works fine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms