Good morning, everyone.
Been running this script for 6+ years now and suddenly it no longer works. Cannot get any help from my IT department, so hoping someone here might have some insights. The issue seems to be around ODBC drivers in RStudio, as I am able to connect to this specific database using tools other than RStudio. Also, I am able to establish connections to other databases within RStudio other than the one that is causing me issues.
Here is the code that was running fine until a week ago:
channel <- odbcDriverConnect(paste("DRIVER={IBM DB2 ODBC DRIVER}",
";Database=database_name",
";Hostname=host_name",
";Port=Port#",
";PROTOCOL=PROTOCOL",
";UID=uID",
";PWD=password123", sep=""))
And here is the error I am receiving:
Warning messages:
1: In odbcDriverConnect(paste("DRIVER={IBM DB2 ODBC DRIVER}", ";Database=database_name", :
[RODBC] ERROR: state IM004, code 0, message [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
2: In odbcDriverConnect(paste("DRIVER={IBM DB2 ODBC DRIVER}", ";Database=database_name", :
ODBC connection failed
Any help would be greatly appreciated. I am a complete novice when it comes to IT-related issues.