Farpoint spread 8.0 OLEDB

Farpoint spread 8.0 OLEDB

Posted by: damalor2002 on 20 May 2018, 8:46 pm EST

• 

  damalor2002

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 May 2018, 8:46 pm EST

  I have Farpoint spread 8.0
  
  I added this control to visual studio toolbox to use it in my C# program.
  
  My OS is windows 7 64bit
  
  I also have office 2013 64bit

  I added the following code to my program in the load even of the main form

          ```
  

  OleDbConnection connection = new OleDbConnection(@“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\PriceLists\items.accdb;Persist Security Info=False”);
  
  connection.Open();

          OleDbCommand cmd = new OleDbCommand("select * from itemsmain",connection);
  
          OleDbDataReader dr = cmd.ExecuteReader();
          DataTable dt = new DataTable();
          dt.Load(dr);
  

  
  when I run the program it runs fine and it connects to the access database.
  However, when I add the spread control on the form and try to run the program, it gives me the following error message.
  
  System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'
  
  Once I remove the spread control from the form, the program runs normally.
  
  Can you help please ?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2018, 5:18 pm EST

  Hello,

  Spread 8 COM is an ActiveX control and designed to be used in unmanaged environment. I would suggests you to please upgrade to our .Net version of Spread in case you want to use Spread in managed environment.

  Thanks,
  
  Deepak Sharma

• 

  damalor2002

  • Post Options:
  • Link
    Copy

  Posted 22 May 2018, 5:21 pm EST

  thanks