[ARM Architecture] Mac M1 or M2 - symbol not found in flat namespace '_bcp_batch' (How-To-Fix)!

[vinicinbgs]

Describe the bug We have an issue related frequently using pip install pymssql directly on Mac M1 or M2 (OS).

If we check test_macos.yml we are using the following os: [macos-latest], but github-actions now has macos-latest-xlarge to run ARM on pipeline.

Check here: https://github.blog/2023-10-02-introducing-the-new-apple-silicon-powered-m1-macos-larger-runner-for-github-actions/

A suggestion is create a new pipeline to cover ARM architecture.

To Reproduce pip install pymssql on Mac M1 or M2 (arm architecture)

Expected behavior pymssql library connect with SQL Server on Mac ARM and work as expected

Current Behavior This issue occurs with following output symbol not found in flat namespace '_bcp_batch'

Context (Environment)

• OS: Mac M1 or M2
• Python: any
• pymssql: any

How to fix

1) Using pip

pip install --pre --no-binary :all: pymssql --no-cache --force

2) Using poetry https://github.com/pymssql/pymssql/issues/822#issuecomment-1883129385

Additional context https://github.com/pymssql/pymssql/issues/769 https://github.com/pymssql/pymssql/issues/874 https://github.com/pymssql/pymssql/issues/768 https://github.com/pymssql/pymssql/issues/751

[petrone-thomas]

Great! worked for me, thanks a lot