Hi,
I am using visual studio 2005 for my web application and my back end is SQL Server. our requirement is to get the details from DB2 and we need to display in our web application and our web server is windows server 2003 and the IIS version is 6.0
we able to connect to IBM DB2 successfully after deployment.
Our new requirement is, we need to deploy the same code in windows server 2008 R2 and IIS version is 7. Also, we have converted our application from VS 2005 to VS 2005.
In this case, we able to connect the IBM DB2 in debug mode. But, when we tried to publish the code in IIS, we are receiving the below error.
Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
we tried to add db2admin and db2user in local policy as well. but we unable to connect.
Also, we have configured in both 32 bit and 64 bit ODBC driver as well.
Some one saying there may some issues in ODBC driver connectivity and some other saying there may be a issue with IIS.
Can you please anyone help me to resolve this issue.
Regards,
Ram N