Connection String for Oracle 21c Express Edition in Windows 10 for ODBC driver 'Oracle in OraDB21Home1'
I have installed Oracle 21c Express Edition in my laptop with Windows 10 (x64).
Configured ODBC Driver (x64) 'Oracle in OraDB21Home1' successfully (under System DSN & User DSN tabs).
Details are as follows (standard):
Data Source Name: XE
TNS Service Name: LISTENER_XE
User ID: System
Server: localhost
Port: 1521
Password: ***
When clicked Test Connection button, it confirmed connection.
What should be the connection string in this case ?
Kindly advise if more details required.
1 answer
It's the same as https://www.connectionstrings.com/oracle-in-orahome92/. But of course update Driver={Oracle in OraHome92} -> Driver={Oracle in OraDB21Home1}