Configuration system failed to initialize smtpop.dll

Question

Hi,

I am now trying for a few days to resolve an error.

I created a project to read from a pop3 emailbox and get the attachments from all messages, save them to a local folder.
I used the smtpop.dll freeware library.
I worked with the code on this site: http://www.fryan0911.com/2009/05/how-to-read-pop3-email-using-c.html

This is working fine in debug mode. All attachments get pulled from the emails and saved to folder.
But... when i build the project and try to run the project, from the /release folder or any other pc, then i get the error:Configuration system failed to initialize
I placed the smtpop.dll in the same folder as the .exe
i referenced and used the .dll as described on the website.

What am i doing wrong, why do i get the error after building and not while debugging ?

Can anyone shed some light on it ?

rudy

Answer 1

Hey Ahmed,

Please review your code and question, as you are asking 'excel file was not created' and in your code, you are returning false, if file doesnot exists

 

if (!File.Exists(strFilePath)) return false;

 

Please check the below link for your reference: 

 http://csharp.net-informations.com/excel/csharp-create-excel.htm

Answer 2

Hi, check this link for generating Excel from database.

 

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html

Answer 3

my problem only in creating excel so that i try with another way 

in the code here excel file  created but not open so that can you tell me why not open after created

my code as bellow

public void CreateSheetIfNotExists()
       {
           using (System.Data.OleDb.OleDbConnection databaseConnection = new System.Data.OleDb.OleDbConnection())
           {

               DataTable schemaTable = default(DataTable);

               databaseConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=D:\\Book310.xlsx;Extended Properties=Excel 12.0;";

               databaseConnection.Open();

               schemaTable = databaseConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] {
           null,
           null,
           "Sheet1$"
       });

               if (schemaTable.Rows.Count == 0)
               {
                   string SQLDDLCommand = "CREATE TABLE [Sheet1] (UserID INTEGER, UserName CHAR(255))";
                   System.Data.OleDb.OleDbCommand excelCommand = new System.Data.OleDb.OleDbCommand(SQLDDLCommand, databaseConnection);
                   excelCommand.ExecuteNonQuery();

               }

               databaseConnection.Close();
           }
       }

after that file 310 created but not open

when open file i get this error