Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 22nd, 2007, 10:38 AM
Registered User
 
Join Date: Mar 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Directory not being released by process

I am creating a database connection to a .dbf file which is stored in a temp directory.
I open the connection and read from it using an OdbcDataAdapter object. Then I close the adapter and the connection.
When i try to then delete my temp dir named "128190509005573176" I get the following error/exception:

================================================== =================
The process cannot access the file 'C:\CARSMnet\bin\tmp\128190509005573176\' because it is being used by another process.
================================================== =================

Why won't the directory be released? It lets me delete the actual ".dbf" file i was working with but won't let me kill the parent dir.
Help?!?!?!

Here's my code:
OdbcConnection connection = new OdbcConnection(@"Driver={Microsoft dBase Driver (*.dbf)};DBQ=" + sTmpDirPath);

OdbcDataAdapter adapter = new OdbcDataAdapter("Select * from " + sTmpDirPath + "daox.dbf", connection);
System.Data.DataSet dataSet = new DataSet();

connection.Open();
adapter.Fill(dataSet);
                    
connection.Close();




Similar Threads
Thread Thread Starter Forum Replies Last Post
process.startinfo opens new instance of process Anypond General .NET 0 August 28th, 2008 05:35 AM
A new Report Editor Released ragundis Crystal Reports 0 February 24th, 2008 09:11 PM
Rowhandle must be released error sbabuk VB Databases Basics 0 September 16th, 2004 06:14 AM
Javascript Browser Sniffer 0.5 released paugq Javascript 0 May 27th, 2004 10:42 PM
When is ADO.NET 2.0 being Released?? chiefouko ADO.NET 1 April 27th, 2004 01:53 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.