OGG-01557 OLE DB Error: Cannot Open Data Source. Error Code 0x80040154 Detail: OLE DB: GetDataSour

(Doc ID 2312741.1)

Last updated on OCTOBER 04, 2017

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)

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.

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