Disabled Allow_Global_names and still can't create link without domain
edited Jan 20, 2023 3:56PM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 1 commentAnswered ✓
Creating a database link to an Informix database using Generic ODBC gateway and it is failing because domain info is being appended to the username for the Informix login. Simple solution I have found is to set these to false but they already are.
global_names FALSE
allow_global_dblinks FALSE
Results of testing the link:
Link : "CCX_UCCXDB"
Error : ORA-01017: invalid username/password; logon denied
[Informix][Informix ODBC Driver][Informix]Incorrect password or user InformixID@oracldbhost.domain[oracldbhost.domain] is not known on the database server. {28000,NativeErr = -951}
ORA-02063: preceding 2 lines from CCX_UCCXDB
This in in onsite Oracle 19c database, on a Windows 2019 server.
0