Displaying 1 result from an estimated 1 matches for "enter_name".
Did you mean:
enter_frame
2012 Nov 21
1
remote connection to an Oracle database - using RODBC - RMySQL..?
...nto dataframes.
I am a novice in SQL and database access - but a friend provided me with the following approach:
library(DBI)
library(RMySQL)
drvr<-dbDriver("MySQL") #Or another driver, say from the RODBC package?
acon<-dbConnect(drvr, user="ENTER_USERID", dbname="ENTER_NAME", host="ENTER_HOST",
port=1521,password=NULL) #password maybe non-null?
cmds<-dbSendQuery(acon,statement="YOUR SQL QUERY HERE")
yourdata<-fetch(cmds, n=-1) #Collects all rows and columns of data requested query.
I have provided this info changing the...