Displaying 1 result from an estimated 1 matches for "sportsdb".
Did you mean:
portsdb
2014 Jun 30
2
Change database in SQL Server using RODBC
...)
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 problem. I also want to read in the table dbo.sports. That
table is in the database sportsDB. I did not see any way to do so from
within R.
I could not find the answer in ODBC Connectivity by Brian Ripley,
November 25, 2013.
Any ideas?
Are there alternative strategies such as using dplyr or data.table? The
work tables may have hundreds of thousands of rows.
Thanks.
[[alternative...