My Oracle Support Banner

Issue Connecting To Azure SQL Data Warehouse (now called Azure Synapse Analytics) (Doc ID 2691752.1)

Last updated on JULY 29, 2020

Applies to:

Oracle GoldenGate - Version 19.0.0.0.0 and later
Information in this document applies to any platform.

Goal

We are trying to connect through ODBC to azure SQL DATAWAREHOUSE but we are seeing below issues.Can you please adivise on this.

2020-07-14 12:05:23 ERROR OGG-00551 Database operation failed: Execute direct. ODBC error: SQLSTATE 42000 native database error 46706. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
 

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.