My Oracle Support Banner

OGG-01557 OLE DB Error: Cannot Open Data Source. Error Code 0x80040154 Detail: OLE DB: GetDataSour (Doc ID 2312741.1)

Last updated on MAY 11, 2022

Applies to:

Oracle GoldenGate - Version 11.2.1.0.4 to 12.3 Beta [Release 11.2 to 12.3]
Microsoft Windows x64 (64-bit)

Check for Relevantcy 06/11/2019

Symptoms

Windows server 2016 x86-64
OGG 64-bit

When using ggsci following command works successfully
GGSCI (oggman1) 1> dblogin SOURCEDB abc USERIDALIAS gghack

2017-09-13 16:05:59 INFO OGG-03036 Database character set identified as windows-1252. Locale: en_US.

2017-09-13 16:05:59 INFO OGG-03037 Session character set identified as windows-1252.
Successfully logged into database.

When starting replicate process it fails with
2017-09-13 16:21:45 INFO OGG-01552 Connection String: provider=MSODBCSQL13;initial catalog=abcd123;data source=abcd123.database.windows.net;user id=us01;password= ********.

2017-09-13 16:21:45 ERROR OGG-01557 OLE DB Error: Cannot open data source. Error code 0x80040154 Detail: OLE DB: GetDataSource.

Changes

 

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.