I'm a relatively new R user but I am experiencing an error when connecting to a MongoDB database. Whether I run code or use the "New Connection" feature I get the following error:
Error: nanodbc/nanodbc.cpp:950: H 000: [
I've tried doing some research but can't find the cause of this issue. Does anyone have any idea what might be going wrong?
I wrote the following if there is an error there. I have tried using different variations of the Driver name just as MongoDB Unicode ODBC 1.2.0, MongoDB Unicode ODBC, MongoDB, file directory and etc. with no luck.
con <- DBI::dbConnect(odbc::odbc(),
driver = "MongoDB Unicode ODBC 1.2.0",
database = "xxxx",
server = 'xxxxxx.net',
UID = "xxxxxxx?source=admin",
PWD = "xxxxxxxxxx",
host = "localhost",
port = 27015)