Make sure that directory ownership is changed to your user and that your user has write permission (if not, use the provided commands).ĭownload the 64-bit Mac OSX ODBC driver, available on the ODBC Driver for Mac OSX tool page. Using terminal, install homebrew if you don’t already have it: /usr/bin/ruby -e "$(curl -fsSL )" You should test it in a development environment thoroughly before depending on it in production. This is not a MarkLogic product, but an unsupported, unofficial tool developed by MarkLogic engineering. This project and its code and functionality is not representative of MarkLogic Server and is not supported by MarkLogic. You can download the project on the ODBC Driver for Mac OSX tool page. Here you’ll learn how to install and set up the project that contains the base driver code to enable a connection with MarkLogic through the ODBC Driver for Mac OSX. Consulting Services Expert implementation.Ln -s /opt/homebrew/etc/odbc.ini /usr/local/etc/odbc.iniīut after finding the driver and attempting to connect I get the "Can't open lib." error. Ln -s /opt/homebrew/etc/odbcinst.ini /usr/local/etc/odbcinst.ini I made some progress after adding these 2 symlinks it allowed RStudio to find the driver:.I also set environment variable using: export ODBCINI=/opt/homebrew/etc/odbc.ini USER DATA SOURCES.: /Users/yoitsdre/.odbc.ini SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.iniįILE DATA SOURCES.: /opt/homebrew/etc/ODBCDataSources ~ odbcinst -jĭRIVERS.: /opt/homebrew/etc/odbcinst.ini Note that ARM64 homebrew files use /opt/homebrew/ instead of /usr/local/ which was used for x86 machines. I installed openssl1.1, removed the openSSL symlink at /opt/homebrew/opt/openSSL/ that pointed to and created a new openSSL symlink that points to the openSSL change I was able to successfully connect to SQL Server from Bash terminal but RStudio still couldn't even find the driver with odbcListDrivers().Ĭhecked the unixODBC environment and it's all correct. MS supports native ARM64 from version 17.8. I installed homebrew, unixodbc and MS Driver 17 for SQL Server. I have tried other combinations of symlinks for odbc.ini and odbcinst.ini in my local user home directory and also in the /etc/ directory but didn't make any difference. I have tried modifying the path in odbcinst.ini to the actual file in /opt/homebrew/Cellar/msodbcsql17/17.8.1.1/lib/libmsodbcsql.17.dylib but still get the same error. I also added a symlink for libmsodbcsql.17.dylib in /usr/local/lib/ pointing it to the same file in /opt/homebrew/lib/ I verified that the symlink libmsodbcsql.17.dylib exists in /opt/homebrew/lib/ and points to /opt/homebrew/Cellar/msodbcsql17/17.8.1.1/lib/libmsodbcsql.17.dylib + Driver= "ODBC Driver 17 for SQL Server",Įrror: nanodbc/nanodbc.cpp:1021: 00000: Can't open lib '/opt/homebrew/lib/libmsodbcsql.17.dylib' : file not foundĪttempting to connect using the DSN throws the same error: dbConn <- dbConnect(odbc(), The error message when connecting to the Driver: dbConn <- dbConnect(odbc(), I have no issues setting this up on my old Mac running intel chip so I am wondering if native ARM64 is just not compatible? Can anyone confirm they can connect to SQL Server? I've read some posts about connecting using an x86 emulator but nothing for native ARM64 odbc compatibility in RStudio. I'm using a new M1 Macbook running native ARM64 homebrew. I can connect to MS SQL Server from my Bash terminal but I'm not having any luck connecting from RStudio.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |