Re: [R] FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux

2010-01-14 Thread Marcus, Jeffrey
10:57 PM To: Marcus, Jeffrey Cc: r-help@r-project.org Subject: Re: [R] FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux Thanks you solved and share with us. But, why don't you use the RMySQL, which connects to MySQL without the need of ODBC? Caveman On Wed

[R] Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux

2010-01-12 Thread Marcus, Jeffrey
I am sure I'm doing something wrong here but not sure what. Our system administrator recently installed UnixODBC and the MyODBC driver on a Linux box running Linux version 2.6 x86_64. I have an .odbc.ini file in my home directory with following lines: [mydb] Description = MySQL server on

[R] FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux

2010-01-12 Thread Marcus, Jeffrey
I think I figured this out. I should not have put the Driver name in braces. Changing it from {MySQL} to MySQL seems to work. -Original Message- From: Marcus, Jeffrey Sent: Tuesday, January 12, 2010 6:09 PM To: 'r-help@r-project.org' Subject: Problems connecting with MySQL using

[R] Cannot update 2.8.1 packages: unable to access index for repository...

2009-03-09 Thread Marcus, Jeffrey
I am having trouble updating packages for R 2.8.1 in Windows XP. Note that I *am* able to update packages for R 2.7.0 (see bottom of posting) so this is not an Internet proxy problem. The steps I took were to (a) Copy over packages from my existing (2.7.0) library subdiretory to the R 2.8.1

[R] Problem with capabilities() in R2-8.1

2009-03-09 Thread Marcus, Jeffrey
I just installed R 2.8.1 on Windows XP. When I ran the source command, I got the error: Error in capabilities(iconv) : 1 argument passed to .Internal(capabilities) which requires 0 I looked at the code for source and it indeed has a call to capabilities(iconv) if (capabilities(iconv)) {