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

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