Here's a picture of my ODBC administrator as you can see I can only see my Teradata drivers. + ,driver = "/Users/my_user_name/.odbc.ini",Įrror: nanodbc/nanodbc.cpp:950: 01000: Can't open lib '/Users/my_user_name/.odbc.ini' : file not found
This is my R code below, I think my driver path is wrong: > con = DBI::dbConnect(odbc::odbc() I don't know how to add the driver file to my ODBC Administrator, and I can't access it via R. odbc.ini here: /Users/my_user_name/.odbc.ini (I need to type ls -l -a Then I do this: sudo chown $USER ~/.odbc.iniĪt this point I'm lost.Run the configuration script: sudo sh odbc_update_ini.sh /usr/local which returns *** ODBCINI environment variable not set,defaulting it to HOME directory!.Make small patch to the driver name in instantclient_12_2/odbc_update_ini.sh (see link to original instructions).Add files to the macOS library search path ln -s $(pwd)/libclntsh.dylib.12.1 $(pwd)/libclntshcore.dylib.12.1 ~/lib.Unzip and store above files here: /Users/my_user_name/Applications/instantclient_12_2.Download Development and Runtime > ODBC Package.Download Version 12.2.0.1.0 (64-bit) > Base > Basic Package.
I have been following the instructions on this Oracle blog: I don't have the technical language to express exactly what I need, but I think I need to find out where my driver is and use that in my R code and set it up in my ODBC Administrator tool. I work on a Mac (macOS Mojave 10.14.1) and I am trying to set up an ODBC driver to connect to an Oracle database (my eventual aim is to connect via R using the DBI package).
0 kommentar(er)
