unrecognized escape character string r

Question

I am trying to establihs connection with database server using

library(RODBC)
myconn <- odbvConnect(dsn="SERVER\NAME", uid="user", pwd="password")

Server name has "\". I've also tryed using

"SERVER\\NAME"

as suggested on this topic. But that doesn't work either because than boath slashes are written in and I get error that server couldn't be found.

So question: how do I need to type \ so R will understand it as single character?

"both slashes are written" only when `print()`ing inside of R because it doesn't escape values. If you `cat()` that value in R you should see a single slash. So the string "SERVER\\NAME" in R has just one slash. What is the problem you are having with your connection? — MrFlick, Jun 11 '14 at 12:57

score 0 · Answer 1 · answered Jun 11 '14 at 11:18

0

myconn <- odbvConnect(dsn=@"SERVER\NAME", uid="user", pwd="password")

answered Jun 11 '14 at 11:18

Sefa

8,865
10
51
82

I get: Error: unexpected '@' in "myconn <- odbvConnect(dsn=@" – ogiz Jun 11 '14 at 11:44
This article could help: http://stackoverflow.com/questions/5998058/handle-backslash-in-the-connection-string – Tanner_Gram Jun 11 '14 at 12:47

user8825025 · Answer 2 · 2017-10-24T11:55:01.980

0

cn<-odbcDriverConnect(connection="Driver={SQL Server Native Client 11.0};
server=LPT-11\\SQLEXPRESS;database=dbname;Uid=username;
Pwd=pass;trusted_connection=yes;")

edited Oct 24 '17 at 11:55

answered Oct 24 '17 at 11:49

user8825025

1
1

unrecognized escape character string r

2 Answers2