Daniel, Thanks for letting me know.
I'll try it w/o Rstudio if needed. Thanks. Dan -----Original Message----- From: Daniel J. Robertson [mailto:dj...@cornell.edu] Sent: Monday, April 22, 2013 1:51 PM To: Lopez, Dan; R help (r-help@r-project.org) Subject: RE: [R] RODBC --How do you set up the connection so pwd is blank but driver-specific data source dialog box pops up after The password window popup apparently doesn't yet work with RStudio: e.g., http://support.rstudio.org/help/discussions/problems/4371-rodbc-connection-issue -- Daniel Robertson Senior Research and Planning Associate Institutional Research and Planning Cornell University / irp.cornell.edu -----Original Message----- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Lopez, Dan Sent: Monday, April 22, 2013 4:41 PM To: R help (r-help@r-project.org) Subject: [R] RODBC --How do you set up the connection so pwd is blank but driver-specific data source dialog box pops up after Hello, I want to leave pwd blank (to comply w/ company security protocol) and just be prompted by the driver-specific data source dialog box to enter the password after. But for some reason it is not working. R Version: "R version 2.15.1 (2012-06-22)" R Studio Version: 0.97.312 OS: Windows 7 library(RODBC) ##HERE IS THE CODE THAT DOES WORK ##my DSN, UID, PWD is entered something like this ch <- odbcConnect("jjprd", uid = "lopez123", pwd = "123456") ##I then successfully run a query sqlQuery(ch,"SELECT Count(*) FROM PS_EXIT_SURVEY_LL") #BUT WHEN I TRY TO LEAVE pwd BLANK THIS HAPPENS: ch <- odbcConnect("jjprd", uid = "lopez123") Warning messages: 1: In odbcDriverConnect("DSN=jjprd;UID=lopez123") : [RODBC] ERROR: state 28000, code 768, message [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied 2: In odbcDriverConnect("DSN=jjprd;UID=lopez123") : ODBC connection failed #I read the vignette and on page 3 its says that if you leave password blank then a driver-specific Data Source dialog box will pop up to allow it to be completed. This is the way it works in MS Access or TOAD (SQL editor) for example. But it's not popping up? What am I missing? RShowDoc("RODBC", package="RODBC") Daniel Lopez Workforce Analyst HRIM - Workforce Analytics & Metrics Strategic Human Resources Management [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
