I am running the following code to fill a dataset and I am getting file in use error. I have restarted, cleared my cache. What might be the problem. Can't think... 1 AM...
Thanks in advance,
Shrini
Code:
Dim strSQL As String = "Execute " & spName 'Stored Procedure
Dim myConn1 as New OleDbConnection(AccessConnString)
Dim oda As New OleDBDataAdapter(strSQL, myConn1)
Dim ds As New DataSet
Try
oda.Fill(ds, dsName) <--Line21
Return ds 'Return the DataSet
Catch e As Exception
lblError.Text = e.ToString
Finally
If Not oda Is Nothing Then oda.Dispose()
If Not ds Is Nothing Then ds.Dispose()
End Try
Error:
System.Data.OleDb.OleDbException: Could not use ''; file already in use. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ASP.DesktopDefault_aspx.GetSingleSelect(String DbType, String spName, String dsName) in line 21