Skip to content

RODBC problems

2 messages · Ingolf Kuehn, Uwe Ligges

#
Hello,

I successfully used RODBC very frequently, but after having updatetd to R 6.0.2, the 
current RODBC-Version gives me some problems.

After connecting to my Oracle-Database via odbcConnect("") (or the necessary 
information) I receive a much longer output than usual:

RODB Connection 0
Details:
  case=nochange
  DRIVER={Oracle in OraHome90}
...

with all the details.

Previously, I just received my connection number (channel).

When I try to get data, now, I get an error, e.g.
Error in odbcTables(0) : first argument is not an open RODBC channel

However, I use the same DSN as ever and it works perfectly from MS-Query, MS-
Access and Quest-Toad to connect to Oracle

My machine is a Pentium 3 with Windows XP.

Any help or suggestions are appreciated!

Thanks a lot

Ingolf Kuehn


================================================
Dr. Ingolf Kuehn
UFZ - Umweltforschungszentrum Leipzig-Halle GmbH
- Sektion Biozoenoseforschung -
UFZ - Centre for Environmental Research
- Department of Community Ecology -
Theodor-Lieser-Strasse 4
06120 Halle
Germany
Tel (+49)345 / 558 5311
Fax (+49)345 / 558 5329
email: kuehn at halle.ufz.de
http://www.ufz.de/spb/bioz/
#
Ingolf Kuehn wrote:
Reading, e.g., ?odbcTables helps:

You have to specify the 'channel', which is a 'connection handle as 
returned by odbcConnect() of class "RODBC"', but not any integer.

Uwe Ligges