Connecting to the Database

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Tutorials > "ZooDB" Database > Setting Up a Database Project >

Connecting to the Database

Once the database for this tutorial has been created (see Creating the Tutorial Database), you can connect to it using the Connection Wizard. The Connection Wizard allows you to establish a connection to existing databases of the most commonly used database types, such as Microsoft Access, Microsoft SQL Server, Oracle, MySQL, IBM DB2, Sybase, and PostgreSQL.

 

 

To connect to the tutorial database:

1.Select the menu option File | Create a Database Connection... or press Ctrl+Q. The "Add a Data Source" dialog box appears.
2.Click the Connection Wizard button at the top left of the dialog if it is not already selected, and select Microsoft SQL Server ( ADO ).
3.Click Next. The configuration page of the Connection Wizard appears.

dlg_dbcon2

4.Select the database provider Microsoft OLE DB Provider for SQL Server from the combo box.
5.Click Next. The Connection tab of the Data Link Properties dialog box appears.

dlg_dbcon3

6.Select or enter the name of the server you want to connect to, e.g., TS-SQL.
7.Choose the Use a specific user name and password radio button.
8.Enter the user name and password.
9.Activate the Allow saving password check box.
10.Select the database you want to connect to from the drop-down list, e.g., ZooDB, and click OK.
11.In the Set A Data Source Name dialog box, set the connection name to "ZooDBConnect" and click OK.

dlg_dbcon4

The Project window now contains a connection called "ZooDBConnect" in the Data Sources folder.

dlg_dbcon5


© 2019 Altova GmbH