
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}}


