ODBC Driver is not working

General
1

Dear Sir:

I am professional R Programmer. I work with MS SQL Server & Rstudio.
With earlier version of Rstudio, the ODBC Driver worked well, but with
the new version the ODBC is not working. the code to connect I use is
the following code.

library(odbc)
con <- dbConnect(odbc(),
                 Driver = "SQL Server",
                 Server = "",
                 Database = "RDB",
                 UID = '',
                 PWD = '')

I am stuck. Could you kindly help me.
Best Regards

2

Here's the documentation on using the odbc r-package to connect to a database

https://db.rstudio.com/getting-started/connect-to-database/

Currently there isn't much information to go on. What errors does R or the log provide you? (and when you share those, do be careful to again remove all personally identifying and security details, like IPs passwords etc)

1 Like
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.