Displaying 2 results from an estimated 2 matches for "xfl2".
Did you mean:
fl2
2005 Feb 22
1
Rdbi and ODBC
...g that Rdbi
claims to run a query in 5 seconds that takes RODBC 4.3 minutes. That
was hard enough for me to believe that I wanted to try some tests
myself, but I cannot get Rdbi to connect to my ODBC database.
Here is what works for RODBC for my setup:
conn <- odbcConnect("xf", "xfl2", "xfl2")
Now for Rdbi the documentation is lacking. "?Rdbi" doesn't work and
"?dbConnect" gives little detail and no examples.
I tried all of the following without success:
conn <- dbConnect("ODBC()", dbname="xf", user="xfl2&quo...
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 oth...