This week's book giveaway is in the Artificial Intelligence forum.
We're giving away four copies of Pragmatic AI and have Noah Gift on-line!
See this thread for details.
Win a copy of Pragmatic AI this week in the Artificial Intelligence forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
  • Carey Brown
  • Tim Holloway
  • Joe Ess

Cold Fusion Database Closing  RSS feed

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?
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!