Hi.
I have a big problem with a database.
Background. I´m developing a several sites on my server. Everyone accept one is working just fine.

The one that dont work is the newest one. The problem is the database. It always locks. And i cant delete the .ldb file. It says that it´s in use by another program or session. This comes up even after i restart the IIS (xp pro).
This does that the database wont be writable and i vant test on my server. On the hotell it works just fine.

There is another problem to. All pages accept the default.asp is running. When i try to connect to default it hangs. It simply wont come up. Samt thing here. When i upload to the remote server it works.

I guess it has to be some problem with the write permission. But i cant figure it out.

Any suggestion.

regards
//Stellan

Hi Stellan,

I would of thought permissions would be the problem too. Forgive me if you've already tried but the write permissions need to be set for the folder where the database lives for the web server account as it's the web server that is doing the read/write.

Digga

Sharing Knowledge Saves Valuable Time!!!

I know about the permissions.
I formatted the whole computer yesterday. And even after that it´s the same problem.
I figured something out after i reinstalled the Dreamweaver MX. It´s the MX that locking the database. I can run everything, but when i starting the program i locks down and i cant reach it from the localhost.

//Stellan

-------------------------------
Reptiles is all i lives for!!!

These suggestions might seem obvious, but that are the first things I thought of:

1) To delete a .mdb file you must delete any files that have been created to associate it with a DSN connection. It is possible this is not the case for you.

2) Rather obvious I know, but do all your pages successfully close all database connections they make, this may cause it to hang?

3) Have you tried transferring all the database content to a new database file, and renaming your connection file to use the new version. This may solve the problem

I hope these help.
Matthew Maguire