Displaying 1 result from an estimated 1 matches for "tsqlfundamentals2008".
2014 Jun 30
2
Change database in SQL Server using RODBC
...tested the following
on my home set up of Server 2012 and Windows 7. I am using RStudio.
I wish to connect to several SQL Server 2012 databases from R.
This page helped me get started.
http://andersspur.wordpress.com/2013/11/26/connect-r-to-sql-server-2012-and-14/
I set up my connection with TSQLFundamentals2008 as the default database.
I then read in the table dbo.orders with the following code.
> library(RODBC)
> con = odbcConnect("SQLServer2012")
> orders1 = sqlFetch(con,"dbo.orders")
> odbcClose("SQLServer2012")
Error in odbcClose("SQLServer2012"...