database - R-studio/Oracle DB connection -
i created new dsn on local machine. after doing that, following error message. can advice on how fix this?
connection<- odbcconnect(dsn="oradb1",uid="username",pwd="password") warning messages: 1: in odbcdriverconnect("dsn=oradb1;uid=username;pwd=password") : [rodbc] error: state na000, code 12504, message [microsoft][odbc driver oracle][oracle]ora-12504: tns:listener not given service_name in connect_data 2: in odbcdriverconnect("dsn=oradb1;uid=username;pwd="password") : [rodbc] error: state 01000, code 0, message [microsoft][odbc driver manager] driver doesn't support version of odbc behavior application requested (see sqlsetenvattr). 3: in odbcdriverconnect("dsn=oradb1;uid=username;pwd=password") : odbc connection failed
you need make sure if works basic r command line first.
based on error msg, system(or r studio) not recognize new dsn , driver. did put user dsn or system dsn?
Comments
Post a Comment