Strange problem !

My site works just fine running on w2k or w98+pws, but running om my XP it seems to lock the odbc source, if I have patient and wait for app 30 secs It works with the next page.
Is there some special config in odbc for winXP ?

All hints and tips are welcome....

**********
Patric

Firstly, check your NTFS permissions. IUSR_<machinename> should have change permissions on the folder that the database is in, and all files within that folder.

Secondly, make sure you call objConnection.Close in all your ASP pages.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com

NTFS is Ok it works fine if i wait 30secs between klicks.
I must check all pages there shuld be a close at the end of everyone but I need to check it one more time...
Thanx

I have a conn.close() at the end of every file, is that one inproper to use with XP ?

I have run into similar problems and found that restarting the server(win xp pro w/ iis) fixed the problem. It starts for me when there is an error and it doesn't execute the close() method. The connection remains opened or 'being used' by another user and won't allow an update.

Can you please post a sample webpage that you are using?

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com

I added a Try... Catch... End Try and it now closes it if an exception occurs. (asp.net)