Dumblauskas, Jerry <jerry.dumblauskas <at> credit-suisse.com> writes:
>
> OK
>
> Is your PostGres server on the same Linux box you are running R on?
> Sample values
> Server = 169.49.30.69 (localhost host means you are on the same
> box)
yes, all is local here.
> Port = 2700 (make sure your port is correct)
to be honest, I'm not sure... I just used the port-number that was used in the
documentation (the example), assuming it is correct. ;-)
I did'nt checked the port-number...
>
> Also, I am not seeing your id and password....
well.... is this necessary?
I just used the examples, and all that is different, I changed.
If the examples are missing the user/passwd, then I also did not used it.
BTW: here did you miss it? In /etc/odbc.ini?
>
> I use the signature
> CONNREAD <- odbcConnect(READDBID, uid = READDBUSER, pwd = READDBPWD,
> believeNRows=FALSE)
??
>
> So for you this would be
> channel <- odbcConnect("rtestdb", uid="rtest", pwd="???",
> believeNRows=FALSE)
???
Van you explain me the "???" and the READDBID / READDBUSER / READDBPWD ?!
Looks like env-vars included here in the configs?!
> The alloc error means you are close...
?? what?!
...you mean allocHandle?!
>
> Make sure you can connect to your DB outside of R as well....
With psql I can connect.
Was this your question?
Or do you mean other tools?
Ciao,
Oliver
______________________________________________
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.
