79647889

Date: 2025-06-01 20:12:57
Score: 1
Natty:
Report link

The way I did it (if you have a Windows machine) is to set it up in your ODBC Data Source Administrator and click Add

enter image description here

In the next screen, choose SQL Server and fill in your DSN information then hit next

enter image description here

Then toggle With Windows NT authentication and finish the rest

enter image description here

And you can test the connection from the wizard.

Then you can go into R with the following:

library(RODBC)
con <- odbcConnect(dsn="your_dsn")

Hope that works for you.

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: H.Hung