[thelist] MySQL through MS Access?

[.jeff]

scott,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Scott Dexter
>
> As long as you don't have connections in Session or
> Application variables (big No-No anyways), this
> shouldn't be an issue. Connections (and thus
> file-locking on the db) are set up and torn down as the
> pageis being processed. So if you ensure there's noone
> accessing the site, yer good....
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

hmm, that made me wanna look harder for the culprit.  it seems it's a
checkbox in the edit screen for odbc settings in the coldfusion
administrator:

  "Maintain database connections - Check this
   box to maintain connections to data sources
   across client requests."

i'll bet that unchecking that would release the connection after each
request.

interesting,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/