My Oracle Support Banner

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 NOVEMBER 05, 2019

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: xx] [ecid: <ECID>] Cannot retrieve database schema.[[
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name '<OBJECT_NAME>'.
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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.