IBM Support

Receiving Error: 'SQLSetConnectAttr failed; invalid connection string attribute' when trying to connect to Oracle Database via ODBC Map. (SCI19573)

Troubleshooting


Problem

Receiving Error: 'SQLSetConnectAttr failed; invalid connection string attribute' when trying to connect to Oracle Database via ODBC Map. (SCI19573)

Symptom

Receiving Error: 'SQLSetConnectAttr failed; invalid connection string attribute' when trying to connect to Oracle Database via ODBC Map.

Cause

The DSN created for the ODBC (SQL) side of the‚ map was created using the Microsoft Driver for Oracle

Resolving The Problem

When creating a DSN for an‚ ODBC (SQL)‚ map, it can not be created using the Microsoft Driver for Oracle.‚

Create the‚ DSN‚ using the Oracle ODBC Driver.

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Mapping and Translation","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6V5U","label":"Sterling Gentran:Server for UNIX"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Mapping and Translation","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6V3G","label":"Sterling Gentran:Server for Microsoft Windows"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Mapping and Translation","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI9004

Product Synonym

[<p><b>]Fact[</b><p>];[<p>]Gentran:Server for Windows, All Releases [<br />] GENTRAN:Server for Windows
NT, All Releases [<br />] Gentran Integration Suite, All Releases [<br />]
Gentran:Server for UNIX, Release 6.0 [<br />] Gentran:Server for UNIX, Release
6.0.01 [<br />] Gentran:Server for UNIX, Release 6.0.02 [<br />] Gentran:Server for
UNIX, Release 6.1 [<br />] SQL Map [<br />] ODBC Mapping [<br />] SCI19573[</p>]

Document Information

Modified date:
04 January 2019

UID

swg21541694