I believe you will have to go into your ODBC configuration software
outside of R, find where "SOUTHAMPTON" is defined, and change it so
that it connects to that "different part of the server". Note that
"different part of the server" is not standard database terminology,
so it's kind of hard to guess exactly what needs to be done. You may
need assistance from your database managers.
-Don
At 10:33 AM +0100 8/18/09, Conrad Addo wrote:
Hello Everyone,
I'm trying to write a table to a specific location in my database from R.
When I use the following code, it is going directly into the first part of
the server which is named 'master' I want to put it onto a different part
of the server called 'HRISK_1'. I think I have to change the tablename
location or specify the location in the databse somehow. Could you please
help me with the syntax of doing this?
Thanks
Conrad
position = read.csv(file = "Position_FTSEhx.csv", header = TRUE)
dataf = data.frame(position)
library(RODBC)
tt = odbcConnect("SOUTHAMPTON", uid = "sa", pwd = "msscapital")
sqlSave(channel = tt, dat = dataf, tablename = "rproject", safer = FALSE)
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://*stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://*www.*R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
--
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA
925-423-1062
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
