> 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 restart CF so that this
> client does not need to phone in and tell me when they are
> uploading a new database?
Answer:
Sure there is. You could write a batch file to stop and restart the CF
server, then call that batch file from CF using CFEXECUTE. Alternatively,
you could write an ASP script (assuming you're running IIS) that will do the
same thing. Finally, there used to be a web-based interface for this; it was
removed from the latest version of CF for security reasons, but you could
conceivably get that and put it on your server.
Better answer:
Instead of cycling the CF service, you might examine other alternatives. For
example, you might disable database connections to the specific database, or
break the existing database connection (there's a minimally-documented
function, I believe it's CFUSION_DBCONNECTION_FLUSH() or something like
that, which is described on the Allaire knowledge base).
Possibly, an even better answer:
For some reason, I found this line amusing:
"This database is Access97 and contains mission critical data."
While I understand why a lot of people use Access, that doesn't mean I
condone it. If you're running SQL Server, for example, you could build all
kinds of batch processes to transfer data through the internet from one
database to another. It may be the case that you're better off using Access
in this case, but maybe not.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
