[Error] Ado.net provider System.data.odbc not registered in the system

[Error] Ado.net provider System.data.odbc not registered in the system

Posted by: derek.welsh on 3 August 2019, 4:36 pm EST

• 

  derek.welsh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 August 2019, 4:36 pm EST

  Hi,
  
  I keep getting this message when trying to display a report using FlexViewer.
  
  I would really appreciate some help here please?
  
  Test Code:
  
  C1FlexReport c1FlexReport = new C1FlexReport();
  
  c1FlexReport.Load(@“…..\Resources\CaseHistoryReport.flxr”, “CaseHistoryReport”);
  
  CorrectConnectionString(c1FlexReport);
  
  c1FlexReport.StartReport += c1r_StartReport;

              Window2 w = new Window2();
              w.flv.DocumentSource = c1FlexReport;
              w.ShowDialog();
  

  Thank you

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 4 August 2019, 4:52 pm EST

  Hello Derek,

  This is a general error of Ado.net. Could you please try with any other data-bound component in your application. Also, please share the connection string so that I can look into the issue.

  Thanks.

• 

  derek.welsh

  • Post Options:
  • Link
    Copy

  Posted 5 August 2019, 12:27 pm EST

  Hi mohitg
  
  Thanks so much for the reply. I forgot to mention this is a wpf developed app.
  
  I am using the Devart .net library for direct access to the db, this is the only instance where I use odbc interface.
  
  Please see my connection string below:

  Thanks again mohitg, look forward to hearing from you

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2019, 5:18 pm EST

  Hello Derek,

  This error is not related to FlexReport. Could you please check with “DataGridView” control of WinForms application just for testing. This is very helpful for us to narrow down the issue.
  
  Also, could you please try after running your application on 64/33 bit.

  Thanks.

• 

  derek.welsh

  • Post Options:
  • Link
    Copy

  Posted 5 August 2019, 6:41 pm EST

  Hi Mohitg
  
  I have tried all of the other sample apps supplied with Component One and have not experienced this issue. It has only occurred since trying to add the reporting feature and the Flexreport and Flexviewer components.
  
  The application I am adding this feature to, uses a MySql db that is updated from my tablet app ( running sqlite ). I am accessing the db directly via the Devart MySql component.
  
  I agree with you, I don’t believe it is the Component One tools, I am sure it may relate to the 32/64 bit issue. If I try to compile my program as a 32 bit app however I get errors on all the Flexxxxx includes.
  
  Look forward to your further thoughts
  
  Regards Derek

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 6 August 2019, 10:30 pm EST - Updated 4 October 2022, 12:04 am EST

  Hello Derek,

  I have tried all of the other sample apps supplied with Component One and have not experienced this issue
  
  Have you tried Database binding in this samples with the same connection string?

  Could you please check “System.Data.Odbc” provider name is present in the “ODBC DataSource Administrator(64 Bit)” Please refer the attached image.

  If I try to compile my program as a 32 bit app however I get errors on all the Flexxxxx includes
  
  Could you please share the screenshot of the error message which occurs on changing the application to 32 bit.

  Thanks.