Actual Technologies ODBC Driver

[Chris_Halford]

I’ve successfully used their drivers in the past but now when running with my same code I am getting this database exception.

[iODBC][Driver Manager]Driver’s SQLAllocEnv() failed

Anyone experience this or understand how to get past it?

[William_Yu]

Not a long term solution but check out:

ODBCDatabase connect 2020 r 2

Hello, 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 Any Idea, what I made wrong? Wolfgang

[Chris_Halford]

Well that’s an interesting solution.

Thanks.

[Jeannot_Muller]

@Chris_Halford

Well that’s an interesting solution.

At least you are not asked to use a Realbasic plugin

[Chris_Halford]

William, that fixed it.
Yes, it’s not a permanent fix, but I can deal with it for now, and I’ll issue a bug report.

Thank you very much.