Search code examples
rr-dbi

Connect to MSSQL using DBI

I can not connect to MSSQL using DBI package. I am trying the way shown in package itself

    m <- dbDriver("RODBC") # error

Error: could not find function "RODBC"

    # open the connection using user, passsword, etc., as
    # specified in the file \file{\$HOME/.my.cnf}
    con <- dbConnect(m, dsn="data.source", uid="user", pwd="password"))

Any help appreciated. Thanks

Solution

  • It looks like there used to be a RODBC driver for DBI, but not any more:

    http://cran.r-project.org/src/contrib/Archive/DBI.RODBC/

    A bit of tweaking has got this to install in a version 3 R but I don't have any ODBC sources to test it on. But m = dbDriver("RODBC") doesn't error.

    > m = dbDriver("RODBC")
> m
<ODBCDriver:(29781)> 
>

    Suggest you ask on the R-sig-db mailing list to maybe find out what happened to this code and/or the author...