homepage Welcome to WebmasterWorld Guest from 54.205.241.107
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
ASP, Access & LDB Locked File
Server hangs for ever
Chris_H

5+ Year Member



 
Msg#: 1 posted 8:42 pm on Aug 30, 2005 (gmt 0)

I'm having problems with our new ISP, who can't seem to resolve a hanged server when my ASP page tries to connect to an Access database.

An LDB locked file is produced by Access on the server once the page connects to the database (using a Jet DSNless connection), which didn't happen with our old ISP. This locks everyone else out, and the server hangs, making our site inaccessible:

conn.Open "Data Source=" & Server.Mappath("/path-to-data.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"

I've pulled out clumps of hair over the last 72 hours trying to sort this out. If anyone can help me to keep the remaining strands of hair, I'd be very grateful.

Chris

 

Eltiti

10+ Year Member



 
Msg#: 1 posted 9:28 pm on Aug 30, 2005 (gmt 0)

Does the Internet Guest Account (IUSR_Something) have appropriate rights to the directory containing the database?

Chris_H

5+ Year Member



 
Msg#: 1 posted 9:44 pm on Aug 30, 2005 (gmt 0)

CHMOD is 777 in that directory. I assume this is the right settings?

txbakers

WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 1 posted 12:29 am on Aug 31, 2005 (gmt 0)

Don't use access for web work. Access is fine for a desktop app, but not the constant open and close of the web.

use mySql or mssql instead.

Eltiti

10+ Year Member



 
Msg#: 1 posted 1:20 pm on Aug 31, 2005 (gmt 0)

Don't use access for web work

Actually, in my experience, using Access is just fine for light to medium loads... But when you start getting a heavy load, you should certainly consider something like MS SQL Server!

aspdaddy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1 posted 3:09 pm on Aug 31, 2005 (gmt 0)

Its normal for the .ldb file to be locked when the database is open.

Sounds like the conenction isnt being released properly - are you closing the recordset before releasing it? What error message do you get?

spiv

5+ Year Member



 
Msg#: 1 posted 9:10 pm on Sep 11, 2005 (gmt 0)

Access has many problems in a hosted environment and the locked file syndrome is one of the more common.

Because Microsoft MSDE is free for both hosting companies and end-users, there really is no reason to not use a real database (MSDE) instead of the file-based MS Access.

If your hosting company can't support MSDE, and you don't want to upgrade to a full SQL Server account, then go somewhere else.

All medium to large (but not small) Microsoft technology hosting companies support database hosting as it is the foundation for ASP, ASP.NET, SharePoint and most of the Microsoft Server stack.

joker197cinque

10+ Year Member



 
Msg#: 1 posted 2:28 pm on Sep 16, 2005 (gmt 0)

Access, in my ISP environment, perfectly support concurrent connections...

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved