Disconnecting from a database

[jedel]

Hi all,

This is kind of a strange question seeing as most of the people in this forum seem to want to connect to a database.

I primarily build with ASP and from time to time, I need to download the database(s) as part of my development so as to ensure that the contents of the database is not lost when I upload any upgrades.

My problem is after I develop some code in a page that links to the database, Dreamweaver establishes a local ".ldb" file, as it should. when I close the page however the ".ldb" file remains open and I cannot download the database until it goes.

The real issue is the only way I have found to get rid of the ".ldb" file is to close dreamweaver and re-open it.

So my questions is twofold, 1.) why does the ".ldb" file remain open and 2.) how can close it with having to close down Dreamweaver.

Some details

I run Dreamweaver CS3, Access 2003, and my testing server is the same as the remote (in case that is the issue, although I'm hesitant to load IIS until I'm sure that it is).

Appreciate your help

Dean

-------------------------------------------------------------
"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."

 

[lebisol]

Issue is in:"and my testing server is the same as the remote "
it is a lock file and is there beacuse you have connection open to DB and most likely database expreienced some sort of unproper disconnect (eg. copy-paste-overwrite of DB while you have a session through DW open to it).

"although I'm hesitant to load IIS "
Don't be, it will run on your local machine and you can set the service to start manually if you are worried about IIS blasting all the time on your dev. machine.
All the best!

:-------------------------------------:
Do the DW »|MostarNetworks|

 

[jedel]

OK,

I Installed IIS, but I can't seem to get the pages to load to the testing server. It keeps saying it can't find the files.

Do you know of a site that can step me through setting it up?

-------------------------------------------------------------
"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."

 

[jedel]

OK, Disregard my last post, I found the problem.

However, Even though I still have the testing server set up for my local site, I still cannot remove the lockfile. Even after I switch off the site from IIS, close all pages and files that may be connected to the database.

The only file left open is DW. And yes, I still have to close down DW to reset the LDB file.

What else do I have to do?

-------------------------------------------------------------
"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."

 

[lebisol]

strange...check the odbc session timeout or even better use DSN-less connection.

:-------------------------------------:
Do the DW »|MostarNetworks|