Displaying 1 result from an estimated 1 matches for "orders1".
Did you mean:
orders
2014 Jun 30
2
Change database in SQL Server using RODBC
....
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") :
argument is not an open RODBC channel
>
> head(orders1)
It appears to have worked properly. But I do not know what the error
message means.
Now for the prob...