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.
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>]
Was this topic helpful?
Document Information
Modified date:
04 January 2019
UID
swg21541694