XLReport connects to all popular databases like MS Access, MS SQL Server, Oracle, MySQL, Informix, DB2, DBase, Firebird, FoxPro, Excel; text files and almost any other database through ODBC and OLEDB.
- To add a new Data Connection, select >New>New Data Connection on the menu bar.
- Select a Connection type.
- Enter all required Connections settings fields.
The new Data Connection is now available in the Project Explorer.
Edit a Data Connection
- Select the Data Connection in the Project Explorer, right click and select Edit Data Connection.
Delete a Data Connection
- Select the Data Connection in the Project Explorer, right click and select Delete Data Connection.