Having trouble connecting to oracle databases using RStudio

Hi all,

I am having a lot of difficulty connecting to Oracle databases using R and I was looking if I could get any help or suggestions.
For example, I am able to connect to the same databases using Microsoft PowerBI, or SQL Server Management Studio (SSMS), but when I try using R or RStudio, I continue to get errors. I am also wondering if there are other packages or ideas I should try to connect with. The server is not public, so I wont put the actual name below, but here is what I have tried.

connectDEV <- DBI::dbConnect(odbc::odbc(),
Driver = "Oracle in instantclient_19_8",
DBQ = "servername:port/folder",
UID = rstudioapi::askForPassword("Database user"),
PWD = rstudioapi::askForPassword("Database password"))

The error I keep getting:

Error: nanodbc/nanodbc.cpp:983: IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

What I have tried:
I have installed the drivers, and have a file C:/Oracle, in that folder I have instant_client_19_8. When I do odbc::odbcListDrivers() I don't see any with the name instantclient, but when I try to install using run as admin, start odbc_install.exe, it quickly flashes and then nothing happens.

What I installed:
Basic Package and ODBC Package
(The odbc package is what had the installer, I unzipped both in the same folder).

Any ideas? What else should I try?

Thank you!

Update: I fixed it. I had to do the following, from the above link in addition to installing the instant client Development and Runtime- optional packages, download 'ODBC'

Just to confirm, you've created and tested the database connection in the ODBC Connections settings in Windows?

Thanks, I managed to fix it. Updated my question to explain how.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.