Create a new folder (i.e. c:\Drivers\oraclepsODBC)
Unzip contents of “Basic” package to created folder
Unzip contents of “ODBC” package to same created folder (combine duplicate folders; files from ODBC package should be in same directory as basic package contents) (i.e. EVERYTHING including odbc files should be in here…. C:\Drivers\OraclePsODBC\instantclient-basic-windows.x64-126.96.36.199.0dbru\instantclient_19_10)
Right-click odbc_install.exe and open properties.
“Unblock” installer on general tab and click OK
CMD as administrator and change directory to location you created and combined like folders (i.e. cd c:\oracle\odbc\instantclient-basic-windows.x64-188.8.131.52.0dbru\instantclient_19_10\)
Type odbc_install.exe and hit enter
ODBC driver should now be installed and ready for use
You can now create a DSN (ODBC data source) connection on the client workstation.
Type ODBC in your start menu and choose the appropriate (x86 vs x64) result.
On the System DSN tab, click Add...
Choose the Oracle instant client driver you installed and click Finish.
TNS Service Name = IP:Port
User ID: PSNavigator
Click Test Connection
Default PowerSchool DB : PSPRODDB
Default PowerSchool DB user : PSNavigator
Default PowerSchool port : 1521 (i.e. xxx.xxx.xxx.xxx:1521
Referenced and Credit to:
Solved: ODBC Access to PowerSchool (Oracle) | Experts Exchange (experts-exchange.com)