From @d| @end|ng |rom rod@@ro Fri Oct 24 19:18:29 2003 From: @d| @end|ng |rom rod@@ro (Adrian Dusa) Date: Fri, 24 Oct 2003 20:18:29 +0300 Subject: [R-sig-DB] RMySQL and RmSQL Message-ID: <000601c39a52$ecf375c0$6901a8c0@roda.local> Hi, I'd like to try the RMySQL or RmSQL packages, but they are not to be found via the "Install package(s) from CRAN" menu. I found the sources for these packages on the CRAN web page; unfortunately I do not know how to install a package using its source. Can you please advise me on how to get one of these? TIA, Adrian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Adrian Dusa (adi at roda.ro) Romanian Social Data Archive (www.roda.ro) 1, Schitu Magureanu Bd. 76625 Bucharest sector 5 Romania Tel./Fax: +40 (21) 312.66.18\ +40 (21) 312.02.10/ int.101 [[alternative HTML version deleted]] From dj @end|ng |rom re@e@rch@be||-|@b@@com Fri Oct 24 21:00:07 2003 From: dj @end|ng |rom re@e@rch@be||-|@b@@com (David James) Date: Fri, 24 Oct 2003 15:00:07 -0400 Subject: [R-sig-DB] RMySQL and RmSQL In-Reply-To: <000601c39a52$ecf375c0$6901a8c0@roda.local>; from adi@roda.ro on Fri, Oct 24, 2003 at 08:18:29PM +0300 References: <000601c39a52$ecf375c0$6901a8c0@roda.local> Message-ID: <20031024150007.A6330@jessie.research.bell-labs.com> Hi Adrian, You may download a windows binary from http://stat.bell-labs.com/RS-DBI/download Hope this helps, -- David Adrian Dusa wrote: > Hi, > > > > I'd like to try the RMySQL or RmSQL packages, but they are not to be > found via the "Install package(s) from CRAN" menu. > > I found the sources for these packages on the CRAN web page; > unfortunately I do not know how to install a package using its source. > > Can you please advise me on how to get one of these? > > > > TIA, > > Adrian > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Adrian Dusa (adi at roda.ro) > Romanian Social Data Archive (www.roda.ro) > 1, Schitu Magureanu Bd. > 76625 Bucharest sector 5 > Romania > Tel./Fax: +40 (21) 312.66.18\ > > +40 (21) 312.02.10/ int.101 > > > > > [[alternative HTML version deleted]] > > _______________________________________________ > R-sig-DB mailing list -- R Special Interest Group > R-sig-DB at stat.math.ethz.ch > https://www.stat.math.ethz.ch/mailman/listinfo/r-sig-db From r|p|ey @end|ng |rom @t@t@@ox@@c@uk Fri Oct 24 21:34:13 2003 From: r|p|ey @end|ng |rom @t@t@@ox@@c@uk (Prof Brian Ripley) Date: Fri, 24 Oct 2003 20:34:13 +0100 (BST) Subject: [R-sig-DB] RMySQL and RmSQL In-Reply-To: <20031024150007.A6330@jessie.research.bell-labs.com> Message-ID: It's very good that David is providing a binary, but please check compatibility with your version of RMySQL and your version of R (I believe there are problems with R 1.8.0). We gave up providing binary versions on CRAN after a lot of problems with supposedly compatible versions of MySQL client libraries not being so. I am copying this to Uwe Ligges so he can put something in the ReadMe. On Fri, 24 Oct 2003, David James wrote: > Hi Adrian, > > You may download a windows binary from > http://stat.bell-labs.com/RS-DBI/download > > Hope this helps, > > -- > David > > Adrian Dusa wrote: > > Hi, > > > > > > > > I'd like to try the RMySQL or RmSQL packages, but they are not to be > > found via the "Install package(s) from CRAN" menu. > > > > I found the sources for these packages on the CRAN web page; > > unfortunately I do not know how to install a package using its source. > > > > Can you please advise me on how to get one of these? -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 From ||gge@ @end|ng |rom @t@t|@t|k@un|-dortmund@de Sat Oct 25 15:42:26 2003 From: ||gge@ @end|ng |rom @t@t|@t|k@un|-dortmund@de (Uwe Ligges) Date: Sat, 25 Oct 2003 15:42:26 +0200 Subject: [R-sig-DB] RMySQL and RmSQL In-Reply-To: References: Message-ID: <3F9A7DC2.1020507@statistik.uni-dortmund.de> Prof Brian Ripley wrote: > It's very good that David is providing a binary, Indeed, thanks to David! > but please check > compatibility with your version of RMySQL and your version of R (I believe > there are problems with R 1.8.0). > > We gave up providing binary versions on CRAN after a lot of problems with > supposedly compatible versions of MySQL client libraries not being so. > > I am copying this to Uwe Ligges so he can put something in the ReadMe. Thanks, I did. Will appear on CRAN in a couple of days. Uwe > On Fri, 24 Oct 2003, David James wrote: > > >>Hi Adrian, >> >>You may download a windows binary from >> http://stat.bell-labs.com/RS-DBI/download >> >>Hope this helps, >> >>-- >>David >> >>Adrian Dusa wrote: >> >>>Hi, >>> >>> >>> >>>I'd like to try the RMySQL or RmSQL packages, but they are not to be >>>found via the "Install package(s) from CRAN" menu. >>> >>>I found the sources for these packages on the CRAN web page; >>>unfortunately I do not know how to install a package using its source. >>> >>>Can you please advise me on how to get one of these? > > From @d| @end|ng |rom rod@@ro Sun Oct 26 15:28:43 2003 From: @d| @end|ng |rom rod@@ro (Adrian Dusa) Date: Sun, 26 Oct 2003 16:28:43 +0200 Subject: [R-sig-DB] RMySQL and RmSQL In-Reply-To: <3F9A7DC2.1020507@statistik.uni-dortmund.de> Message-ID: <000001c39bcd$88be9c20$6901a8c0@roda.local> Thank you all, I'll keep an eye open on CRAN for more news. Adrian -----Original Message----- From: Uwe Ligges [mailto:ligges at statistik.uni-dortmund.de] Sent: Saturday, October 25, 2003 4:42 PM To: Prof Brian Ripley Cc: David James; Adrian Dusa; r-sig-db at stat.math.ethz.ch Subject: Re: [R-sig-DB] RMySQL and RmSQL Prof Brian Ripley wrote: > It's very good that David is providing a binary, Indeed, thanks to David! > but please check > compatibility with your version of RMySQL and your version of R (I believe > there are problems with R 1.8.0). > > We gave up providing binary versions on CRAN after a lot of problems with > supposedly compatible versions of MySQL client libraries not being so. > > I am copying this to Uwe Ligges so he can put something in the ReadMe. Thanks, I did. Will appear on CRAN in a couple of days. Uwe > On Fri, 24 Oct 2003, David James wrote: > > >>Hi Adrian, >> >>You may download a windows binary from >> http://stat.bell-labs.com/RS-DBI/download >> >>Hope this helps, >> >>-- >>David >> >>Adrian Dusa wrote: >> >>>Hi, >>> >>> >>> >>>I'd like to try the RMySQL or RmSQL packages, but they are not to be >>>found via the "Install package(s) from CRAN" menu. >>> >>>I found the sources for these packages on the CRAN web page; >>>unfortunately I do not know how to install a package using its source. >>> >>>Can you please advise me on how to get one of these? > > From Joerg@Sch@ber @end|ng |rom uv@e@ Mon Oct 27 13:31:12 2003 From: Joerg@Sch@ber @end|ng |rom uv@e@ (Joerg Schaber) Date: Mon, 27 Oct 2003 13:31:12 +0100 Subject: [R-sig-DB] ROracle fetch problems Message-ID: <3F9D1010.3070600@uv.es> Hi, I am using the ROralce interface (version 0.5-0) for accessing my Oracle database from R 1.7.1 (64 bit version, powerpc-ibm-aix5.1.0.0). The connection works fine, however, I get some strange results using 'fetch'. I found out that 'fetch' fetches only every second row of the 'native' SQL-results and fills up the rest of the rows with zeros. Here a draft: The native SQL-query: 12:43:07 SQL> SELECT OBS_DAY, OBS_YEAR, STAT_ID FROM WILD_PHENO_OBS WHERE PHASE_ID=7 AND OBS_YEAR BETWEEN 1951 AND 2000 order by stat_id, obs_year, obs_day; PLEASE HIT RETURN TO CONTINUE OBS_DAY OBS_YEAR STAT_ID ---------- ---------- ---------- 133 1954 11110000 140 1955 11110000 147 1956 11110000 133 1957 11110000 146 1958 11110000 118 1959 11110000 132 1960 11110000 120 1961 11110000 138 1962 11110000 144 1963 11110000 Here what fetches R: > DBres <- dbSendQuery(DBcon, "SELECT OBS_DAY, OBS_YEAR, STAT_ID FROM WILD_PHENO_OBS WHERE PHASE_ID=7 AND OBS_YEAR BETWEEN 1951 AND 2000 order by stat_id, obs_year, obs_day") > fetch(DBres,n=10) OBS_DAY OBS_YEAR STAT_ID 0 140 1955 11110000 1 133 1957 11110000 2 118 1959 11110000 3 120 1961 11110000 4 144 1963 11110000 5 0 0 11110000 6 0 0 11110000 7 0 0 11110000 8 0 0 11110000 9 0 0 11110000 > > dbGetInfo(ora) $drvName [1] "Oracle (ProC/C++)" $connectionIds $connectionIds[[1]] $"fetch_default_rec" [1] 500 $managerId $length [1] 10 $"num_con" [1] 1 $counter [1] 1 $clientVersion [1] "0.5-0" Any idea what's the problem here? Greetings, joerg -- ---------------------------------------------------------- J?rg Schaber Instituto Cavanilles de Biodiversidad y Biologia Evolutiva Universidad de Valencia Tel.: ++34 96 354 3666 A.C. 22085 Fax.: ++34 96 354 3670 46071 Valencia, Espa?a email : jos at uv.es From m@||-||@t @end|ng |rom geotux@|t Thu Oct 30 16:41:35 2003 From: m@||-||@t @end|ng |rom geotux@|t (Antonio) Date: Thu, 30 Oct 2003 16:41:35 +0100 Subject: [R-sig-DB] Connecting to Postgresql with R under Debian Woody. Message-ID: <20031030154135.GB2428@gaia> Hi. It's my first approach with R so don't be mad with me for the simple question I'm going to make. How do I connect to my Postgresql databases on my Debian Woody. These are the r-* packages I've installed: ii r-base 1.5.1-0woody1 GNU R statistical computing language and env ii r-base-core 1.8.0.cvs.2003 GNU R core of statistical computing language ii r-base-dev 1.5.1-0woody1 GNU R installation of auxiliary GNU R packag ii r-base-html 1.5.1-0woody1 GNU R html docs for statistical computing sy ii r-base-latex 1.5.1-0woody1 GNU R LaTeX docs for statistical computing s ii r-cran-coda 0.5-15-1 Output analysis and diagnostics for MCMC sim ii r-cran-design 2.0.2-1 GNU R regression modeling strategies tools b ii r-cran-gtkdevi 0.5.3.1-1 GNU R Gtk device driver package ii r-cran-hmisc 2.0.4-1 GNU R miscellaneous functions by Frank Harre ii r-cran-mcmcpac 0.4-3-1 routines for Markov Chain Monte Carlo model ii r-doc-pdf 1.5.1-0woody1 GNU R pdf manuals for statistical computing ii r-gnome 1.8.0.cvs.2003 GNU R Gnome gui for statistical computing sy ii r-noncran-lind 1.0.20031022-1 GNU R libraries contributed by Jim and Patri ii r-omegahat-rgt 0.6.10-1 GNU R binding for Gtk ii r-recommended 1.5.1-0woody1 GNU R collection of recommended packages What am I missing? Because, when I try library(RPgSQL) it tells me there is no such library. Even when I try library() to list all libraries I don't get any output that resembles sql or dbi or anything like that...... Does any one have any suggestions? Thanks From edd @end|ng |rom deb|@n@org Thu Oct 30 19:54:56 2003 From: edd @end|ng |rom deb|@n@org (Dirk Eddelbuettel) Date: Thu, 30 Oct 2003 12:54:56 -0600 Subject: [R-sig-DB] Connecting to Postgresql with R under Debian Woody. In-Reply-To: <20031030154135.GB2428@gaia> References: <20031030154135.GB2428@gaia> Message-ID: <20031030185456.GA1436@sonny.eddelbuettel.com> On Thu, Oct 30, 2003 at 04:41:35PM +0100, Antonio wrote: > > Hi. > > It's my first approach with R so don't be mad with me for the simple > question I'm going to make. > > How do I connect to my Postgresql databases on my Debian Woody. > These are the r-* packages I've installed: > > ii r-base 1.5.1-0woody1 GNU R statistical computing language > and env > ii r-base-core 1.8.0.cvs.2003 GNU R core of statistical computing > language That looks like a very random mix of a 1.8.1 prerelease (from unstable), and the by now old 1.5.1 from stable. This is almost surely a bad idea. There are recompiled 1.8.0 packages for Debian stable on CRAN. Why not use those? > ii r-base-dev 1.5.1-0woody1 GNU R installation of auxiliary GNU R > packag > ii r-base-html 1.5.1-0woody1 GNU R html docs for statistical > computing sy > ii r-base-latex 1.5.1-0woody1 GNU R LaTeX docs for statistical > computing s > ii r-cran-coda 0.5-15-1 Output analysis and diagnostics for > MCMC sim > ii r-cran-design 2.0.2-1 GNU R regression modeling strategies > tools b > ii r-cran-gtkdevi 0.5.3.1-1 GNU R Gtk device driver package > ii r-cran-hmisc 2.0.4-1 GNU R miscellaneous functions by Frank > Harre > ii r-cran-mcmcpac 0.4-3-1 routines for Markov Chain Monte Carlo > model > ii r-doc-pdf 1.5.1-0woody1 GNU R pdf manuals for statistical > computing > ii r-gnome 1.8.0.cvs.2003 GNU R Gnome gui for statistical > computing sy > ii r-noncran-lind 1.0.20031022-1 GNU R libraries contributed by Jim and > Patri > ii r-omegahat-rgt 0.6.10-1 GNU R binding for Gtk > ii r-recommended 1.5.1-0woody1 GNU R collection of recommended > packages > > > What am I missing? > Because, when I try library(RPgSQL) it tells me there is no such > library. Even when I try library() to list all libraries I don't get any > output that resembles sql or dbi or anything like that...... > Does any one have any suggestions? Well, you need to install the corresponding CRAN packages. Dbi and friends are not available as Debian packages. To return this to 'how do I connect to Pg under Debian 3.0': -- install odbc-postgresql and its Depends to give you ODBC on Debian -- set up DSN entries (not trivial, and I wish it was documented better) I thing there is some documentation in r-cran-rodbc -- use RODBC to connect to Pg via ODBC. Hth, Dirk -- Those are my principles, and if you don't like them... well, I have others. -- Groucho Marx From m@||-||@t @end|ng |rom geotux@|t Thu Oct 30 20:44:27 2003 From: m@||-||@t @end|ng |rom geotux@|t (Geotronix) Date: Thu, 30 Oct 2003 20:44:27 +0100 Subject: [R-sig-DB] Connecting to Postgresql with R under Debian Woody. In-Reply-To: <20031030185456.GA1436@sonny.eddelbuettel.com> References: <20031030154135.GB2428@gaia> <20031030185456.GA1436@sonny.eddelbuettel.com> Message-ID: <20031030194427.GA4091@gaia> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 * gioved? 30 ottobre 2003, alle 12:54, Dirk Eddelbuettel scrive: > > That looks like a very random mix of a 1.8.1 prerelease (from unstable), > and the by now old 1.5.1 from stable. This is almost surely a bad idea. Oopps, :-) I didn't notice that. My system is a 70% stable & 30% unstable so sometimes I miss these mixes. > > There are recompiled 1.8.0 packages for Debian stable on CRAN. Why not use > those? I forgot to look at www.apt-get.org ;-) so thanks for reminding me. > > Well, you need to install the corresponding CRAN packages. Dbi and friends > are not available as Debian packages. > > To return this to 'how do I connect to Pg under Debian 3.0': > > -- install odbc-postgresql and its Depends to give you ODBC on Debian > -- set up DSN entries (not trivial, and I wish it was documented better) > I thing there is some documentation in r-cran-rodbc > -- use RODBC to connect to Pg via ODBC. > Mmm, I remember I had a lot of problems setting up ODBC when I wanted to get it to work with openoffice.org .......... hope it'll be easier now. Sorry, but how do I get to this r-cran-rodbc. I tried a search on the r-project serch engine page but had no luck. Is it a directory under the CRAN tree? or what? I tried to google it but was even less luckier. It doesn't seem to be a deb package as apt-cache search returned nothing. Bye BTW. Updated docs on the RODBC stuff? Is the "R Data Import/Export" pdf file for 1.8.0 the most updated on this? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/oWoaIRaQQEznKxURAoNfAJsHeRYYHQuaZTXTUHU4l1JZ6cfsXgCgzzbn T+FwqBRS4HW7FEajIBYp3Y4= =QB3A -----END PGP SIGNATURE----- From m@||-||@t @end|ng |rom geotux@|t Thu Oct 30 20:52:26 2003 From: m@||-||@t @end|ng |rom geotux@|t (Geotronix) Date: Thu, 30 Oct 2003 20:52:26 +0100 Subject: [R-sig-DB] Connecting to Postgresql with R under Debian Woody. In-Reply-To: <20031030185456.GA1436@sonny.eddelbuettel.com> References: <20031030154135.GB2428@gaia> <20031030185456.GA1436@sonny.eddelbuettel.com> Message-ID: <20031030195226.GB4091@gaia> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 * gioved? 30 ottobre 2003, alle 12:54, Dirk Eddelbuettel scrive: > > To return this to 'how do I connect to Pg under Debian 3.0': > > -- install odbc-postgresql and its Depends to give you ODBC on Debian > -- set up DSN entries (not trivial, and I wish it was documented better) > I thing there is some documentation in r-cran-rodbc > -- use RODBC to connect to Pg via ODBC. Mmmmm, sorry for my previous message. I'm feeling rather clumsly today. I mistyped r-cran-rodbc to r-cram-rodbc in google. So r-cran-rodbc is a package in debian/unstable. I've figured this at least :-) Hope I'll get things going. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/oWv6IRaQQEznKxURAqhAAKChU8+VCH2j7q4gQQNtuVl3NghuCgCgtWtq fVkaI92xnlAEWXeU1NWMRac= =pe+f -----END PGP SIGNATURE----- From m@||-||@t @end|ng |rom geotux@|t Fri Oct 31 11:35:54 2003 From: m@||-||@t @end|ng |rom geotux@|t (Geotronix) Date: Fri, 31 Oct 2003 11:35:54 +0100 Subject: [R-sig-DB] Can't connect to postgresql with RODBC. Message-ID: <20031031103554.GB1247@gaia> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've finally got a DSN working on my ODBC installation (via a ~/.odbc.ini file) and I've tested it with the ODBC DataManager so I'm sure it's working. However when trying to connect to the DSN via R interface I get an error: > channel <- odbcConnect("test", uid="ant", pwd="fr", > case="postgresql") Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, ";UID=", uid, ";PWD=", pwd, > Before the odbcCOnnect() command I gave the library(RODBC) command and it gave no error (I installed r-cran-rodbc on my woody). I'm using the PDF file "R data import/Export" as a guide and it doesn't recall any configuration for RODBC. What am I missing? If unixODBC finds my DSN why isn't RODBC finding it? (This means it's not a unixODBC problem, right?) Bye -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/ojsKIRaQQEznKxURAqWTAJ9CQ6BR/1L38CeB3OdhlgJaT/VJ6ACdHs3T iyPa4GJxUz7UhPkeBAzITFo= =ARSM -----END PGP SIGNATURE----- From r|p|ey @end|ng |rom @t@t@@ox@@c@uk Fri Oct 31 12:29:28 2003 From: r|p|ey @end|ng |rom @t@t@@ox@@c@uk (Prof Brian Ripley) Date: Fri, 31 Oct 2003 11:29:28 +0000 (GMT) Subject: [R-sig-DB] Can't connect to postgresql with RODBC. In-Reply-To: <20031031103554.GB1247@gaia> Message-ID: On Fri, 31 Oct 2003, Geotronix wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > Hi, > > I've finally got a DSN working on my ODBC installation (via a > ~/.odbc.ini file) and I've tested it with the ODBC DataManager so I'm > sure it's working. > However when trying to connect to the DSN via R interface I get an > error: > > > channel <- odbcConnect("test", uid="ant", pwd="fr", > > case="postgresql") > Warning messages: > 1: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver > Manager]Data source name not found, and no default driver specified > 2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, > ";UID=", uid, ";PWD=", pwd, > > > > Before the odbcCOnnect() command I gave the library(RODBC) command and > it gave no error (I installed r-cran-rodbc on my woody). > > I'm using the PDF file "R data import/Export" as a guide and it doesn't > recall any configuration for RODBC. What am I missing? > > If unixODBC finds my DSN why isn't RODBC finding it? (This means it's > not a unixODBC problem, right?) It is a unixODBC problem, as that's what gave the error message. Check that you can access the DBMS from the same account and the same directory. -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 From m@|| @end|ng |rom joeconw@y@com Fri Oct 31 20:46:34 2003 From: m@|| @end|ng |rom joeconw@y@com (Joe Conway) Date: Fri, 31 Oct 2003 11:46:34 -0800 Subject: [R-sig-DB] Can't connect to postgresql with RODBC. In-Reply-To: <20031031103554.GB1247@gaia> References: <20031031103554.GB1247@gaia> Message-ID: <3FA2BC1A.9070902@joeconway.com> Geotronix wrote: > If unixODBC finds my DSN why isn't RODBC finding it? (This means it's > not a unixODBC problem, right?) > FWIW, I saw the other day that the new release of bioconductor includes an updated version of RdbiPgSQL -- i.e. a native connection not requiring ODBC. I've not tried to use it myself yet, but you can find it here: http://www.bioconductor.org/repository/release1.3/package/html/RdbiPgSQL.html HTH, Joe From m@||-||@t @end|ng |rom geotux@|t Fri Oct 31 20:41:39 2003 From: m@||-||@t @end|ng |rom geotux@|t (Geotronix) Date: Fri, 31 Oct 2003 20:41:39 +0100 Subject: [R-sig-DB] Can't connect to postgresql with RODBC. In-Reply-To: References: <20031031103554.GB1247@gaia> Message-ID: <20031031194139.GE1247@gaia> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 * venerd? 31 ottobre 2003, alle 11:29, Prof Brian Ripley scrive: > > It is a unixODBC problem, as that's what gave the error message. > Check that you can access the DBMS from the same account and the same > directory. Yes, it was a unixODBC problem. I was miss typing a DB name in the odbc.ini file. Finally isql could connect to the DB so also R now connects to the PostgreSQL DB through ODBC. Thanks for your help. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/orrzIRaQQEznKxURAinfAJ4nGeK2hue+uZCM43sm3TfavLPZbQCfWDiW la+rxvD9DZTk9jImTMZkvIo= =DEvX -----END PGP SIGNATURE----- From vogr@no @end|ng |rom @bcg|ob@|@net Fri Nov 7 00:49:40 2003 From: vogr@no @end|ng |rom @bcg|ob@|@net (Vadim Ogranovich) Date: Thu, 6 Nov 2003 15:49:40 -0800 Subject: [R-sig-DB] dbListTables fails with Oracle Message-ID: Hi, I just installed ROracle under R1.8.1 alpha. There is a funny error in dbListTables(). When you run dbListTables just after establishing a connection it fails at oraQuickSQL(conn, "select table_name from all_tables")[, 1], see below. However if you execute oraQuickSQL(conn, "select table_name from all_tables")[, 1] from the prompt it will work fine and, moreover, the dbListTables() will work fine after that too. > library("DBI"); library("ROracle") > con <- dbConnect(dbDriver("Oracle"), user="...") > dbListTables(con) Error in oraQuickSQL(conn, "select table_name from all_tables")[, 1] : incorrect number of dimensions > oraQuickSQL(conn, "select table_name from all_tables")[, 1] Error in .class1(object) : Object "conn" not found > oraQuickSQL(con, "select table_name from all_tables")[, 1] *** works fine:output flushed *** > dbListTables(con) *** works fine:output flushed *** Any clue? Thanks, Vadim > version _ platform i686-pc-linux-gnu arch i686 os linux-gnu system i686, linux-gnu status alpha major 1 minor 8.1 year 2003 month 11 day 05 language R [[alternative HTML version deleted]] From dj @end|ng |rom re@e@rch@be||-|@b@@com Fri Nov 7 03:24:07 2003 From: dj @end|ng |rom re@e@rch@be||-|@b@@com (David James) Date: Thu, 6 Nov 2003 21:24:07 -0500 Subject: [R-sig-DB] dbListTables fails with Oracle In-Reply-To: ; from vograno@sbcglobal.net on Thu, Nov 06, 2003 at 03:49:40PM -0800 References: Message-ID: <20031106212407.A14919@jessie.research.bell-labs.com> Hi, That problem appears(?) to be coming from the generated code by the pre-compiler Pro*C/C++. In any event I've put a workaround (plus a couple of other bug fixes) in the latest version which will appear in CRAN sometime soon. In the meantime you may download a pre-release version at http://stat.bell-labs.com/RS-DBI Hope this helps, -- David Vadim Ogranovich wrote: > Hi, > > I just installed ROracle under R1.8.1 alpha. There is a funny error in > dbListTables(). When you run dbListTables just after establishing a > connection it fails at oraQuickSQL(conn, "select table_name from > all_tables")[, 1], see below. However if you execute oraQuickSQL(conn, > "select table_name from all_tables")[, 1] from the prompt it will work > fine and, moreover, the dbListTables() will work fine after that too. > > > library("DBI"); library("ROracle") > > con <- dbConnect(dbDriver("Oracle"), user="...") > > dbListTables(con) > Error in oraQuickSQL(conn, "select table_name from all_tables")[, 1] : > incorrect number of dimensions > > oraQuickSQL(conn, "select table_name from all_tables")[, 1] > Error in .class1(object) : Object "conn" not found > > oraQuickSQL(con, "select table_name from all_tables")[, 1] > *** works fine:output flushed *** > > dbListTables(con) > *** works fine:output flushed *** > > > Any clue? > > Thanks, > Vadim > > > > > version > _ > platform i686-pc-linux-gnu > arch i686 > os linux-gnu > system i686, linux-gnu > status alpha > major 1 > minor 8.1 > year 2003 > month 11 > day 05 > language R > > > [[alternative HTML version deleted]] > > _______________________________________________ > R-sig-DB mailing list -- R Special Interest Group > R-sig-DB at stat.math.ethz.ch > https://www.stat.math.ethz.ch/mailman/listinfo/r-sig-db -- David A. James Statistics Research, Room 2C-253 Phone: (908) 582-3082 Bell Labs, Lucent Technologies Fax: (908) 582-3340 Murray Hill, NJ 09794-0636