Problem running asp with database connection on windows xp pro SP1a

Hi guys, just trying my luck to see if any one of you encounter this problem lately. I have currently installed windows XP Pro SP1a (OEM version). The installation CD is comes with my new PC. Previously, I used PWS installed on windows 98. I have an asp application running in PWS, and all things were fine.
However, when I transfer all the asp files into the new PC, the ASP application just refuse to work for its new "master". I am sure that the transfer is successfully done. The asp engine seems working fine as it can display all dynamic messages (response.write "blah blah blah", but when I start to run a script that has a database connection, it just refuse to work. No error message is display, browser seems working very hard to display content, but keep failing each time. What could have been the problem? Any suggestion is greatly appreciated. BTW, I am using access database and I use system dsn to point to the database(.mdb file), tried using dsn-less connection, but also fail.

Help help!

regards,

Lonetree

have you tried a simple page that connects to the db (via the DSN) and return something from it?

You should look at the rights you have given, if you share your map and then it works. Then your problem is with your rights

hi guys, thanks very much for the quicl response.

wdglide> I have tried that, it doesn't come to any result. As long as there is a db connection in the asp code, it just won't work. However, is I just do a response.write, it works fine. Could it be XP pro sp1a that is making the trouble? the MDAC used in this version of os ir MDAC 2.7 by the way.

Antonio123> which rights are you toking about? the db rights or IIS rights?

Anyone out there has anymore suggestion? This problem sits on me for 3 days already and I still can't solve it, the reason being unable to determine where when wrong, the coding is definitely correct as there isn't any change to it, i merely migrate over to the new web server.

Thanks.

Regards,
Lonetree

I had the same problem you did when using IIS. It took a while to find an answer but it involved the permissions for IIS. Here's a link to the solution I found on Microsoft's website.

support.microsoft.com/default.aspx?scid=kb;EN-US;271071

thanks gernhart11, for the reply and advice, my problem seems weird, the asp pages do not display and browser freezes whenever there is an database connection to the access database, I have tried all mean like DSN-Less connection script, System DSN, file DSN, and also OLEDB, but seems all failed, however, if the script is pure asp without any database connection string, then all works fine. Weird isn't it?

regards,

Lonetree

That sounds exactly like what happened to me. Give that link a try. I hope that it works for you.