When I Update my DB in a CFQUERY, my DB won't close.

[Byager]

How do I close my DB after I update using the code below:<br>
&lt;cfquery name="ItWorks" datasource="IPdda"&gt;<br>
UPDATE IPtbl<br>
SET IPaddress='#CGI.REMOTE_ADDR#', hostname='#CGI.REMOTE_HOST#'<br>
&lt;/cfquery&gt;<br>
<br>
When I look at my directory containing the DB, there is a locked version that won't go away and I can't use the DB. Is there something wrong with my code. Any help is appreciated.<br>
<br>
<br>
Brian

 

[DarkMan]

What database are you using?

 

[LucasT]

Go into the CF administrator under Datasources. In the advanced properties of that particular datasource, ensure that the "maintain connection to database" box is not checked. Depending on the type of DB you are using, enabling this feature can lock a db, table or record. It all just depends on the locking abilities of the particular DB.