RE: Locked Database

2001-08-07 Thread Andrew Tyrone 

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:36 PM
To: CF-Talk
Subject: Re: Locked Database



  >I'd advise against this usage.  Performing invalid queries isn't the 
>preferred method.  Using the CFusion_DBConnections_Flush() function is a 
>much more stable way to unlock an Access database.


What is the reason for not doing the former?  The latter will disrupt all datasources 
on the machine -- not a desired result by any means, although if his datasource is the 
only one, then I don't see why it matters.  Since both break the connection, what are 
the reasons behind not using the first method?

-Andy


At 10:32 PM 08/06/2001 -0400, you wrote:
>The simplest way is to make a bogus call to the database that will
>definately produce an error (such as a call to a table or column that
>doesn't exist).  That will cause the Access engine to drop connections to
>the database and will unlock it.  There is a way that works for databases
>besides Access, but that should do what you want :)
>
>Todd
>
>- Original Message -
>From: "CFHelp" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, August 06, 2001 10:11 PM
>Subject: Locked Database
>
>
> > Is there some code I can put into a page to unlock an access database?
> >
> >
> > Rick Eidson
> > Owner
> > http://www.kchost.net/
> > KChost is getting ready to launch it's enews service
> > Now you can moderate your own affordable newsletter
> > Promote you products and services even sell advertising. Plans start at
> > $5 a month for 500 emails. FREE Trial account.
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Locked Database

2001-08-07 Thread Jeffry Houser 


  I'd advise against this usage.  Performing invalid queries isn't the 
preferred method.  Using the CFusion_DBConnections_Flush() function is a 
much more stable way to unlock an Access database.

At 10:32 PM 08/06/2001 -0400, you wrote:
>The simplest way is to make a bogus call to the database that will
>definately produce an error (such as a call to a table or column that
>doesn't exist).  That will cause the Access engine to drop connections to
>the database and will unlock it.  There is a way that works for databases
>besides Access, but that should do what you want :)
>
>Todd
>
>- Original Message -
>From: "CFHelp" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, August 06, 2001 10:11 PM
>Subject: Locked Database
>
>
> > Is there some code I can put into a page to unlock an access database?
> >
> >
> > Rick Eidson
> > Owner
> > http://www.kchost.net/
> > KChost is getting ready to launch it's enews service
> > Now you can moderate your own affordable newsletter
> > Promote you products and services even sell advertising. Plans start at
> > $5 a month for 500 emails. FREE Trial account.
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locked Database

2001-08-06 Thread Tony Gruen 

of course, there is always the option of taking a little performance hit and
setting the DSN up to not maintain the DB connection.

Tony Gruen

-Original Message-
From: CFHelp [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 7:12 PM
To: CF-Talk
Subject: Locked Database


Is there some code I can put into a page to unlock an access database?


Rick Eidson
Owner
http://www.kchost.net/
KChost is getting ready to launch it's enews service
Now you can moderate your own affordable newsletter
Promote you products and services even sell advertising. Plans start at
$5 a month for 500 emails. FREE Trial account.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Locked Database

2001-08-06 Thread Todd Ashworth 

> I'd have to think that Disable Database Connections would also be
> immediate (but I'm honestly not sure). And while it may be more
> intrusive then momentarily unlocking the database with a bad query, if
> Rick's site is popular, disabling database connections to the db may be
> the only way to go because other users may relock the database before he
> can initiate / complete his upload.  Similarly, if users try to query
> his database while he's uploading the database, they will receive an
> error.
...
> - Jay

ack .. I lapsed into the mindset of a database that doesn't need uploading
to update the DB structure.  My bad :(

Todd

>
> -Original Message-
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 11:05 PM
> To: CF-Talk
> Subject: Re: Locked Database
>
>
> > Usually sending a bad query to the data source will break the lock.
> > You can also set "disable database connections" in the CF
> > Administrator.  If you disable db connections, make sure you enable
> > them again, otherwise your site won't work :-)
>
> The bogus query is a better option .. it is less intrusive and more
> immediate than the "disable database connections" one.  The other method
> I was refering to in my last post is the CFusion_DBConnections_Flush()
> function.  That tends to break all DB connections without having to
> change anything on the CF server.  To use it, set some temp variable to
the function .. .eg:  
>
> Todd
>
> > Jay Sudowski
> > -
> > Handy Networks LLC
> > TEL: 877-70-HANDY
> > FAX: 888-300-2FAX
> > URL: www.handynetworks.com <http://www.handynetworks.com>
> > -
> > Providing reseller and dedicated Windows 2000 web hosting solutions.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locked Database

2001-08-06 Thread Jay Sudowski - Handy Networks LLC 

I'd have to think that Disable Database Connections would also be
immediate (but I'm honestly not sure). And while it may be more
intrusive then momentarily unlocking the database with a bad query, if
Rick's site is popular, disabling database connections to the db may be
the only way to go because other users may relock the database before he
can initiate / complete his upload.  Similarly, if users try to query
his database while he's uploading the database, they will receive an
error.  I'd also think that it would be very possible some sort of
corruption or instability to seep into the file he's uploading if
ColdFusion tried to repeatedly open a connection to the database before
the upload has been completed.

- Jay

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 06, 2001 11:05 PM
To: CF-Talk
Subject: Re: Locked Database


> Usually sending a bad query to the data source will break the lock.  
> You can also set "disable database connections" in the CF 
> Administrator.  If you disable db connections, make sure you enable 
> them again, otherwise your site won't work :-)

The bogus query is a better option .. it is less intrusive and more
immediate than the "disable database connections" one.  The other method
I was refering to in my last post is the CFusion_DBConnections_Flush()
function.  That tends to break all DB connections without having to
change anything on the CF server.  To use it, set some temp variable to the function 
.. .eg:  

Todd

> Jay Sudowski
> -
> Handy Networks LLC
> TEL: 877-70-HANDY
> FAX: 888-300-2FAX
> URL: www.handynetworks.com <http://www.handynetworks.com>
> -
> Providing reseller and dedicated Windows 2000 web hosting solutions.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Locked Database

2001-08-06 Thread Todd Ashworth 

> Usually sending a bad query to the data source will break the lock.  You
> can also set "disable database connections" in the CF Administrator.  If
> you disable db connections, make sure you enable them again, otherwise
> your site won't work :-)

The bogus query is a better option .. it is less intrusive and more
immediate than the "disable database connections" one.  The other method I
was refering to in my last post is the CFusion_DBConnections_Flush()
function.  That tends to break all DB connections without having to change
anything on the CF server.  To use it, set some temp variable = to the
function .. .eg:  

Todd

> Jay Sudowski
> -
> Handy Networks LLC
> TEL: 877-70-HANDY
> FAX: 888-300-2FAX
> URL: www.handynetworks.com 
> -
> Providing reseller and dedicated Windows 2000 web hosting solutions.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locked Database

2001-08-06 Thread Jay Sudowski - Handy Networks LLC 

Hi -

Usually sending a bad query to the data source will break the lock.  You
can also set "disable database connections" in the CF Administrator.  If
you disable db connections, make sure you enable them again, otherwise
your site won't work :-)

Jay Sudowski
-
Handy Networks LLC
TEL: 877-70-HANDY
FAX: 888-300-2FAX
URL: www.handynetworks.com  
-
Providing reseller and dedicated Windows 2000 web hosting solutions.


-Original Message-
From: CFHelp [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 06, 2001 10:12 PM
To: CF-Talk
Subject: Locked Database


Is there some code I can put into a page to unlock an access database?
 
  
Rick Eidson
Owner
http://www.kchost.net/
KChost is getting ready to launch it's enews service
Now you can moderate your own affordable newsletter
Promote you products and services even sell advertising. Plans start at
$5 a month for 500 emails. FREE Trial account.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Locked Database

2001-08-06 Thread Todd Ashworth 

The simplest way is to make a bogus call to the database that will
definately produce an error (such as a call to a table or column that
doesn't exist).  That will cause the Access engine to drop connections to
the database and will unlock it.  There is a way that works for databases
besides Access, but that should do what you want :)

Todd

- Original Message -
From: "CFHelp" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 10:11 PM
Subject: Locked Database


> Is there some code I can put into a page to unlock an access database?
>
>
> Rick Eidson
> Owner
> http://www.kchost.net/
> KChost is getting ready to launch it's enews service
> Now you can moderate your own affordable newsletter
> Promote you products and services even sell advertising. Plans start at
> $5 a month for 500 emails. FREE Trial account.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists