r - RODBC connectivity to Oracle without tnsnames.ora -

-

i trying connect oracle r using rodbc without using tnsnanes.ora.

i have tried following strings, none of them working.

> con.text <- paste0("driver={oracleodbc-11g};dbq=//oracle.server:1527/database.pdw.prod;uid=user;pwd=pswd;")  > con.text <- paste0("driver={oracleodbc-11g}; ",          "connectstring=(description=(address= (protocol = tcp)(host = oracle.server)(port = 1527))(connect_data=(service_name = database.pdw.prod))); uid=user;pwd=pswd;")  > con.text <- paste0("driver=", "oracleodbc-11g"                      , ";server=", "oracle.server"                      , ";database=", "database.pdw.prod"                      , ";uid=", "user"                      , ";pwd=", "pwd", ";")  > con.text <- paste0("driver=", "oracleodbc-11g"                       , ";server=", "oracle.server"                       , ";connectstring=" , "(description=(address= (protocol = tcp)(host = oracle.server)(port = 1527))(connect_data=(service_name = database.pdw.prod)))"                        , ";database=", "database.pdw.prod"                       , ";uid=", "user"                       , ";pwd=", "pswd", ";") > con1 <- odbcdriverconnect(connection = con.text)

but these strings getting following error:

warning messages: 1: in odbcdriverconnect(connection = con.text) :  [rodbc] error: state hy000, code 12162, message [unixodbc][oracle][odbc][ora]ora-12162: tns:net service name incorrectly specified 2: in odbcdriverconnect(connection = con.text) : odbc connection failed

or

      1: in odbcdriverconnect(connection = con.text) :   [rodbc] error: state im002, code 0, message [unixodbc][driver manager]data source name not found, , no default driver specified

the correct sysntaxis looking is

conex     <- odbcdriverconnect("driver=oracle en oraclient11g_home2;uid=username;pwd=password;dbq=//hostname:port/oracle_sid;",              believenrows = false)

ex

conex     <- odbcdriverconnect("driver=oracle en oraclient11g_home2;uid=john;pwd=deere;dbq=//fcoracleserver.youdomain:1521/testenvironment;",              believenrows = false)

the hard part find name of driver, can see mine on spanish.

what did create first odbc conection using c:\windows\system32\odbcad32.exe, there can check right name of oracle or sql server driver.

once create conection, can use odbcdatasources() on r, see conection , find out driver. thats hard part.

hope helps !


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more