Displaying 1 result from an estimated 1 matches for "ps_exit_survey_ll".
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
...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...