I'm trying to run the below line to pull data from a SQL server and keep getting the below error. I'm new to R and don't understand what the issue is. Using an older version of R, the script works, but with newer versions it doesn't.

con <- dbConnect(odbc(),'BIPS',Server='BIPS',Database='DWPRD1', UID='',PWD='')

Error: nanodbc/nanodbc.cpp:1021: IM004: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Hi, is it related to this? ODBC connection from Windows Db2 client failed with "SQLAllocHandle on SQL_HANDLE_ENV failed" (ibm.com)

This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.