I created a DSN on the mac and ran the test from ODBC manager and it passes.
I am also able to connect from my Mac using a SQL Server gui app that doesn’t require a DSN, just the IP, name and pw.
When I try to access the DSN from Xojo I get [Actual][SQL Server] Unable to connect: Server is unavailable or does not exist. How is it possible that the DSN can connect but not a line of code that points to the DSN?
Var db As New ODBCDatabase
db.DataSource = “cgpsusers”
// Use the database
Catch error As DatabaseException
// Connection error
// or the user selected
// Cancel from the ODBC browser