View R Plots from within SQL Server Management Studio

• Bill Palace

  SSC Enthusiast

  Points: 102

  More actions

  May 8, 2017 at 12:00 am

  #325371

  Comments posted to this topic are about the item View R Plots from within SQL Server Management Studio

• j.unger 2061

  SSC Rookie

  Points: 33

  More actions

  June 6, 2018 at 4:16 am

  #1993061

  Hi Bill,
  I tried this example out. The call from TSQL works nice.
  But call it via JDBC

  CallableStatement call = connection.prepareCall ("{call GetRPlotInHtml  (?,?,?)}");
                    call.setString(1, r);
                    call.setString(2, sql);

  gives an error: com.microsoft.sqlserver.jdbc.SQLServerException: Unerwarteter "R"-Skriptfehler beim Ausführen von "sp_execute_external_script" mit HRESULT 0x80004004.
  The user has the rights for any external script.
  Is this a limitation of R usage?
  Joachim

• Bill Palace

  SSC Enthusiast

  Points: 102

  More actions

  June 6, 2018 at 2:14 pm

  #1993154

  I'm not familiar with JDBC. I am only familiar with Dot NET. Sorry I could not be more help. I hope you get it working.