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=subscribeforumid=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