refresh causes Provider error '80004005'

[MS Newsgroups]

I have an ASP page running on IIS4 on a NT machine accessing a remote
database server on the local network Windows 2000 with /AD and it runs fine.
I have the same exact page on IIS5 same permissions and everything accessing
the same database. The page shows up some times but when I refresh the page
or close it and go back in I get one of two error messages.
--------------------------------------------
Error #1
Provider error '80004005'
Unspecified error
-------------------------------------------
Error #2
[Microsoft][ODBC Microsoft Access Driver] The database has been placed in a
state by an unknown user that prevents it from being opened or locked.
----------------------------------------
I have seen this problem for other users in the google groups but no definte
answer.

--------------------------------------------
Here is the connection string on this server

Set Conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 20
Conn.Open "OppsData"
Set RS = Conn.Execute("{Call CRTMove}")
IIS5 Connecting with Annon Access IUSER_SERVER allow IIS to control password
UNCHECKED and also Intergrated Windows Auth.

all connections close at the end.
all permissions checked and fine.

The only thing I can think of is that this machine also acts as a Sharepoint
Team Services Server.

Please Help : (

[Ray at]

Switch from using an ODBC DSN connection to using an OLEDB connection with a
connection string. Example:

Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\Path\To\Database.mdb;User Id=admin;Password=;"
' * courtesy of [url]www.connectionstrings.com[/url]

Also make sure that you are closing your connection (Conn.Close) and
destroying the object (Set Conn = Nothing) immediately after you no longer
need the connection in your code.

Ray at home


"MS Newsgroups" <mtully@argusinc.com> wrote in message
news:eHkYSyz9DHA.1804@TK2MSFTNGP12.phx.gbl...

> I have an ASP page running on IIS4 on a NT machine accessing a remote
> database server on the local network Windows 2000 with /AD and it runs

fine.

> I have the same exact page on IIS5 same permissions and everything

accessing

> the same database. The page shows up some times but when I refresh the

page

> or close it and go back in I get one of two error messages.
> --------------------------------------------
> Error #1
> Provider error '80004005'
> Unspecified error
> -------------------------------------------
> Error #2
> [Microsoft][ODBC Microsoft Access Driver] The database has been placed in

a

> state by an unknown user that prevents it from being opened or locked.
> ----------------------------------------
> I have seen this problem for other users in the google groups but no

definte

> answer.
>
> --------------------------------------------
> Here is the connection string on this server
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> conn.ConnectionTimeout = 20
> Conn.Open "OppsData"
> Set RS = Conn.Execute("{Call CRTMove}")
> IIS5 Connecting with Annon Access IUSER_SERVER allow IIS to control

password

> UNCHECKED and also Intergrated Windows Auth.
>
> all connections close at the end.
> all permissions checked and fine.
>
> The only thing I can think of is that this machine also acts as a

Sharepoint

> Team Services Server.
>
> Please Help : (
>
>
>