Using PWS and Access Database

[tycaine]

Hi, new problem...

Now, I'm using a DSN-less connection to an Access Database, connecting with ASP-ADO code (code I KNOW works as I'm using it in another application), and yet whenever I try and run it the PWS effectively locks up and shut down, the only thing I can do is restart the computer/server to get PWS to work again...

Anyone help?

 

[FesterSXS]

are you getting any errors reported or does the browser just hang?


Tony

http://www.SpiraxSarco.com

 

[tycaine]

No errors, the browser just seems to hang, and then from that moment I can't get into the site, every time I bring the site back up the browser justs sits there again...

Even if I kill PWS and restart it, it takes a complete computer restart to get it working again...

Bringing up normal ASP pages works fine, but the moment a page with a DB call comes up, it dies...

Thinking about it, I did get one error come up once, because I had the wrong path to the DB, so it came up with an ASP error saying it couldn't find the file... Corrected that, but now this happens...

Like I mentioned, I KNOW this code works as I'm using it else where, so the only thing I can think of is something specific with this 'server', perhaps a permissions or something?

Any help would be greatly appreciated...

T.C.

 

[tycaine]

Ok, fixed it myself...

It wasn't that the browser was 'hanging' per se, it was that the computer I'm using as a development server is so underpowered it was just churning through the database (I was using a full, production database of over 3000 lines, so it was own fault) and taking it's sweet time in coming up with anything...

Put a cut-down 'test' database of only 10-14 lines, and everything comes up as it should...

HOWEVER, it DOES hang now if you try to do two queries to the database, but I think that's more of a performance issue on the part of the crap computer/server, rather than a true error...

Well, it's an old Win98, 333mhz and only 64mb ram, so what did I expect? And the only reason I'm using that is because it HAS PWS on it, whereas my new, flashy, state of the art laptop which I use for developing, is WinXP Home, which leaves me out in the cold on the PWS/IIS front...

Can't say I like Microsoft because of that, but anyway...

I've rambled enough, thanks for listening, and if anyone gets a similar error, check the size of the DB first and try running with a cut down one...

Later,
T.C.