Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 15th, 2003, 03:18 AM
Registered User
 
Join Date: Sep 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Locks on my access db in win xp

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
 
Old December 15th, 2003, 04:42 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old December 15th, 2003, 04:56 AM
Registered User
 
Join Date: Sep 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old December 15th, 2003, 05:18 AM
Registered User
 
Join Date: Sep 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have a conn.close() at the end of every file, is that one inproper to use with XP ?
 
Old December 16th, 2003, 02:13 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,110
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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.

 
Old December 17th, 2003, 02:58 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com
 
Old December 17th, 2003, 09:31 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,110
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
win xp and web server Sus Beginning PHP 5 January 8th, 2006 10:40 AM
help:: Prob with DCOM in Win XP sachin_dm C++ Programming 2 March 23rd, 2005 01:28 AM
Installing PHP on Win XP how to ? tandhy BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 April 6th, 2004 12:51 PM
Win '98 vs. Win XP rgerald Access VBA 0 February 19th, 2004 12:30 PM
Win xp Pro + IIS morpheus Access 2 November 21st, 2003 10:19 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.