View R Plots from within SQL Server Management Studio

  • Bill Palace

    SSC Enthusiast

    Points: 102

    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

    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

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply