Estudios probabilistas de peligrosidad sísmica

Vulcan can link to most standard database packages via an ODBC link. This allows information to be viewed straight from Microsoft® Access, acQuire™ or Oracle®. The initial ODBC link setup is a standard windows option. A link must be set within the .dsf after which, data import is not necessary, as the database is automatically created through the link.

ODBC Databases can be viewed in the Vulcan Explorer window under User Databases. When set up, they are accessed in the same way as a standard header database.

Figure 10-16: Vulcan Explorer window

Setting Up an ODBC Link to Microsoft® Access Database

To access information from a database, an ODBC connection has to be configured.

To set up an ODBC link in Windows XP:

1. Click Start and then click Control Panel.

2. Double-click Administrative Tools.

3. Double-click Data Sources (ODBC).

ODBC links can be created either per user or per system.

4. On the ODBC Data Source Administrator dialog box, select the User DSN tab and highlight MS Access Database.

5. Click the Add button. Click OK.

Tutorial 10.11

1. Create a second database by importing through the Isis menu options.

2. Name the database thortables.dhd.isis.

Database Overview 111 Figure 10-17: ODBC Data Source Administrator dialog box

6. On the Create New Data Source dialog box, select Driver do Microsoft Access Driver (*mdb).

Figure 10-18: Create New Data Source dialog box

7. Click Finish.

8. On the ODBC Microsoft Access Setup dialog box, add a name in the Data Source Name field.

9. Add a Description.

10. Click Select and Browse to the correct .mdb file. The maximum allowed name length of the Data Source Name is eight characters.

User DSN tab

Add button

112 10 Creating a Database Figure 10-19: ODBC Microsoft Access Setup dialog box

11. Click OK.

Setting up an ODBC link in the DSF:

1. Open Isis.

2. Select File > New Design.

3. In the Design Properties click the Configure button.

4. In the Data Source Setup, select ODBC from the Source drop-down list box.

Figure 10-20: Data Source Setup dialog box

5. Point to the connection created in Administrative Tools/ Data Sources (ODBC). If a user name and password is set up for the database it must be entered. If not, leave blank.

Once the initial ODBC source has been set up, the source for each table, and then each field must be set up. The table source is set via the Configure button in the table properties.

The individual field sources are set by clicking on the Browse button in the source column for each field. Depending on which ODBC Table was selected in the Table properties, the drop-down list box will be populated with fields existing on that table.

Tutorial 10.12

Set up a ODBC link to the thordrillholes.mdb MS Access database located in the Introduction to Vulcan training data set.

Select button

Database Overview 113 Figure 10-21: Source information button

Figure 10-22: Source Information dialog box

AcQuire™

The acQuire interface in Vulcan creates a link to an acQuire database containing drillhole or composite data. This link is saved as a file in the working directory with a file name <project prefix><link name>.acq.isis. There is no need for a .dsf file in the creation of an acQuire link. Once the link is in place the interface performs exactly like the original acQuire dialog boxes for selecting which data to display.

Setting a link to acQuire requires an ODBC connection.

Setting up an ODBC connection in Windows XP:

1. Click Start and then click Control Panel.

2. Double-click Administrative Tools.

3. Double-click Data Sources (ODBC).

4. Click the Add button to create a new driver.

5. Highlight SQL Server.

Figure 10-23: Create New Data Source dialog box

6. Click Finish.

7. Name your data source and give it a description. The server to connect to should be the name of the computer.

114 10 Creating a Database Figure 10-24: Create a New Data Source to SQL Server dialog box

8. Click Next.

9. Select option Connect to SQL Server to obtain default settings for the additional configuration options.

10. Click Next.

11. Select option Change the default database to and insert a new name.

12. Select option Attach database filename and insert the path and filename of the database to use.

Copy and paste the path and file name of the database to avoid errors.

13. Click Next.

14. Accept the defaults and click Finish.

Database Overview 115 Figure 10-25: SQL Server ODBC Data Source Test dialog box

15. The ODBC Microsoft SQL Server Set up dialog box will display the settings for the newly created link. To verify the connection click Test Data Source.

16. Verify that the ‘TESTS COMPLETED SUCCESSFULLY!’ and click OK.

Setting up an ODBC connection in Vulcan:

When the ODBC link is set up, set up the Vulcan portion of the link.

1. Open Isis.

2. Select File > acQuire.

3. Name your new acQuire database link.

4. Click OK.

5. Select from the list the SQL Server connection created earlier and click Connect.

Tutorial 10.13

Set up a SQL link to the database provided.

116 10 Creating a Database Figure 10-26: Select data from acQuire dialog box

6. Type in a user name and password to connect to the database.

Figure 10-27: Connect to Database dialog box

The resulting dialog box is the same as that displayed by acQuire.

Database Overview 117 Figure 10-28: Select data from acQuire dialog box

The following tutorial shows how to load drillholes using several of these acQuire dialog boxes.

Figure 10-29: acQuire table Tutorial 10.14

1. From the Select Holes tab, load the Collar_BH data set under Alchemy.

2. Check the use box for the desired fields.

3. Click preview to view the selected drillholes.

4. Click the Filter button to limit the drillholes by a specific field.

Tutorial 10.15

1. Under the Assay tab expand the Alchemy header.

2. Select all the fields in the Assay_BH directory.

3. Click OK to accept the settings.

118 10 Creating a Database Figure 10-30: Select data from acQuire dialog box

Use the Abbreviations dialog box to change the name of the Vulcan field the data will be imported into. By default, the Vulcan field name is a shortened version of an acQuire field name.

Field names are limited to six characters and can not have the same name on the same table.

DSR file settings are the same for acQuire as for other Isis files. The most common style is tangent. Click OK.

Figure 10-31: Setup DSR dialog box

Creation of the link to an acQuire database is now complete and the Isis database thorlink1.acq.isis will now function just like any other Vulcan database.

Figure 10-32: Open Geological Database dialog box Tutorial 10.16

1. Verify or change the Vulcan field names and click OK.