Displaying 1 result from an estimated 1 matches for "rinnycs0059".
Did you mean:
rinnycs0051
2004 Nov 16
0
Please help using SQL with R & SQL Server
I cannot get a database connection in R to my MS SQL Server database. In
S-Plus 6.2 I have used the following successfully:
rawdata <- importData(type="DIRECT-SQL", user="xfl2",
password="xfl2", server="rinnycs0059", database="xf", table="",
sqlQuery="select * from testTbl")
In R I have tried both DBI and RSQLite, but have not had any luck. It
always says cannot find driver. All the examples use My SQL or some other
program. I only have SQL Server by Microsoft. I know R...