Displaying 1 result from an estimated 1 matches for "testtbl".
Did you mean:
testabl
2004 Nov 16
0
Please help using SQL with R & SQL Server
...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 might not have a
native driver, but I have tried "ODBC", too, without luck. I...