search for: ps_exit_survey_l

Displaying 1 result from an estimated 1 matches for "ps_exit_survey_l".

Did you mean: ps_exit_survey_ll
RODBC --How do you set up the connection so pwd is blank but driver-specific data source dialog box pops up after
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]OR...