Version 2020 Release 2 (Mac/Catalina) following code doesn’t work
#######################
dim db as ODBCDatabase
db = new ODBCDatabase
db.DataSource = “DRIVER={Actual SQL Server};server=;UID=;PWD=;DATABASE=”
db.Connect
######################
it brings: [iODBC][Driver Manager]Driver’s SQLAllocEnv() failed
on the same machine same code with Version 2020 Release 1.2 works fine
Not that I would consider this a solution, but if you claim this worked in 2020r1.2 then I would try swapping the ODBCPlugin.xojo_plugin from 2020r1.2 (see Plugins folder in the Xojo 2020 Release 1.2 folder) with the one in 2020r2 and see if that improves anything.
I have the same error with 2023r1. Unfortunately I don’t have an older XOJO version, so I can’t replace the current ODBCPlugin.xojo_plugin with an older version.
What can I do?