• Post Reply Bookmark Topic Watch Topic
  • New Topic

Cold Fusion Database Closing  RSS feed

 
Darren Gates
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello, I'm new to Cold Fusion. When I run a cfquery, the Access database on a remote server is opened, and a .ldb file is created in the same directory as my .mdb file. If I try to re-upload the .mdb file, the server doesn't allow this because the database is open (indicated by the presence of the .ldb file). How do I close the database remotely (e.g. via a Cold Fusion command) so that I can overwrite the .mdb file?
 
Terence Doyle
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I'm no CF hot shot myself but as far as I know if you open and close a <CFQUERY> tag the database closes automatically once the page has been processed properly.
Now, what procedures are on the page? are there any infinite loops that might have set the server off on a search for something?
Have you set the page timeout for each of your ODBC data sources? - the standard value is 600.

I hope this helps

Terry
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!