You must use a 64Bit DSN for 64-bit SQL Server 2017

Maybe it is working with Excel because you are using a 32 Bit DSN? In Excel File | Help | will show if are running 32 or 64 bit Excel

For the DSN table selection do not use * and do not tick All. Try with AR9* or some known table name.