[R] RODBC problems

[Uwe Ligges]

Ingolf Kuehn wrote:
> 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.
> 
> 
>>odbcTables(0)
> 
> Error in odbcTables(0) : first argument is not an open RODBC channel


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


> 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/
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help