database connection

[olegflute]

I have the following problem with ASP.
We had a file in folder c:\temp\file.mdb
We've created SystemDSN link to it and called it accessDSN.
The system was working fine.
After we've tested it a number of times, we've moved the database to the

http://wwwroot

folder and updated the SystemDSN path. The system stoped working with an error (0x80004005).
Now, even if we move it back, we still can't access the DB. The wierdest thing is that we can access the DB once every two minutes (retrieve data) after that the DB is inaccessable again.

 

[vbkris]

does the error give u any other description?

Known is handfull, Unknown is worldfull

 

[mihalych]

it actually gives two types of error, different every time the website accesses the database. One of them - Unspecified error (0x80004005). Another one - without error number but just saying that - the database is being accessed by another source.

 

[shaddow]

I had same error.

First i've tried to change the Conection Pooling Timeout from the DSN or from the Driver. That worked but the minimum timeout does not fix this 100%.

I used to manualy make directories in the

http://wwwroot

but i didnt created the application on the virtual directory properties (IIS console)
and i've noticed is that if i have an Application all is ok.

Making it as an application the script should be able to chose Application protection. I dont knw if that it is actualy the problem, havent tested yet, but i knw without making an Application there you will get that errors.

I suspect that you dont have any Application on the properties of your Virtual Directory.


________
George, M