Hello Gurus,
I am new bee to R setup.
in the Server i installed R packages through SQL 2019. In the client i installed the latest R studio and R server.
I installed the sqlmlutils and was fine to the server and connections.
I tried glue package which i am getting the below error.
required your support pls
library(sqlmlutils)
connection <- connectionInfo(
server = "XXXXXXXXXXXX",
database = "XXXXXXXXXXX",
uid = "sa",
pwd = "XXXXXXXXXXX")
sql_install.packages(connectionString = connection, pkgs = "glue", verbose = TRUE, scope = "PUBLIC")
library(sqlmlutils)
connection <- connectionInfo(
- server = "XXXXXXXXXX",
- database = "XXXXXXXXXX",
- uid = "sa",
- pwd = "XXXXXXXXXX")
sql_install.packages(connectionString = connection, pkgs = "glue", verbose = TRUE, scope = "PUBLIC")
2020-08-12 11:50:51.30 Starting package install on SQL server (Driver=SQL Server;Server=XXXXXXXXXX;Database=XXXXXXXXXX;uid=sa;pwd=CC@XXXXXXXXXX;)...
2020-08-12 11:50:51.30 Verifying permissions to install packages on SQL server...
Error: Failed to enumerate package attributes: pkgs=(glue), error='Error in SQL Execution: Error in result_fetch(res@ptr, n, ...): Query needs to be bound before fetching