RE: Access uploads and Remote CF restart

2000-09-07 Thread lsellers
> net stop "Cold Fusion Application Server" > net stop "Cold Fusion Executive" > net stop "Cold Fusion RDS" > net start "Cold Fusion Application Server" > net start "Cold Fusion Executive" > net start "Cold Fusion RDS" I've had a shortcut on my desktop to a bat like this for ages. Very handy. /-)

RE: Access uploads and Remote CF restart

2000-09-07 Thread Mark Warrick
You don't have to re-start the server if you do two things: first, make sure the "maintain database connections" checkbox for that ODBC datasource (in the CF Administrator) is unchecked. And second, use the following function to "flush" the connection, thus allowing your user to upload the new

Re: Access uploads and Remote CF restart

2000-09-07 Thread William H. Bowen
This is a cryptographically signed message in MIME format. --ms2D1D0D6B0A76E7482821ABB7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > For some reason, I found this line amusing: > > "This database is Access97 and contains mission critical data." Yeah,

Re: Access uploads and Remote CF restart

2000-09-07 Thread William H. Bowen
I was having a problem with .ldb files being created when CF was accessing the databases. It essentially took restarting the CF Server to disconnect. I discovered today that Maintain Database Connections was checked in the Edit ODBC Admin page (the only one of 7 client databases where this has

RE: Access uploads and Remote CF restart

2000-09-07 Thread Dave Watts
> Problem: > I have a client that must upload a database to my server. This > database is Access97 and contains mission critical data. (This > database is output from a larger, more cumbersome database that > the client keeps at his location) > > Question: > Is there a way to remotely stop and re

RE: Access uploads and Remote CF restart

2000-09-07 Thread Pete Freitag
You could easily do this, but you probably need to write it in something other than CF. Assuming you are running NT the following batch script will restart CF... net stop "Cold Fusion Application Server" net stop "Cold Fusion Executive" net stop "Cold Fusion RDS" net start "Cold Fusion Applicatio

RE: Access uploads and Remote CF restart

2000-09-07 Thread Kevin Langevin
Why do they need to restart your server to upload the DB? -Kev > -Original Message- > From: William H. Bowen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 07, 2000 12:43 PM > To: [EMAIL PROTECTED] > Subject: Access uploads and Remote CF restart > > > This is a cryptographicall