none
Revolution R Enterprise odbc connection to Oracle failed, any idea? RRS feed

  • Question

  • Hi, everybody,

           I'm new to Revolution R Enterprise and want to have a test on RevoScaleR's big data functions against Oracle, as the production database of my organization is Oracle. I use oracle instant client 12.1,  the odbc driver seems to be O.K. because the  RODBC package works quite well, the problem is that when I try to use RevoScaleR's rxImport to connect to Oracle, RPE is then halt.

    tablesDS <- RxOdbcData(sqlQuery="select * from user_tables",

    connectionString = "DSN=mydb;Uid=myuser;Pwd=mypassword")

    OracleTableDF <- rxImport(tablesDS, overwrite=TRUE)

    OracleTableDF[,1]

    The code is from the manual book RevoScaleR_ODBC.pdf, the first line RxOdbcData is O.K., my OS is windows 7, any idea is appreciated, thanks in advanced.

    Tuesday, April 5, 2016 2:53 PM

All replies

  • O.K., I make a workaround by dumping data from Oracle to a  CSV file and then import it with rxImport later.

    But the issue is still there.

    Wednesday, April 6, 2016 3:07 PM
  •  Hi Jean,

    Can you please try to use Rgui.exe as the IDE so that we will know if this issue is caused by RPE.

    Thanks,

    Carl

    Thursday, April 7, 2016 4:46 PM
  • Here's the output from RGUI of rxImport and RODBC, RODBC is O.K. and rxImport failed.

    > yzmxDS<-RxOdbcData(connectionString = "DSN=zhsjxf;Uid=db_zhgy;Pwd=db_zhgy",verbose=1,reportProgress = 3,sqlQuery = "select * from db_xtwh.t_dm_gy_zspm")
    Data source type: RxOdbcData, useFastRead = TRUE
    > yzmx<-rxImport(yzmxDS,verbose=1,reportProgress = 3)
    Import type: odbcFast
    Error in doTryCatch(return(expr), name, parentenv, handler) : 
      no message recieved from pipe
    Error in doTryCatch(return(expr), name, parentenv, handler) : 
      Write error: expected 8 got 
    > con<-odbcConnect("zhsjxf", uid = "db_zhgy", pwd = "db_zhgy")
    > zsxm<-sqlQuery(con,"select * from db_xtwh.t_dm_gy_zspm")

    Wednesday, April 13, 2016 1:41 AM