File.Move reports file as in use

DanRoche · April 25th, 2007, 03:14 PM

I just want to move a file after I'm done working with it.

It's a DBF File which I access using ADODB:

Code:

ADODB.Recordset rs= new ADODB.Recordset();

//Connection String = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=d:\\hotfolder\\;Exclusive=No"

rs.Open("select * from "+inputFile,DBFConnection,CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockBatchOptimistic,1);

..do stuff

rs.close();
lastSlash = inputFile.LastIndexOf("\\");
moveFile = inputFile.Substring(lastSlash+1);
File.move(inputFile,moveFile)

All my processing works, it just won't let me move the file cause it says it's in use.

Is there additional cleanup I have to do other than rs.close()?

thanks

planoie · April 25th, 2007, 07:12 PM

Why are you using an ADODB recordset in .net? There are far better options, and they may eliminate your problem. I would imagine that you should be able to connect to a foxpro database using the System.Data.OleDb.OleDbConnection class.

-Peter

DanRoche · April 26th, 2007, 10:30 AM

Yeah, I just switched to the OleDb Class / methods (I am not mastered in C# :( ). But I'm still getting same error.

Scratch that, I have to use the dispose() method of the connection object, as opposed to just closing it.

Thanks :)

DZukiewicz · May 3rd, 2007, 07:27 AM

Download ProcessExplorer.exe from SysInternals, and use the Find -> Find Handle Or DLL. This will show you what is holding onto the file. If you have the file open in the IDE, this could also be a problem.

Regards,

Dominic