database handling weeeeee!

[lousylife]

hello sir, im getting this error! im newbie in handling records in asp!! this is:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.


thnx a lot!!

[markrawlingson]

2 questions:

1) Are you trying to open 2 data connections to the same database?
2) Is the database open on the server which is trying to serve the web page?

These can both cause that issue if it's an mdb database which it sounds like it is. Also, show your code and highlight the line which is throwing the error.

Sincerely,
Mark

[lousylife]

-=function.asp=-
<%
Dim adocon,adorst, strDbPath
strDbPath = "mboard.mdb"

Sub ConnectDB()
Set adocon = Server.CreateObject("ADODB.Connection")
adocon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(strDbPath)
End Sub

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/functions.asp, line 7

[DrBunchman]

Hi LousyLife,

This is probably a permissions problem. Are you using authentication or the anonymous account for this website (the default is anonymous)?

Can you go to the folder where your database is stored (the .mdb file), right click on the folder and check the security tab.

• If you're using authentication then check that you or a group that you are in is listed with read/write access.
• If you're using the anonymous account then check that the account (IUSR_<ComputerName>) is listed with read/write access.

If you're not sure which method of authentication you are using or what your anonymous account name is then check the settings in the IIS console.

Let me know if this helps or you need any further info,

Dr B

[lousylife]

Yey!!

I Got It!! The Data Are Already Stored!!

Its Just The Authentication!!

Thnx For The Help!! =p

[markrawlingson]

[Edited]
Ignore.. Responded before i posted :P