[R] RODBC working in Rgui but not Rterm

[Shlomo Katchmalik]

Thanks for your response.  I'm not aware of passing any arguments to
either Rgui or Rterm.  I have the R\bin subdirectory in my path, so to
run the programs, I simply type "rgui" or "rterm" from the DOS
(actually TakeCommand) prompt.

---------- Forwarded message ----------
From: Andrew Ward <Andrew.Ward at qsa.qld.edu.au>
Date: Mon, 7 Feb 2005 10:49:56 +1000
Subject: RE: [R] RODBC working in Rgui but not Rterm
To: Shlomo Katchmalik <katchmalik at gmail.com>


I wonder if you provide any arguments in Rgui
that aren't given with Rterm? For instance,
if in Rgui you get prompted for a username
or password, then these ought to appear in
the called to odbcConnect. Can you let us
know if you've already tried this?

Regards,

Andrew C. Ward,                andrew.ward at qsa.qld.edu.au
Senior Analyst (Quantitative), Tel: +61 7 3864 0439
Queensland Studies Authority,  Fax: +61 7 3229 3318
295 Ann Street,
Brisbane Qld 4000, Australia

-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
[mailto:r-help-bounces at stat.math.ethz.ch]On Behalf Of Shlomo Katchmalik
Sent: Monday, 7 February 2005 10:33 AM
To: r-help at stat.math.ethz.ch
Subject: [R] RODBC working in Rgui but not Rterm

Hello Users:

I'm using R version 2.0.1, and having problems with RODBC.  Everything
works fine when I use Rgui, but when I try to use Rterm and issue the
commands
  library(RODBC)
  con <- odbcConnect("MySQL", "test")

I get the following error:
Error in sqlQuery(con, str) : first argument is not an open RODBC channel
In addition: Warning messages:
1: [RODBC] ERROR: state IM008, code 0, message [MySQL][ODBC 3.51 Driver]Invalid
window handle for connection completion argument.
2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows =
believeNRows)

Does anybody know how I can fix this problem?

Thanks,
Shlomo.