asp.net Connection issue

Question

Hi All I am trying to connect my asp.net MVC application into DB2.when I am trying to open connection I am getting the below error. ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed please suggest me how to solve this error . Thanks Srujana

Lakshmanan Sethu · Answer

Hi Srujana Issue : While you are using the Add Generated Item Wizard  an exception occurs: IM004 : [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed. Generated when the ODBC driver manager is unable to create an instance to the required driver the driver of the database. Resolution Add the PATH to the ODBC driver client DLLs. Ref :http://msdn.microsoft.com/en-us/library/aa577813(v=bts.20).aspx

Shweta Lodha · Answer

Please have a look at below link as similar issue is discussed here: http://scn.sap.com/thread/1599112