SQLAllocHandle error with newer SQL Server (and Client) drivers

HCL Domino Domino Forum
1

With an 8.5.2 client:

Dim lcConn As New LCConnection(“ODBC2”)

With lcConn

.connectorName = “ODBC2”

.server = “An ODBC Database”

.metadata = “TableName”

.connect

end with

If the ODBC connection “An ODBC Database” is defined with SQL Server Native Client 10.0 (v2009.100.1617.00), the .connect always returns “[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV Failed” The same code with SQL Native Client (v2005.90.2047.00) works.