[R] RODBC package issues with DB2 ODBC drivers and Windows R 4.2.0

mjrizzo m@iii@g oii y@hoo@com mjrizzo m@iii@g oii y@hoo@com
Thu Jul 7 15:54:47 CEST 2022


I have been looking for help with an issue I am having with the RODBC package .  I recently upgraded to R 4.2.0 from R 4.1.1 in Windows 10 Enterprise Build 19044.  I use the RODBC package along with the IBM DB2 ODBC driver version 11.01.331.368 to access DB2 databases.  Using the RODBC package in 4.1.1, everything works as it should.  I am able to connect to the DB2 databases without any problems.  
After upgrading to R 4.2.0 and upgrading the RODBC package, I haven't been able to connect at all, and I receive the following error message: "ERROR: state IM004, code 0, message [Microsoft] [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed".  
When I searched the web for anyone else experiencing the same issue, there were a few mentions of the same problem but did not mention any remedies.  Has anyone else experienced any issues with using the DB2 ODBC driver in R 4.2.0?  I downgraded back to R 4.1.1 and everything worked fine once again.
Any help would be appreciated.
	[[alternative HTML version deleted]]

More information about the R-help mailing list