Data driven test failed if executed from Test List or Test View

[Usman]

I databind 3 tests to an Excel sheet. 2 tests use Sheet1 and 1 test uses Sheet2.
If I run any of the test using Quick Execute it works fine.
But when I try to run the test using Test List or Test view it fails with error below.
All the tests have their DataType set to Excel and they are pointing to correct Datasource and DataTableName (sheet in the Excel workbook)
And the DataConnectionString is blank


*****************************************************************************************************
Overall Result: Fail
--------------------------------------------------
'18/08/2010 02:00:34 PM' - Unexpected exception during execution.
'18/08/2010 02:00:34 PM' - System.Data.OleDb.OleDbException (0x80040E37): The Microsoft Office Access database engine could not find the object 'Sheet1$'.  Make sure the object exists and that you spell its name and the path name correctly.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ArtOfTest.Common.Design.Data.ExcelDataSource.GetData(DataInfo testBindingInfo)
   at ArtOfTest.WebAii.Design.Execution.DataContext.InitializeDataSource(String outDirectory)
   at ArtOfTest.WebAii.Design.Execution.ExecutionContext.SetCurrentTestAndData(Test test)
   at ArtOfTest.WebAii.Design.Execution.TestExecuteProxy.ExecuteTest(Test test, Settings settings, String deploymentFolder, ExecutionType exeType)
--------------------------------------------------
'18/08/2010 02:00:34 PM' - Overall Result: Fail
--------------------------------------------------

[Usman]

Some more info:
I'm using Web UI Developer Edition and VS 2010.

[Konstantin Petkov]

Hello Usman,

Thank you for posting this question!

I was able to reproduce the error quite easy. It seems the problem occurs due to the disabled deployment in VS 2010 by default. Please follow the steps from this blog post to resolve the problem and let us know if you need further assistance or this works fine for you too.

Kind regards,
Konstantin Petkov
the Telerik team

[Usman]

It solved the problem :)
Thank you very much for your quick response.

Usman