Displaying 1 result from an estimated 1 matches for "lopez123".
2013 Apr 22
2
RODBC --How do you set up the connection so pwd is blank but driver-specific data source dialog box pops up after
...ssword 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("DS...