Dear Shlomo, Just last week I experienced a similar problem with RODBC and MySQL under Windows, though the problem extended to both Rterm *and* Rgui. After a fair amount of detective work, I discovered that the source of the difficulty was a newly downloaded MySQL ODBC Windows driver. When I instead installed a driver downloaded last December, everything worked fine. I've just confirmed that I can access MySQL from both Rterm and Rgui. I'm using R 2.0.1 under Windows XP.
Since your symptoms are slightly different from mine, the ODBC driver may not be the source of the difficulty, but I thought that it might be worthwhile to mention it. Regards, John -------------------------------- John Fox Department of Sociology McMaster University Hamilton, Ontario Canada L8S 4M4 905-525-9140x23604 http://socserv.mcmaster.ca/jfox -------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shlomo > Katchmalik > Sent: Sunday, February 06, 2005 11:03 PM > To: [email protected] > Subject: Re: [R] RODBC working in Rgui but not Rterm > > 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 > <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Shlomo > > Katchmalik > > Sent: Monday, 7 February 2005 11:10 AM > > To: [email protected] > > 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 <[EMAIL PROTECTED]> > > Date: Mon, 7 Feb 2005 10:49:56 +1000 > > Subject: RE: [R] RODBC working in Rgui but not Rterm > > To: Shlomo Katchmalik <[EMAIL PROTECTED]> > > > > 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, [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Shlomo > > Katchmalik > > Sent: Monday, 7 February 2005 10:33 AM > > To: [email protected] > > 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. > > > > > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
