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

c# - Unity IoC Lifetime per HttpRequest for UserStore -

Change the color of an oval at click in Java AWT -

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -