This question is locked. New answers and comments are not allowed.
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
--------------------------------------------------
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
--------------------------------------------------