'PostgreSQL connection problems with R

I'm having a bit of trouble when trying to connect to PostgreSQL on RStudio. I use dbConnect of the RPostgreSQL library and start filling up the other parts. The code I used is like this:

dbConnect("PostgreSQL", dbname = , host= , port = , user= , password = )

I already double checked all the info I wrote again and again, even tried changing the password because I thought the symbols on it were breaking the code.

I'm currently taking a pre-recorded course from 3 years ago, and I can't reach the teacher to ask about this. I tried to execute the code exactly as he did, but I get this error: «!ç)

I really want to solve this, as I want to finish the class, but I can't seem to comprehend it.

Edit: I tried updating both r and RStudio, as I saw a warning for the libraries, but the error only changed a bit into this: aŸ)

rpostgresql


Solution 1:[1]

You may have some success with this:

dbConnect(
  odbc::odbc(),
  driver = "PostgreSQL",
  dbname = ,
  server= ,
  port = ,
  uid= ,
  pwd =
)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 langtang

Related Questions