Hmmm I'm trying to delete the file right after the stored proc completes.. I don't think its being released cause I can't seem to delete it. Even try to delete it manually. I have to wait approx 30 secs until I'm able to delete it.
-----Original Message----- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 9:04 AM To: CF-Talk Subject: RE: OT sql openrowset Tim, I use openrowset in a stored procedure to access an oracle database and AFAIK it closes the connection as soon as the procedure completes. If it didn't then the group that manages that oracle database would be out to kill me for all of the connections that would be created! Steve -----Original Message----- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 11:53 AM To: CF-Talk Subject: OT sql openrowset Hello all, I'm using openrowset to read a dbase file in a stored proc. From what I've read, that opens up a db connection. Is there a way close it?? Thanks, Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
