Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. 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 Professional 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 June 10th, 2006, 04:28 AM
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default asp can't open db when db open by other program

Hii ...

Need anyone help in solving this problem.

I have a program running in VB ... but I'm creating a new idea where my user can update the related information via browser. Since I'm using vb and windows ... so I decide to use asp.

When I try to update, everything work just fine. Until I relize a problem when I open my VB application at the same time (because I use vb to perform action by checking value from database), The ASP won't be able to connect to database with error message

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf34 Thread 0xec8 DBC 0x13e3fac Jet'.
/daily/Default.asp, line 27"

I know well it's not the asp program I write wrongly .. because If the dabase is not opening .. the asp program will just fine and work perfectly. I try also to open the database using access ... but the same problem. So I can justify that the asp can't connect to database when any application is opening the database.

Anyone have any solution to this?


 
Old June 10th, 2006, 07:27 AM
Authorized User
 
Join Date: Jun 2003
Location: Richmond, VA, USA.
Posts: 79
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to erobb Send a message via Yahoo to erobb
Default

You cant have 2 "people" updating the same thing at the same time. It not only applies to db's it applies to any shared application. Consider this.

I have 1 document with "hello world" we both open the same document. You change it to read "HELLO world" & I change it to read "World". How does the application know which version to save? You cant have 2 people editing identical content at the same time.

When you open the db it doesnt know if your going to add delete tables/rows so it locks the db. I may be misunderstanding the question but my experience is once you open the db, especially access, in access the db is locked from the web until you save and exit the db.

Earl
www.jhdesigninc.com

 
Old June 12th, 2006, 05:00 AM
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

so anyone have any solution? because my project using vb to perform some function by taking value from database. At the same time I provide for my client to access via asp by using the advantage to update database value. so basically asp is not performing any function, just updating database where vb getting information to perform some function. So I need both ...

 
Old June 13th, 2006, 06:10 PM
Friend of Wrox
 
Join Date: May 2006
Location: San Diego, CA, USA.
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I don't see any reason that you can't have 2 apps using an Access MDB at the same time. I have many implementations doing this.
I suspect that you do not have your security set up to allow the right access to the LDB file which controls the locking of an mdb file, or for the registry as stated in the error message you are getting.



Woody Z http://www.learntoprogramnow.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Open DB Connections? Ron Howerton ASP.NET 2.0 Professional 6 April 23rd, 2008 12:29 PM
Find open DB Connection again Ron Howerton ASP.NET 2.0 Professional 0 April 23rd, 2008 10:29 AM
Unable to open ProjectTimeTracker DB cancer2006 BOOK: Beginning VB.NET Databases 2 October 24th, 2006 03:53 PM
Can ASP open a DB on user machine? (not on server) cookster Classic ASP Databases 2 October 5th, 2005 10:08 AM
open close db mikeuk PHP Databases 3 July 19th, 2004 11:58 AM





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