Connecting R to Oracle using ODBC: How can I install driver of ODBC in Windows 64 bit?

Question

I am trying to connect R (64-bit) to Oracle using library RODBC.

I got to connect using R 32 bit, using the ODBC for Oracle driver for 32 bits, but this doesn't let me use all RAM (16gb).

I got this error: "ERROR: state IM014, code 0, message [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application "

For what I've read, it seems that I need to install the ODBC driver for Oracle in 64 bits, so then I can make another DSN connection and then connect to the database in R 64-bit.

How can I install this driver?

In order to install both 32 bit and 64 bit Oracle Client on the same machine, have a look at this instruction: stackoverflow.com/questions/24104210/… otherwise only one of your ODBC driver will work. — Wernfried Domscheit

Vincent Dube-Bistodeau Vincent Dube-Bistodeau · Accepted Answer · 2017-09-20T02:10:50

If your problem is the Oracle driver you can find it on the Oracle website.It is indeed a good idea to match your R and data provider architecture.

Take a look at this page : Oracle 64bit Drivers

Get the corresponding install for your OS and give us feedback! Cheers!

Connecting R to Oracle using ODBC: How can I install driver of ODBC in Windows 64 bit?

1 Answers