My Oracle Support Banner

OVD 11g Creating Adapter To MS SQL Server 2008 R2 Database Fails With: Error / Invalid Database Connection (Doc ID 1540770.1)

Last updated on MARCH 06, 2023

Applies to:

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

Symptoms

Unable to create Oracle Virtual Directory (OVD) 11g 11.1.1.6 Database (DB) adapter for MS SQL Server 2008 R2 DB.

The following message is reported when OVD adapter creation fails:

 "Invalid Database Connection"


The following message is reported in the OVD diagnostic log:

This indicates a JDBC connection issue, but communication between OVD and MS SQL Server) work without problems, i.e., ping, telnet commands, etc.

 

Changes

Added JDBC libraries (sqljdbc.jar and sqljdbc4.jar) in OVD through ODSM to work with MS SQL Server 2008 R2.

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
Changes
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.