[R] Rgui crashes when calling odbcClose()

From: Robert Sams <robert_at_sanctumfi.com>
Date: Tue 16 Jan 2007 - 19:44:23 GMT


Hi,

I'm running Rgui v2.4.0, RODBC v1.1-8, and psqlODBC v8.2.0002. Whenever I do the following

chan <- odbcConnect("mydatabase", uid="admin") # connection to a postgresql db on a linux box
tmp <- sqlQuery(chan, "select * from sometable;") # this is successfull odbcClose(chan) # this crashes Rgui and raises an error window containing the following MS error signature:

	AppName: rgui.exe AppVer 2.4.39566.0 	ModName: psqlodbc35w.dll
	ModVer: 8.2.0.2    Offset: 00003248

I didn't find anything relevant in the R Windows FAQ or a few queries of the help archives; appologies if this has been addressed before.

Robert



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Wed Jan 17 06:48:58 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 16 Jan 2007 - 20:30:32 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.