I am able to connect to my database using
odbc, but I get a strange error when I try to upload a dataframe there. See below:
con <- dbConnect(odbc::odbc(), "DV_MYDV", dbname = "mydb")
the connection works:
 "version" "NewTestTable"
 "test1" "test2"
 "test3" "testtable1"
however, uploading a
dataframe fails. How is it possible? I can easily create tables with SQL queries such as
"CREATE TABLE etc".
dbWriteTable(con, name = "iris", value = as.data.frame(dataframe), overwrite = TRUE)
Error in new_result(connection@ptr, statement) :
nanodbc/nanodbc.cpp:1665: HY000: Table creation not allowed.
This is annoying because I need to upload large dataframes to my database. Working row by row would not be efficient.