How do I create a data source to reels.mdb?

How do I create a data source to reels.mdb?

Posted by: dbriars on 12 January 2023, 2:53 am EST

• 

  dbriars

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 January 2023, 2:53 am EST

  I downloaded the reels.mdb file ok from github.

  I am now at the ‘Report Data Source - General’ screen, and am stuck not knowing what settings to ‘Type’/‘Provider’ would allow me to connect to reels.mdb.

  From what I’ve seen so far, all of the examples provided to learn ActiveReports use reels.mdb.

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 12 January 2023, 5:23 pm EST - Updated 15 February 2023, 1:58 am EST

  Hi David,

  Apologies for the inconvenience caused.
  
  In order to use the ‘Reels.mdb’ DataBase you can:

  • Set the DataSource Type as “Microsoft OleDb Provider”
  • Select “Microsoft.Jet.OLEDB.4.0” as the OLE DB Provider.
  • In the ‘Server or file name’ select your ‘Reels.mdb’ file and click on ‘OK’.

  After this, you’ll also need to add a DataSet in which you can store a table from the Reels.mdb database. To do the same:

  • Right-click on your DataSource and click on ‘Add Data Set’ option.
  • In the window that opens go to ‘Query’ tab.
  • Here you can assign your SQL query to get the Table you want to assign to this DataSet or click on the ‘Pen’ tool to open the ‘Query Designer’ and select the tables using the dialog that opens.
  • Click on ‘OK’ and you can now use the fields from your DataSet within your report.

  We have also attached a video that demonstrates connecting to the ‘Reels.mdb’ database for your reference.

  You may also refer to this page from our ActiveReports Documentation to learn more about Connecting to a DataSouce: https://www.grapecity.com/activereportsnet/docs/versions/v16/online/report-datasource-dialog.html
  
  To read about Connecting to an OLEDB Data Source you may also refer to: https://www.grapecity.com/activereportsnet/docs/versions/v16/online/microsoft-oledb-provider.html

  Hope this resolves your issue.
  
  However, if you have any further queries you may create a Forum Post on ActiveReports - Forum: https://www.grapecity.com/forums/ar-dev. Or open a Support ticket with the Product Group selected as ‘ActiveReports.NET’.

  Best Regards,
  
  Anand

  ReportDataSource.zip