[R] RODBC working in Rgui but not Rterm

[Shlomo Katchmalik]

Oh, I see what you mean now.  Sorry for the misunderstanding.

I have my local MySQL database set with a very lax level of security,
so I don't need to use a password.  All I have needed in the past has
been to supply the uid, and everything has worked just fine, both for
Rgui and Rterm.  However, I recently reinstalled all of my software
and databases on a new machine, and since then, I haven't been able to
get RODBC to work from Rterm.

If I use only odbcConnect("MySQL"), I would previously get the dialog
box that you mention.  Now, however, I do not get that dialog box.

On Mon, 7 Feb 2005 12:32:08 +1000, Andrew Ward
<Andrew.Ward at qsa.qld.edu.au> wrote:
> I wasn't very clear, I'm afraid. When I call odbcConnect
> from within Rgui, a dialog box pops up asking me to enter
> a username and password (see ?odbcConnect). I wondered if
> you need to provide these in Rterm in your call to
> odbcConnect:
>         library(RODBC)
>         con <- odbcConnect(dsn="MySQL", uid="test", pwd="")
> 
> 
> -----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 11:10 AM
> To: r-help at stat.math.ethz.ch
> Subject: Re: [R] RODBC working in Rgui but not Rterm
> 
> 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.
>
>