Hi, I need help with some errors I am encountering after converting from MSSQL to Oracle.

I have already added the OracleSqlHelper object in SqlDataProvider.cs. And return all the data as usual. But my gridview is just unable to retrieve and display the data but instead. It is displaying me some error.

Error: Email Templates Admin is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The type initializer for 'Websparks.Modules.EmailTemplates.DataProvider' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Websparks.Modules.EmailTemplates.DataProvider' threw an exception. ---> System.ArgumentNullException: Value cannot be null. Parameter name: type at System.Activator.CreateInstance(Type type, Boolean nonPublic) at DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) at DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectNamespace, String ObjectAssemblyName) at Websparks.Modules.EmailTemplates.DataProvider.CreateProvider() at Websparks.Modules.EmailTemplates.DataProvider..cctor() --- End of inner exception stack trace --- at Websparks.Modules.EmailTemplates.DataProvider.Instance() at Websparks.Modules.EmailTemplates.EmailTemplatesController.GetEmailTemplates() at Websparks.Modules.EmailTemplates.ViewEmailTemplates.RetrieveGrid() at Websparks.Modules.EmailTemplates.ViewEmailTemplates.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---


ViewEventTemplates.ascx.cs

private void RetrieveGrid()
        {
            EmailTemplatesController controller = new EmailTemplatesController();


            EmailTemplatesGrid.DataSource = controller.GetEmailTemplates();
            EmailTemplatesGrid.DataBind();


            if (EmailTemplatesGrid.Items.Count == 0)
            {
                litEmailTemplates.Visible = true;
                EmailTemplatesGrid.Visible = false;
            }
        }


EmailTemplatesController.cs

public List<EmailTemplatesInfo> GetEmailTemplates()
        {
            return CBO.FillCollection<EmailTemplatesInfo>(DataProvider.Instance().GetEmailTemplates());
        }


SqlDataProvider.cs

public override IDataReader GetEmailTemplates()
        {
            OracleSqlHelper OracleSqlHelper = new OracleSqlHelper();
            return (IDataReader)OracleSqlHelper.ExecuteReader(ConnectionString, ObjectQualifier + "GetEmailTemplates");
        }


It will be great if someone who has successfully developed custom modules using AcuitiDP to help out. Thanks a lot.