Posts
22
Comments
75
Trackbacks
0
Enabling 32-Bit Applications on IIS7 (also affects 32-bit oledb or odbc drivers) [Solved]

We just bought a new Web Server, after installing Windows 2008 R2(which is a 64bit OS and IIS7), SQL Server Standard 2008 R2 and IBM Client Access for V5R3 with its Dot Net Data Providers, I tried deploying our new project which is fully functional on an IIS6 Based Web Server, I encountered this Error

The 'IBMDA400.DataSource.1' provider is not registered on the local machine.

The 'IBMDA400.DataSource.1' provider is not registered on the local machine.

To remove the doubt that I still lack some Software Pre-Requesites or version conflicts  since I encountered some erros while installing my IBM Client Access, I created a Connection Tester which is Windows App that accepts a connection string as a parameter and verifies if that parameter is valid. After entering the Proper Conn String I tried hitting the button and the Test was Succesful.

App Tester Result => Successful

So now I trimmed my suspects to My Web App and IIS7.

After Googling around I found this post by a Rakki Muthukumar(Microsoft Developer Support Engineer for ASP.NET and IIS7)
http://blogs.msdn.com/b/rakkimk/archive/2007/11/03/iis7-running-32-bit-and-64-bit-asp-net-versions-at-the-same-time-on-different-worker-processes.aspx

So I tried scouting on IIS7's management console and found this little tweak under the Application Pool where my App is a member of.

Enable 32 Bit on IIS 7

After changing this parameter to TRUE Yahoo (although I'm a Google kind of person) the Web App Works .......  

 

posted on Wednesday, December 15, 2010 11:26 AM Print
Comments
Gravatar
# re: Enabling 32-Bit Applications on IIS7 (also affects 32-bit oledb or odbc drivers) [Solved]
Ranathilaka
5/8/2013 7:26 PM
Thank you very much. it's very very good solution

Post Comment

Title *
Name *
Email
Comment *  
Verification
Tag Cloud