1

Does anyone have a connection string example for using RODBC and connecting to MS SQL Server 2014.

If I use below connection string works fine for SQL Server 2008 but not for 2014 

library(RODBC)  

connectionstring <- odbcDriverConnect('driver={SQL Server};server=Serveraname\\Instance name,PortNumber;database=database name;uid=username;pwd=password;')
zx8754
  • 52,746
  • 12
  • 114
  • 209
Sriharsha
  • 150
  • 3
  • 16
  • Do you already know a solution (please post it here then)? What is the error message you get? – R Yoda Dec 27 '16 at 21:32
  • Possible a duplicate or answered by: http://stackoverflow.com/questions/5720508/sql-server-rodbc-connection – ctbrown Mar 23 '17 at 03:40

1 Answers1

0

Is it the Instance name? On SQL server 2014 you do not need an instance name AFAIK. I suggest you use the Native Client driver. It usually works fine with 2014 SQL servers.

vaudt
  • 151
  • 6