Can anyone point me to how to setup an ODBC connection to a MS SQL Server using FreeTDS? All of the posts and items I found on the web so far require the .so file which is no longer generated (or required) when installing FreeTDS according to its documentation. What confuses me is the fact that the user documentation also shows a setup using the libtdsodbc.so file.
I did manage to find this link on Github (https://github.com/Homebrew/legacy-homebrew/issues/24550) about someone who manually compiled iODBC for Mac and got it working, but after cloning the corresponding Guthub iODBC source I wasn't able to compile it without errors. Error 127 (which is what I get) is rather vague for me. The manual install of iODBC somehow made brew install freetds find the required iODBC headers to generate libtdsodbc.so.
I assume since FreeTDS no longer generates any .so (Shared Object), it is supposed to function without them.
Any help is greatly appreciated.
Best regards,
Andre.
Found a workaround it here in Stackflow by using an older version of FreeTDS and pymssql: mac - pip install pymssql error
Now on to the next challenge. :)
Cheers!!