My Oracle Support Banner

OGG Replicat Abends With OGG-01010 Error Executing Stored Proc (Doc ID 1344667.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version: 11.1.1.0.0 and later   [Release: 11.1.1 and later ]
Information in this document applies to any platform.

Goal

Using a version 9.x Replicat, and a regular ODBC driver, I can successfully connect to a MS-SQL 2008 target database.

However, using a version 11.x replicat and a regular ODBC driver I get the following error:


INFO OGG-01552 Connection String: provider=SQLOLEDB;initial catalog=ATSHIST;data source=SW730CATSHIS01\DW730CATSHIS01;persist security
info=false;integrated security=sspi.

Source Context :
SourceModule : [ggdb.oledb.db]
SourceID : [../gglib/ggdbodbc/dboledb.cpp]
SourceFunction : [OleDB::openDataSource]
SourceLine : [515]

2011-07-08 16:45:25 ERROR OGG-01555 OLE DB Error: Incompatible driver error
DSN 'ATS_DEV_HIST' SQL Server 2008 requires SQLNCLI10.

2011-07-08 16:45:25 ERROR OGG-01668 PROCESS ABENDING.


Why does my SQL Server Replicat report this error after upgrading to v11.1.1?

Solution

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
  Goal
  Solution

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