Access Database
Cross-Database Studio allows connection to any ODBC
enabled database.
Cross-Database Studio working environment is a Workspace.
Workspace
contains Database Connections. You can define connections for any amount or
different types of databases in the same workspace.
To access your database, create Database Connection in the workspace.
The
main ways to create a database connection are:
- Using ODBC connect string
- Using ODBC DSN
- Using ODBC connect string, based on DB vendor driver
Add database connection to an existing workspace:
- In the existing workspace, Right click on Database Connections
node.
Add Database connection based ob an existing ODBC DSN
- Use New DSN based Database Connection command. The
Add DSN based Database Connection dialog is displayed.
- Use User Data Source and/or System Data
Source option to see User- and/or System DSN registered on your
machine.
- Select one or more DSN/s from the provided list.
Use Create
New DSN button in case you need to create and register a new DSN.
- Click Finish button. Each selected DSN will be used to
create one Database Connection on its basis.
Each Database Connection
will derive its name from the basic DSN.
Add Database connection using Database Connection Wizard
- Use New Database Connection Wizard command
- Follow Database Connection wizard to configure the connection - see Create Database Connection
- Database Connection name appears in the Workspace tree (on both
application sides)
- Double-click the Database Connection name to connect to the database.
- Expand Database Connection name node and see database objects.
Once Database Connections created, you have full access to all structures and
data, defined in the database, according to connection properties and DB user
privileges.
See also: