[thelist] MySQL through MS Access?
.jeff
jeff at members.evolt.org
Mon Jan 14 17:41:03 CST 2002
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/
More information about the thelist
mailing list