« Previous Next »

• 10-28-2009, 2:09 PM

  owend Joined on 10-28-2009, 6:06 PM Posts 1

  enabled32BitAppOnWin64 fails to work with SQL Server 2005 Reply Contact We're running a Classic ASP site on SQL server 2005.  We've moved to a 64-bit Win 2008. The site works fine when we leave IIS inn 64-bit mode, but as soon as we switch it to Enable 32-Bit applications (in order to get a legacy dll working (MDHASH.dll), the site fails to connect to the SQL server 2005 db and we get the error number -2147467259  We're tried everything we can think of. There's nothing in any log (event or IIS). We've tried numerious permission things (DB permisions and app pool authentication users etc) any ideas - please help!

• 10-28-2009, 7:53 PM

  In reply to

  lextm Joined on 10-22-2008, 4:18 AM Shanghai, PRC Posts 1,423

  Re: enabled32BitAppOnWin64 fails to work with SQL Server 2005 Reply Contact So this is an ASP application who makes use of a 32 bit dll and connects to MS SQL. You'd better tell when did the error happen. Did it happen only if the page tried to access MS SQL? Or a very simple ASP page who doesn't use MS SQL experienced the same issue. Also you can check if MS SQL native client is installed properly, http://msdn.microsoft.com/en-us/library/ms131334%28SQL.90%29.aspx If you are not sure how to check that, you can post to our SQL Server forums, http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/ Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.