[Driver Manager]Can't open lib file not found (0) Apple M1

[MrRobot245]

Installed ODBC and msodbcsql mssql-tools all through brew on native ARM64 M1 Mac, install proceeds fine but it can't seem to find libmsodbcsql.17.dylib

I've tried symbolic linking to the /etc/ home-brew path like in the documents, and also changing the path inside the ini file to exactly the libmsodbcsql.17.dylib file.
Chmod 777 the file and I still get this error:

[unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.17.dylib' : file not found (0) (SQLDriverConnect)"

/opt/homebrew/lib/ being the new Brew folder for M1 Macs

Edit:
/opt/homebrew/lib/libmsodbcsql.17.dylib -> ../Cellar/msodbcsql17/17.6.1.1/lib/libmsodbcsql.17.dylib

[v-chojas]

No support for ARM64 at the moment.

[MrRobot245]

That's what I figured, but it didn't get me an arch error so I thought it was something I could fix.
Would this work under Rosetta2?

[v-chojas]

If your application and its dependencies are also consistently x86_64, I don't see why not.

[LukeGahan]

Running into the same issue report by @MrRobot245 and have been unable to resolve. Happy to provide more information if needed, understand support is only for x86_64 but would be good to know if there is a workaround to make use of Rosetta2

[MrRobot245]

Mine did work with Rosetta2,

Kill the native brew version, duplicate your terminal all and check the Rosetta2 box and reinstall brew/MSSQL

Until there's a arm64 version that's what I'll be doing.

[LukeGahan]

Thanks @MrRobot245, those instructions worked for me, appreciate the help.

[nico525]

Is there any timeline on arm? I do not want to remove and reinstall my full software stack just because of this ODBC driver
FreeTDS works so far, but I am deploying to a Unix environment and would like to develop more closely to that environment

[fonnesbeck]

Is there any hope for a M1-compatible update, or is this not happening?

[David-Engel]

@nico525 @fonnesbeck M1 ARM support is being worked on. Barring any blocking issues, it is planned be in our next regular release at the end of July.

[fonnesbeck]

Thanks for the update.

[wizardion]

@David-Engel is there any news about the new version of this driver for M1 ARM? July is coming soon...

[vwarchu]

@wizardion - I'm filling in for David at the moment and can say that the end-of-July release is on track to include M1 ARM support.

[victoriawallace]

Hi @vwarchu - any update on the release for M1 ARM support?