If your case's front audio jack isn't working, check the physical connection inside the PC.
If Windows installs a generic "High Definition Audio Device" instead, repeat steps and point to the Realtek .inf.
Realtek’s site is dated and confusing. For the ALC897, you need the "High Definition Audio Codecs" driver (Version R2.8x or newer). However, Realtek no longer provides direct public downloads; they redirect you to your PC vendor. Use this method only as a last resort. Realtek Alc897 Driver
Sometimes the onboard audio is disabled in the motherboard BIOS.
While specs aren't everything, they tell us what the chip is capable of: If your case's front audio jack isn't working,
The TL;DR of the specs: It is significantly better than old legacy chips (like the ALC887), but it is noticeably noisier than the high-end ALC1220 (which hits 120dB SNR).
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. If Windows installs a generic "High Definition Audio
For the ALC897, Realtek provides two main user interfaces (depending on driver version):