Hi,
We want to create SQL Server linked server (database link) to Oracle database without hard coded the Oracle credential in SQL Server.
I created external password store (wallet) on the SQL Server and verified the credential stored in the wallet works. I also verified that I can successfully making test connection using 64bit ODBC system DSN. (without provide the username, click “Test Connection” returns "connection is successful.)
That being said, I can' find a way to create SQL Server Linked Server to Oracle using wallet.
Env:
SQL Server 16.0.1000.6 with 19.3 (full) client
Oracle 19.22 linux 8