« Previous Next »

• 09-08-2009, 11:42 AM

  hopik Joined on 09-08-2009, 3:10 PM Posts 1

  ASP classic IIS7 specific problem Reply Contact Hello, I have problem, with ASP classic on IIS7 - ASP don't show all data from database. Actually I'm testing Hyper-V VPS Server with Windows Server 2008 32bit, IIS7 and MSSQL Express 2008. I tried to migrate classic ASP website from Windows Server 2003 with IIS6 and MSSQL 2005. Everything works perfect, data in database are ok, but ASP script doesn't return all collumns from table. When i fill data to recordset and from recordset to variables, it is ok for first four columns. But from 5th column i don't get any data to variable and variable is empty. But if i move this variable to first place and read respective column, it is ok, and all other variables are ok too. I have similar problem on other places in website, in other migrated sites too. But when i try to create brand new website and new database, it is same. I seriously don't know, what problem it is, ASP is working, no errors, but i can't get all data from DB. Thank you fro help.

  Tags: IIS7ASPvpswindows server 2008ms sql express 2008

• 09-08-2009, 1:42 PM

  In reply to

  ma_khan Joined on 03-16-2008, 8:26 PM Posts 667

  Re: ASP classic IIS7 specific problem Reply Contact I dont see how this is specific to IIS 7 .. however, have you tried with IIS 7,ASP and MSSQL 2005? IIS would not interfere with something like what you have mentioned... A few things I would try are: Give a local value to a variable and try to print that out in your 5th column.. see if that comes up... Try creating different record set and see if that helps in this scenario.. Check if you have Status and Sub-Status as 200 0 in your IIS logs corresponding to these requests... Hope this helps... Regards, MA Khan http://www.iisworkstation.com “Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”