Hello
Im trying to test a site using dreamweaver mx, access, and iis and keep getting this error

http 500.100 - internal server error - ASP error Internet Information Services
Microsoft ole db provider for odbc drivers (0x80004005)[microsoft][odbc microsoft access ddriver] could not use '(unknown)'; file already in use


i checked the ms website... nothing
the dreamweaver site is worse

help willl be greatly appreciated
heruk

i dont know what caused this error but it seems t br fixed??????????/
this went on for days butif any1 can explain plz do incase of a relapse

It usually means that either incorrect permissions are set on the server or the incorrect version of MDAC.

permisions seem fime as im on the administrator account
ive tried compact and repair also
what is mdac and how do i get the right one please

Here ya go:
http://www.microsoft.com/downloads/d...displaylang=en

hi i updated my mdac and now i get this error

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

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
ADODB.Fields (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/cosmo_root/TMPvhire3vpbd.asp, line 452


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)

Page:
GET /cosmo_root/TMPvhire3vpbd.asp

Time:
Saturday, September 11, 2004, 8:26:05 AM


More information:
Microsoft Support

mozilla
WTH?


hmm
i duno

heres the code from around line 452

<tr>
<td class="adName"><A HREF="adDetails.asp?<%= MM_keepNone & MM_joinChar(MM_keepNone) & "adID=" & rsAdIndex.Fields.Item("adID").Value %>"><%=(rsAdIndex.Fields.Item("adName").Value)%> </A></td>
<td class="adInfo"><%= FormatCurrency((rsAdIndex.Fields.Item("price").Val ue), 2, -2, -2, -2) %></td>
<td class="adInfo"><%= DoDateTime((rsAdIndex.Fields.Item("datePosted").Va lue), 1, 4105) %></td>
</tr>
<%

i cant figure it out

Hi,
I simply know that this error : "Item cannot be found in the collection corresponding to the requested name or ordinal" comes when you are trying to refer the column which is not present in the recordset.

Kindly re- check the field names again in case if you have missed out some spellings, etc.

Properly close the database so that next request can use the resources properly.

Ordianals not found means there are some spelling mistakes in the variables in rsAdIndex.Fields.Item("").value.

Check this one, it could be it.

http://support.microsoft.com/kb/q278604/