Anyone get a 2FA error when trying to connect via ODBC even when the role being used isn't using 2FA?

Yeah this happens sometimesblinkingguy; even if the role doesn't require 2FA, NetSuite can still enforce it at the user level. Check the user record to make sure 2FA isn't enabled there. Also try using token-based authentication instead of username/password for ODBC - that usually bypasses the 2FA check. In the ODBC connection string, you can use the token method which is more reliable for automated connections anyway.