[KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Bakken, Kory

I need to schedule maintenance window each night to perform automated
repairs and compaction on my main database.  I know how to do that, but in
order to repair and compact the database, I need to disconnect the
datasource that is hitting against it for that period of time.  Does anybody
know if it is possible to schedule updates to a datasource (i.e.-disconnect
and reconnect)?

Kory Bakken
IT Enterprise Release Management
Tools / Process
desk:  816.559.4801
pcs:816.305.5890

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Ellis, Randy

We have a scheduled BAT file running on our web server each night that
updates a database file.  The unfortunate thing is we actually down the
website to perform the updates and then bring the website back up.

The BAT file looks look this:
net stop WORLD WIDE WEB PUBLISHING SERVICE
C:\Update.exe
net start WORLD WIDE WEB PUBLISHING SERVICE

Randy

-Original Message-
From: Bakken, Kory [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:09 AM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Scheduled Datasource Updating


I need to schedule maintenance window each night to perform automated
repairs and compaction on my main database.  I know how to do that, but in
order to repair and compact the database, I need to disconnect the
datasource that is hitting against it for that period of time.  Does anybody
know if it is possible to schedule updates to a datasource (i.e.-disconnect
and reconnect)?

Kory Bakken
IT Enterprise Release Management
Tools / Process
desk:  816.559.4801
pcs:816.305.5890

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Dunwiddie, Bruce

am I crazy, or this a rediculous solution in the age of providing worldwide
services in all timezones? and I can only assume that this maintenance is
necessary because you're using an access db?

-Original Message-
From: Ellis, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


We have a scheduled BAT file running on our web server each night that
updates a database file.  The unfortunate thing is we actually down the
website to perform the updates and then bring the website back up.

The BAT file looks look this:
net stop WORLD WIDE WEB PUBLISHING SERVICE
C:\Update.exe
net start WORLD WIDE WEB PUBLISHING SERVICE

Randy

-Original Message-
From: Bakken, Kory [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:09 AM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Scheduled Datasource Updating


I need to schedule maintenance window each night to perform automated
repairs and compaction on my main database.  I know how to do that, but in
order to repair and compact the database, I need to disconnect the
datasource that is hitting against it for that period of time.  Does anybody
know if it is possible to schedule updates to a datasource (i.e.-disconnect
and reconnect)?

Kory Bakken
IT Enterprise Release Management
Tools / Process
desk:  816.559.4801
pcs:816.305.5890

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Bakken, Kory

Bruce:

Yes.  I inherited an Access DB that we are running a large intranet
application against.  It works fine for the 200+ users that use it, and it
is actually faster than most of our counterparts that use an Oracle DB.
However, it requires frequent maintenance.  I know that no user will be
using the application between midnight and 2am CST (since all users reside
the same time zone), so no this is not a ridiculous solution, and no I
am not worried about downtime.  

But thank you for the remarks (questions?). I hope I am not off-base when I
say this, but in the future, if your reply is not helpful or positive,
please refrain from making any comments at all.  

I just need to know if it is possible to schedule an update on a CF
datasource using CF Administrator.

Kory Bakken

-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 12:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


am I crazy, or this a rediculous solution in the age of providing worldwide
services in all timezones? and I can only assume that this maintenance is
necessary because you're using an access db?

-Original Message-
From: Ellis, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


We have a scheduled BAT file running on our web server each night that
updates a database file.  The unfortunate thing is we actually down the
website to perform the updates and then bring the website back up.

The BAT file looks look this:
net stop WORLD WIDE WEB PUBLISHING SERVICE
C:\Update.exe
net start WORLD WIDE WEB PUBLISHING SERVICE

Randy

-Original Message-
From: Bakken, Kory [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:09 AM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Scheduled Datasource Updating


I need to schedule maintenance window each night to perform automated
repairs and compaction on my main database.  I know how to do that, but in
order to repair and compact the database, I need to disconnect the
datasource that is hitting against it for that period of time.  Does anybody
know if it is possible to schedule updates to a datasource (i.e.-disconnect
and reconnect)?

Kory Bakken
IT Enterprise Release Management
Tools / Process
desk:  816.559.4801
pcs:816.305.5890

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Mark Kirkbride

Are you using NT backup?   I think Backup Exec will back up a SQL Server on the fly, 
but NT backup won't.

Mark Kirkbride
Information System Specialist
FBD Consulting, Inc.
(913) 319-8836
[EMAIL PROTECTED]


-Original Message-
From:   Ryan Hartwich [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, December 13, 2001 1:00 PM
To: [EMAIL PROTECTED]
Subject:RE: [KCFusion] Scheduled Datasource Updating

Keith,

You can't backup your MS SQL 7 DB while it is running?  That's
strangeI know that you might have problems with direct tape backups
to open files, but SQL 7 has a 'backup' and 'restore' function in
Enterprise Manager.  I use it frequently on both our development and
production machines.  It takes the database and dumps it, with log files
I believe to a file, tape, etc. of your choice.  The backup routine on a
quad p3/550 takes about 10 seconds on a 50meg db (25 filled) and aobut
2? Minutes on a 1gig db with 550megs of data.  Once the file is created,
I usually zip the file and ftp it down to my local machines for backup
on CD.  Our hosting provider actually runs nightly backups, but since
I'm not impressed with UUNET's service, I periodically back it up
myself.

Ryan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Keith Purtell
Sent: Thursday, December 13, 2001 12:20 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Scheduled Datasource Updating


Actually, we do something similar inside a backup procedure, because we
can't back up our database while MSSQL7 is running.

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]




RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Dunwiddie, Bruce

By definition in quite a few languages that I know of, sentences ending in a
? are deamed questions. your answer and the other couple back in this
thread are actually what I was looking for. I'm so sorry that people in this
country are allowed to ask questions instead of just answer the question you
want answered. Not necessarily offbase, but it isn't anyone else's fault
that you inherited a poor design for the web, and you should look in to the
control issues you obviously have.

-Original Message-
From: Bakken, Kory [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 1:01 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


Bruce:

Yes.  I inherited an Access DB that we are running a large intranet
application against.  It works fine for the 200+ users that use it, and it
is actually faster than most of our counterparts that use an Oracle DB.
However, it requires frequent maintenance.  I know that no user will be
using the application between midnight and 2am CST (since all users reside
the same time zone), so no this is not a ridiculous solution, and no I
am not worried about downtime.  

But thank you for the remarks (questions?). I hope I am not off-base when I
say this, but in the future, if your reply is not helpful or positive,
please refrain from making any comments at all.  

I just need to know if it is possible to schedule an update on a CF
datasource using CF Administrator.

Kory Bakken

-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 12:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


am I crazy, or this a rediculous solution in the age of providing worldwide
services in all timezones? and I can only assume that this maintenance is
necessary because you're using an access db?

-Original Message-
From: Ellis, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


We have a scheduled BAT file running on our web server each night that
updates a database file.  The unfortunate thing is we actually down the
website to perform the updates and then bring the website back up.

The BAT file looks look this:
net stop WORLD WIDE WEB PUBLISHING SERVICE
C:\Update.exe
net start WORLD WIDE WEB PUBLISHING SERVICE

Randy

-Original Message-
From: Bakken, Kory [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:09 AM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Scheduled Datasource Updating


I need to schedule maintenance window each night to perform automated
repairs and compaction on my main database.  I know how to do that, but in
order to repair and compact the database, I need to disconnect the
datasource that is hitting against it for that period of time.  Does anybody
know if it is possible to schedule updates to a datasource (i.e.-disconnect
and reconnect)?

Kory Bakken
IT Enterprise Release Management
Tools / Process
desk:  816.559.4801
pcs:816.305.5890

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe 

RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Keith Purtell

I confess, I was only repeating what our in-house MSSQL expert told me.
While I watched, he went into Enterprise Manager and then into a dialog
window (exact name forgotten) dedicated to backups. He added a short line of
code that turns off the service to accommodate the backup, then turns the
service back on once the backup completes. Sorry if this sounds vague, but
I've only seen it one time and haven't had time to go explore it any more.
This particular machine uses a competing product for backups, although we're
planning to remove it and install Backup Exec instead. We abandoned NT
Backup long ago. 

Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email:  [EMAIL PROTECTED]

CONFIDENTIALITY NOTICE: This email message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Mark Kirkbride
Sent: Thursday, December 13, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Scheduled Datasource Updating


Are you using NT backup?   I think Backup Exec will back up a SQL Server on
the fly, but NT backup won't.

Mark Kirkbride
Information System Specialist
FBD Consulting, Inc.
(913) 319-8836
[EMAIL PROTECTED]


-Original Message-
From:   Ryan Hartwich [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, December 13, 2001 1:00 PM
To: [EMAIL PROTECTED]
Subject:RE: [KCFusion] Scheduled Datasource Updating

Keith,

You can't backup your MS SQL 7 DB while it is running?  That's
strangeI know that you might have problems with direct tape
backups
to open files, but SQL 7 has a 'backup' and 'restore' function in
Enterprise Manager.  I use it frequently on both our development and
production machines.  It takes the database and dumps it, with log
files
I believe to a file, tape, etc. of your choice.  The backup routine
on a
quad p3/550 takes about 10 seconds on a 50meg db (25 filled) and
aobut
2? Minutes on a 1gig db with 550megs of data.  Once the file is
created,
I usually zip the file and ftp it down to my local machines for
backup
on CD.  Our hosting provider actually runs nightly backups, but
since
I'm not impressed with UUNET's service, I periodically back it up
myself.

Ryan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On
Behalf Of Keith Purtell
Sent: Thursday, December 13, 2001 12:20 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Scheduled Datasource Updating


Actually, we do something similar inside a backup procedure, because
we
can't back up our database while MSSQL7 is running.

 





winmail.dat
Description: application/ms-tnef


RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Doug Teetzen

Gentlemen, (a term used loosely at the moment)

Is this discussion not a testament to why we are all in this game of CF/Web
development to begin with?
We choose ColdFusion because it is a multi-platform, multi-database system
which allows HUGE flexibility with regard to the solutions we design. There
is no single right way to do any task with CF, we simply do as much as we
can with what we've got to work with and what we have learned. Sharing
insight and knowledge is the goal of this list, not slamming...

While I do agree that an Enterprise Database solution is the best. It was
broadly discussed at DEVCON in Orlando that Access 2000 has proven fairly
reliable working with CF in smaller environments.

Yes, Our company uses MS SQL, Not Access.But that may not be the answer
for all, not all companies have the resources nor the staff time and
knowledge that are enjoyed by many of us on this list.

Doug Teetzen

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 



RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Greenhagen, Robin

OK, If you are running MS Access as your DB, and you need the ODBC
drivers to let go of it so that you can hit it with your backup or
optimize routine, then the easiest way is to cause an ODBC error on
purpose.  This will release the connections to the .MDB until the next
query hits that asks for stuff from that datasource.

This can be as easy as 

cftry
cfquery name=conkiller datasource=#request.dsn#
SELECT NotARealColumn FROM NotARealTable
/cfquery
cfcatch type=ANY
cfexecute (your optimize call here...)
/cfcatch
/cftry

You may even want to throw in an exclusive CFLOCK to be sure others
arent trying to pound on the DB.

Cheers!
Robin Greenhagen
President
GreenSoft Solutions, Inc.
http://www.greensoft.com/

-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 12:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


am I crazy, or this a rediculous solution in the age of providing
worldwide
services in all timezones? and I can only assume that this maintenance
is
necessary because you're using an access db?

-Original Message-
From: Ellis, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


We have a scheduled BAT file running on our web server each night that
updates a database file.  The unfortunate thing is we actually down the
website to perform the updates and then bring the website back up.

The BAT file looks look this:
net stop WORLD WIDE WEB PUBLISHING SERVICE
C:\Update.exe
net start WORLD WIDE WEB PUBLISHING SERVICE

Randy

-Original Message-
From: Bakken, Kory [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:09 AM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Scheduled Datasource Updating


I need to schedule maintenance window each night to perform automated
repairs and compaction on my main database.  I know how to do that, but
in
order to repair and compact the database, I need to disconnect the
datasource that is hitting against it for that period of time.  Does
anybody
know if it is possible to schedule updates to a datasource
(i.e.-disconnect
and reconnect)?

Kory Bakken
IT Enterprise Release Management
Tools / Process
desk:  816.559.4801
pcs:816.305.5890

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 


__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]




RE: [KCFusion] Scheduled Datasource Updating

2001-12-13 Thread Bakken, Kory

Thank you, Robin.  That makes complete sense.

-Original Message-
From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 2:21 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Scheduled Datasource Updating


OK, If you are running MS Access as your DB, and you need the ODBC
drivers to let go of it so that you can hit it with your backup or
optimize routine, then the easiest way is to cause an ODBC error on
purpose.  This will release the connections to the .MDB until the next
query hits that asks for stuff from that datasource.

This can be as easy as 

cftry
cfquery name=conkiller datasource=#request.dsn#
SELECT NotARealColumn FROM NotARealTable
/cfquery
cfcatch type=ANY
cfexecute (your optimize call here...)
/cfcatch
/cftry

You may even want to throw in an exclusive CFLOCK to be sure others
arent trying to pound on the DB.

Cheers!
Robin Greenhagen
President
GreenSoft Solutions, Inc.
http://www.greensoft.com/

-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 12:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


am I crazy, or this a rediculous solution in the age of providing
worldwide
services in all timezones? and I can only assume that this maintenance
is
necessary because you're using an access db?

-Original Message-
From: Ellis, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating


We have a scheduled BAT file running on our web server each night that
updates a database file.  The unfortunate thing is we actually down the
website to perform the updates and then bring the website back up.

The BAT file looks look this:
net stop WORLD WIDE WEB PUBLISHING SERVICE
C:\Update.exe
net start WORLD WIDE WEB PUBLISHING SERVICE

Randy

-Original Message-
From: Bakken, Kory [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 11:09 AM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Scheduled Datasource Updating


I need to schedule maintenance window each night to perform automated
repairs and compaction on my main database.  I know how to do that, but
in
order to repair and compact the database, I need to disconnect the
datasource that is hitting against it for that period of time.  Does
anybody
know if it is possible to schedule updates to a datasource
(i.e.-disconnect
and reconnect)?

Kory Bakken
IT Enterprise Release Management
Tools / Process
desk:  816.559.4801
pcs:816.305.5890

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
 
 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]