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

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -