This content has been marked as final. Show 2 replies
This error with the plain open bracket is commonly indicating a NLS issue.
Unfortunately you didn't indicate which ODBC Driver manager and ODBC driver you are using nor on which platform you installed the gateway, so I can only guess...
Could you please add to your gateway config file the 2 gateway parameters, then retry the select in a new SQL*Plus session:
HS_NLS_NCHAR = UCS2
Thanks for the answer, the issue is already solved, I had like 3 odbcini files, I made the changes in all of the 3 files, after that I could make the connection through the db link.