Windows 10/11 usually recognizes the ALC897 automatically. However, the Microsoft generic driver lacks the Realtek Audio Console (the EQ and jack configuration tool).
The most reliable way to get the Realtek ALC897 driver is to visit your motherboard manufacturer's official support page OEM Drivers : Manufacturers like Realtek Alc897 Driver
Yes. The High Definition Audio driver package (UAD - Universal Audio Driver) works for ALC887, ALC892, ALC897, and ALC1200. However, specific features like jack retasking might be disabled if the hardware differs. Windows 10/11 usually recognizes the ALC897 automatically
Also: If your rear mic port is dead after update → reinstall driver + enable "separate all input jacks" in Realtek Console. and ALC1200. However