My Oracle Support Banner

OAC: How to Connect to a MSSQL database from OCI-C / OAC Oracle or Customer Managed Essbase (Doc ID 2578785.1)

Last updated on APRIL 10, 2020

Applies to:

Oracle Analytics Cloud - Classic - Version 105.1.0 and later
Information in this document applies to any platform.

Symptoms

On-premises or classic instance, customer was able to load data from MS SQL or Oracle database instance located in the same network or inside a firewall. After moving to autonomous instance, the same operation fails with error

 ERROR - 1350005 - Attempt to connect to database failed with error [[OracleDataDirect][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host Name and Port Number.].

 ERROR - 1241101 - Unexpected Essbase error 1350005.

Changes

Unlike on-premises or classic instance where Essbase is often located in the same network with customer’s database instance, Essbase in OAC Oracle Managed and Customer managed instance is located in one of Oracle Data Centers around the world.

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

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