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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4