can't retrieve data using dbquery()

Asked Apr 02 '20 at 10:56

Active Apr 02 '20 at 10:57

Viewed 95 times

using this code to retrieve data from SQL server

...data <- dbGetQuery(connection, paste0("SELECT * FROM ", "SCHEMA", ".", "TABLE_NAME"))...

and I got this error

...Error in .jcall(conn@jc, "Ljava/sql/Statement;", "createStatement") : RcallMethod: attempt to call a method of a NULL object...

edited Apr 02 '20 at 10:57

jarlh

asked Apr 02 '20 at 10:56

Winnie Holden

What language are you using here @WinnieHolden? Is it rstudio or another language? – Attie Wagner Apr 02 '20 at 12:14
@Birel Yes - rstudio – Winnie Holden Apr 02 '20 at 12:16
See the answer [here](https://stackoverflow.com/questions/54320001/schedule-running-r-script) @WinnieHolden. Look in the comments - I think that is how the code should be changed... – Attie Wagner Apr 02 '20 at 13:50

0 Answers0