On 11/8/00, Guy J. McDowell penned:
>Situation:
>Database and sites hosted externally, site created internally.
>Currently if any changes to the datasource's structure are made they
>are made locally and then uploaded to the host, who has to shut off
>the CFServer and restart it.
Why? They shouldn't have to restart CF just to overwrite a datasource.
If it's because of the database lock placed by Access, you have 2
options. Have the host turn off "Maintain database connections" to
the datasource in cf administration. You should do this with Access
anyway.
Or, you can write a bad query.
<CFQUERY DATASOURCE="your_datasource" NAME="breakodbclock">
SELECT nota
FROM nothing
</CFQUERY>
This will return an error and break the lock on the database and you
can upload right over it.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
