Post reply

View R Plots from within SQL Server Management Studio

  • 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

  • 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

  • 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.

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

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