Hi Everyone,
I have deep experience with Windows, PowerShell, UNIX, and SQL Server, but am newer to R. I’m trying to install the data quality dashboard and part of it involves setting up a connection to SQL Server from R and running a test. Below is a script and the error I’m getting. Can someone please suggest where I should start looking to fix this?
R code:
Sys.setenv(“PATH_TO_AUTH_DLL” = “C:/Users/LASCHE/Documents/OMOP/Jar”)
Sys.setenv(“DATABASECONNECTOR_JAR_FOLDER” = “C:/Users/LASCHE/Documents/OMOP/Jar”)
conn ← connect(dbms = “sql server”, server = “caboodlesql62d", pathToDriver = “C:/Users/LASCHE/Documents/OMOP/Jar”)
dbGetQuery(conn, "SELECT COUNT() FROM OMOP.cdm.concept”)
disconnect(conn)
Here is the error I’m getting:
Connecting using SQL Server driver
- Using Windows integrated security
Looking for authentication DLL in path specified in PATH_TO_AUTH_DLL: C:/Users/LASCHE/Documents/OMOP/Jar
Error in .jcall(“RJavaTools”, “Ljava/lang/Object;”, “invokeMethod”, cl, :
java.io.IOException: Failed to get field handle to set library path