Connect to a Highly-Available SQL Server from R -


we've upgraded sql server 2012 highly-available dr enabled. when connecting using ssms need specify multisubnetfailover=true additional connection option + increase timeouts.

how can replicate in r? without this, observe sporadic connectivity/timeout issues.
related, python

> packageversion('rodbc') [1] '1.3.6' > packageversion('base') [1] '2.15.2' 

if using data source name, can add arguments odbcconnect

odbcconnect(dsn, uid = "user_name", pwd = "password", multisubnetfailover = "true") 

if using connection string, need add arguments in string.

odbcdriverconnect("driver=driver; server=server; database=database; uid=user_name; pwd=password; multisubnetfailover = true") 

Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

Command prompt result in label. Python 2.7 -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -