CODEWITHSUNDEEP
rsql-serverrodbcdsn
David Davis
David Davis

Reputation: 23

How to use DSN file for connection to SQL Server using R

I want to use a DSN file to connect to a SQL Server database with the R library RODBC. I am able to create a User DSN and connect using the uid and pwd, but I want to exclude those from the script if possible. I have my dsn in the working directly for R which is validated by using getwd().

The examples I see show this command: 

odbcConnect(dsn = "<dsn_file>").

I have tried using the DBI and RODBC packages using dbconnect and odbcConnect. 

dbConnect(odbc::odbc(), 
"user_dsn",uid="username",pwd="password",database="db_name")

I would like to connect to the database without showing the uid and pwd in the script. I want to use a dsn file, So I can change the credentials in one place rather than in many scripts.

Upvotes: 0

Views: 4623

Answers (3)

Marek
Marek

Reputation: 50704

With odbc package I use filedsn parametr (described on microsoft page). I think it should work with RODBC.

db_conn <- dbConnect(odbc::odbc(), filedsn="path/to/my/file/user_dsn.dsn")

Upvotes: 0

Marc
Marc

Reputation: 21

I have a DSN called "phone" that connects to our phone database. To connect and then query that database, I just do the following:

library(RODBC)
phone <- odbcConnect("phone")

Upvotes: 2

Marc0
Marc0

Reputation: 191

I don't have access to a system set up to test it but I would check this link on how to connect Setting up R to connect to SQL Server and this one on SO for info about the RODBC library.

Using a DSN
con <- dbConnect(odbc::odbc(), "mydbalias")

here are information about Securing Credentials

Upvotes: 1

Related Questions