I'm trying to use the MS SQL Server ODBC driver for macOS with Xojo. I think I have it configured OK - seems to work with the unixODBC command line utility just fine. But I can't get it to work with Xojo. I have compiled a 64-bit app (as the driver is 64-bit only) but when I try to connect I get an empty error response (no message) and error number 1. I have confirmed the user, password, database name and server are correct, and have tried using a DSN in iODBC and building the whole connect string in Xojo. I know I'm getting the right driver, because when I compiled as 32-bit it failed on the architecture to load the driver.
Anyone have this working?