For iODBC, one could add data source names (DSN’s) at ~/Library/ODBC/odbc.ini. The DBMS drivers used must be compiled for use with iODBC. For example, the R package RODBC and Python package pyodbc are compiled by default to use iODBC on Mac OS X. Whichever one you use, just make sure the DBMS Driver and software you are using are configured/compiled to use with the same ODBC manager (usually set through the configure flags). It doesn’t matter whether you use iODBC or unixODBC. Different software (e.g., R or Python) can utilize ODBC to access different DBMS through the following logic: Software -> ODBC Manager -> ODBC Driver for the DBMS -> DBMS Server (Software: R, Python, etc. ODBC is kind of like an API for any software to access any DBMS easily, regardless of what DBMS it is and what OS it’s running on. This is the main reason why there’s so much confusion on getting ODBC to work on Mac OS X. Most other Linux/UNIX system uses unixODBC to manage the ODBC drivers. Mac OS X has iODBC installed as it’s default ODBC manager.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |