如何将R连接到Oracle? [英] How to Connect R to Oracle?

问题描述

我需要将R连接到oracle，到目前为止，我一直没有成功.我下载了两个软件包:RODBC& RODM.

I need to connect R to oracle and I have been unsuccessful so far. I downloaded two packages: RODBC & RODM.

这是我一直在使用的语句:

This is the statement that I've been using:

DB <- odbcDriverConnect("DBIORES1",uid="mhala",pwd="XXXXXXX")

但是我得到这个错误:

Error in odbcDriverConnect("DBIORES1", uid = "mhalagan", pwd = "XXXXXXX") : 
  unused argument(s) (uid = "mhalagan", pwd = "XXXXXXX")

我需要什么信息才能连接到oracle数据库?我使用的是正确的包裹吗?

What information do I need to be able to connect to an oracle database? Am I using the correct package?

推荐答案

有关odbcDriverConnect()的信息，请参见帮助页面. odbcDriverConnect()不接受uid或pwd自变量.您可能打算使用odbcConnect()代替:

See the help page for odbcDriverConnect(). odbcDriverConnect() does not accept uid or pwd arguments. You probably meant to use odbcConnect() instead:

odbcConnect(dsn = "DBIORES1", uid = "mhala", pwd = "XXXXXXX")

除了RODBC软件包外，还有RODM软件包，我相信它是专门为Oracle数据库设计的，并在此处进行了进一步说明:

In addition to the RODBC package, there is the RODM package, which I believe is specifically designed for Oracle databases and is further described here: http://www.oracle.com/technetwork/articles/datawarehouse/saternos-r-161569.html . I do not use Oracle databases, so cannot comment on advantages of the two packages.

这篇关于如何将R连接到Oracle?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！