Database Connectivity from a PC Windows Platform
ODBC connectivity allows one to access data from the MS SQL server from applications such as ACCESS, EXCEL, and VISUAL BASIC. Data in the BOG MS SQL database resides on the PERSEUS server. Please see MBARI' s Database Administrator for further details on the server. For details on the BOG data tables refer to the online manual. Following you will find instructions to configure your computer's ODBC settings.
1. Open the Control Panel and select 'Setup data source (ODBC)'. On some computers this may be under 'Administrative Tools'. This will open the 'ODBC Data Source Administrator'. Choose the 'System DSN' tab and the Add option. If you have a previous BOG configuration you can reconfigure it to the new PERSEUS configuration.
2. The Add option will open the 'Create New Data Source' window; select 'SQL Server' and press the Finish option. The 'Configure' option will open the current DSN configuration. If these options do not show up, please submit an I.S. help ticket.
3. This will open a window where you will select the database server. For the BOG database select PERSEUS. You must name your 'Data Source Name' BOG (please use capital letters).
4. You will need to request access permission from the MBARI database administrator. If you have problems please submit an I.S. help ticket.
Last Updated: 21 June 2018