System.InvalidOperationException : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

[Gayathri Katragadda]

I am using access data base engine to read data from excel data. from visual studio i am able to run all the tests without any issue. but while running from Jenkins i am getting this error message.

System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.
  ----> System.InvalidOperationException : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at NUnit.Framework.TestCaseSourceAttribute.GetTestCaseSource(IMethodInfo method) in C:\src\nunit\nunit\src\NUnitFramework\framework\Attributes\TestCaseSourceAttribute.cs:line 277
   at NUnit.Framework.TestCaseSourceAttribute.GetTestCasesFor(IMethodInfo method) in C:\src\nunit\nunit\src\NUnitFramework\framework\Attributes\TestCaseSourceAttribute.cs:line 173
--InvalidOperationException
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at LinqToExcel.Query.ExcelUtilities.GetWorksheetNames(ExcelQueryArgs args)
   at LinqToExcel.ExcelQueryFactory.GetWorksheetNames()
   at Automation_Framework.Excel_Data_Reader.CommonBaseDataReader.get_WorkSheetNames() in C:\WIC\HANDS\EBT\Test_Automation\Hands_Automation_SmokeSuite_src\Automation_Framework\Excel Data Reader\Model\CommonBaseDataReader.cs:line 37
   at Automation_Framework.Excel_Data_Reader.CommonDataReader.get_FamilyInfoData() in C:\WIC\HANDS\EBT\Test_Automation\Hands_Automation_SmokeSuite_src\Automation_Framework\Excel Data Reader\Model\CommonDataReader.cs:line 244
   at Automation_Framework.Excel_Data_Reader.CommonDataReader.IntializeFamilyDetails() in C:\WIC\HANDS\EBT\Test_Automation\Hands_Automation_SmokeSuite_src\Automation_Framework\Excel Data Reader\Model\CommonDataReader.cs:line 80
   at Automation_Framework.Excel_Data_Reader.CommonDataReader.get_Families() in C:\WIC\HANDS\EBT\Test_Automation\Hands_Automation_SmokeSuite_src\Automation_Framework\Excel Data Reader\Model\CommonDataReader.cs:line 32
   at Automation_Smoke_Tests.Data.CommonInfoTestData.Families() in C:\WIC\HANDS\EBT\Test_Automation\Hands_Automation_SmokeSuite_src\Automation_Selenium_Tests\Data\CommonInfoTestData.cs:line 102

[Gayathri]

Can some help me on this. is there any way to add Microsoft Access Database Engine 2010 Redistributable .exe file to jenkins

or 

using LINQToExcel how we can read while running test cases from Jenkins.

[mohan reddy]

Hey Gayatri,

Please reach me out for clarification

-Mohan Reddy

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/4bc07231-2f14-4d22-bb56-2eecee8643ef%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.