R help - Aug 2003 - RODBC with Windows XP

Hi R-Users, 

I have very recently switched from using R on windows 2000 to windows XP
Professional. With XP I am having problems 
using the "odbcConnect("")" command. I can use the command
perfectly well
until I close the database channel 
with the command "odbcClose(channel)".  When I try and re-establish
connection following the close command no dialog box appears 
and an error message is displayed. 

I am using version 1.6.2 of R.

The following is an example of this bewildering problem.

> library(RODBC)
> channel<-odbcConnect("")
> 
> channel
RODB Connection 0
Details:
  case=nochange
  DSN=Sheetz2
  UID  PWD  WSID=WS1223
  DATABASE=Sheetz2
  Trusted_Connection=Yes
> 
> 
> 
> odbcClose(channel)
> 
> channel<-odbcConnect("")
Warning messages: 
1: [RODBC] ERROR: state IM008, code 0, message [Microsoft][ODBC Driver
Manager] Dialog failed 
2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn,
";UID=",
uid, ";PWD=", pwd,  
> 

Any suggestions on how to fix this problem would be much appreciated. 

Regards,

Wayne






KSS Ltd
Seventh Floor  St James's Buildings  79 Oxford Street  Manchester  M1 6SS 
England
Company Registration Number 2800886
Tel: +44 (0) 161 228 0040	Fax: +44 (0) 161 236 6305
mailto:kssg@kssg.com		http://www.kssg.com


The information in this Internet email is confidential and m...{{dropped}}

This works perfectly on my XP machine.  I suspect your ODBC drivers: have 
you tried re-installing them?  (Especially if you upgraded to XP.)

On Wed, 6 Aug 2003, Wayne Jones wrote:
> 
> Hi R-Users, 
> 
> I have very recently switched from using R on windows 2000 to windows XP
> Professional. With XP I am having problems 
> using the "odbcConnect("")" command. I can use the
command perfectly well
> until I close the database channel 
> with the command "odbcClose(channel)".  When I try and
re-establish
> connection following the close command no dialog box appears 
> and an error message is displayed. 
> 
> I am using version 1.6.2 of R.
Rather old, please update.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595