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
