2. ASPRunnerPro General questions
  3. Error -2147467259
This topic is locked

Error -2147467259

 		8/24/2005 10:21:13 PM
ASPRunnerPro General questions
S
 shahram author

Hi

I made asp pages that read the data from an ODBC DSN database

everything went fine, the pages were functional,

But when the database was accessed by another program, i got the file is already in use (though i don't want to care about that since i want to open the database in asp pages for readonly use)
Ok, I close any other access to the database, and here is what i get after that
Technical information

Error number -2147467259

Error description Unspecified error

URL /_cards/Accounts_list.asp

SQL query select [UserName], [Password], [TotalMinutes], [TotalMinutes]-[MinutesUsed] as [RemainingTime], [CreationDate], [ValidSinceDate], [ValidToDate], [ValidFromTime], [ValidToTime], [ChargingRate], [FirstName], [LastName] From [Accounts] where (type=0)
and this error continues unless I restart the computer, then again ASP pages will be functional
I have Windows 2003 Server, with the latest updates
Please let me know what is the problem, I have to plane an action soon for this,

and bythe way i am evaluating ur product for purchase and use in my website that is hosted in this windows 2003 server
Sergey Kornilov admin 8/25/2005

This appears to be locks issue. Both IIS and MS Access attempt to lock a database file even if you do not plan to modify data or database structure. Sometimes it messes up IIS and you need to restart it by typing iisreset in command line.
I won't recommend to access your database through ASP while it's open in MS Access.
S
 		shahram author 8/25/2005

The Database that i am using is actually maintained by another software, and the whole point of ASP pages would be to make the dynamic data available online,
I guess this would be an issue that i wouldn't be able to do anything about,

however i am thinking of making a database and query the data from the first datbase into it,
this way when the first databse is accessed or changed, it wouldn't influence the 2nd database, and i should be able to use the 2nd database without any problem.
this is just theoretically speaking, i will have to work on it to see if it works
S
 		shahram author 8/25/2005

Ok
I have been working on this for half an hour and all i got was failure,
I tried both table linking and database query (eg. SELECT Accounts.UserName, Accounts.Password, Accounts.TotalMinutes, Accounts.MinutesUsed, Accounts.CreationDate, Accounts.ValidSinceDate, Accounts.ValidToDate, Accounts.FirstName, Accounts.LastName

FROM [C:\main.mdb].Accounts;

) in a new file

but some how the scripts find their way back to main.mdb and the same error, file being already in use,
I even tried Query in Excel database, but for that there is no automatic refreshing of the queried data.
Do u possibly know a way i can use to access my database although it is open in another program,(eg. getting the data out somehow into somewhere else that would not be in use) or there is no way for me to use this <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=5661&image=1&table=forumreplies' class='bbcemoticon' alt='<<' />
Sergey Kornilov admin 8/29/2005

Probably you can contact another program manufacturer pointing them to this issue. Knowing how their application works they may provide a reasonable workaround.
Btw, what is the application that keeps MS Access database file open?