[R] RODBC/odbcConnect and Xemacs/ess Problem

[witek]

Hi Folks

I am trying to use Xemacs/ess 5.2 on windows XP and have a problem with the RODBC package in R1.9.0

library(RODBC) 
channel<-odbcConnect("mysql")
Warning messages: 
1: [RODBC] ERROR: Could not SQLDriverConnect 
2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, ";UID=", uid, ";PWD=", pwd,  

But the same code works in the Rterm, Rgui with the same R1.9.1 

On a Windows 2000 computer with R1.9.1 and Xemacs/ESS 5.1.24 the same code is working.

Any ideas sugestions?

Eryk



Sys.info()
                      sysname                       release 
                    "Windows"                      "NT 5.1" 
                      version                      nodename 
"(build 2600) Service Pack 1"                        "FUGU" 
                      machine                         login 
                        "x86"                     "ewolski" 
                         user 
                    "ewolski" 


R.Version()
$platform
[1] "i386-pc-mingw32"

$arch
[1] "i386"

$os
[1] "mingw32"

$system
[1] "i386, mingw32"

$status
[1] ""

$major
[1] "1"

$minor
[1] "9.0"

$year
[1] "2004"

$month
[1] "04"

$day
[1] "12"

$language
[1] "R"