Data Connections
DBxtra 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 OLE DB.
Create a New Data Connection
Select the type of database you want to connect to.
If the database type is not listed select "OLEDB" or "ODBC".
Connect to FoxPro - Database Container
Connect to FoxPro - Free Table
Edit a Data Connection
To edit a Data Connection select it and right-click it and select "Edit Connection"button.
Data Connection Properties
To edit "Connection Properties" right-click the "Data Connection" and select "Properties".
General
Connection name: You can rename the Data Connection.
Connection Data: Show information about your data connection.
Privileges
Assign User Group privileges by selecting user groups with privileges to view objects of the selected Data Connection.
Dependencies
Shows a list of all object dependencies of the selected Data Connection.
See also: Project Properties
Refresh Data Connection
Sometimes you will need to refresh a Data connection; for example if new data base objects like tables and views were created or edited in the database.
To refresh a Data Connection right-click it and select "Refresh Connection".
This procedure will retrieve the most current database schema.
Copy a Data Connection
To copy a Data Connection, select it and drop and drag it to another Project.
Delete Data Connection
To delete a Data connection right click it and select "Delete Connection".
Important! If you delete a Data Connection all dependent objects will also be deleted and placed into the Recycle Bin.
See also: Recycle Bin.
Data Connection Offline mode
Offline mode enabled
DBxtra .NET will load Query definitions after the connection is established or when you click the "Refresh Connection".
Advantage: Takes less time loading the object tree view.
Disadvantage: Will take longer loading the object tree for the first time or by refreshing the connection.
You also need to use the refresh option in order to view changes in your database.
Offline mode disabled
DBxtra will load definitions every time you load a Report Object.
Advantage: You always have access to the database object structure and don't need to refresh the connection to view database object changes.
Disadvantage: Might take longer when loading the Query.