Farpoint spread 8.0 OLEDB

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

  • 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 ?
  • Replied 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
  • Marked as Answer

    Replied 22 May 2018, 5:21 pm EST

    thanks
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels