akpworker.blogg.se

/etc/ had neither odbc.ini or odbcinst.ini./usr/local/etc/ directory has files odbc.ini and odbcinst.ini but they’re completely empty.I have also tried other values in my anycodings_r connection string with no luck as described anycodings_r here, e.g: con = DBI::dbConnect(odbc::odbc()īased on suggestions from I checked anycodings_r the two locations where DBI will anycodings_r “look” for the odbc anycodings_r file. On Mac I get the error Error: anycodings_r nanodbc/nanodbc.cpp:950: IM002: anycodings_r Data source name anycodings_r not found, and no default driver specified. What doesn't work on Mac (but works on anycodings_r Windows) con = DBI::dbConnect(odbc::odbc() ,pwd = rstudioapi::askForPassword("Password") ,uid = rstudioapi::askForPassword("Username") Library(RODBC) con = odbcConnect(dsn = "name_name" What works (on Mac and anycodings_r Windows): I use R version 3.5.1 () and the anycodings_r teradata driver 16.20. I downloaded the ODBC driver for Mac from anycodings_r Teradata See an screenshot of my ODBC administrator I know I have updated anycodings_r my Mac.įirst here's my ODBC info if I anycodings_r look it the ODBC Administrator: I'm sure I had this working last week, anycodings_r but I can't remember. Everything is working great on my anycodings_r Windows VM (see my previous question: anycodings_r Connect to Teradata Database using R + DBI anycodings_r library + ODBC).Īgain I suspect a driver issue, but I am not anycodings_r sure. I am trying to connect to a Teradata anycodings_r Database on both my Mac and Windows VM using anycodings_r R with the DBI library (so I can use anycodings_r dbplyr). I work on a Mac, but also have a windows VM.