This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
how_to:dbconnection [2009/12/16 09:22] 132.168.73.247 |
how_to:dbconnection [2011/07/22 14:30] 132.168.73.124 |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== How to create a connecting to a database ====== | + | ====== How to create a connection to a database ====== |
- | In order to use hEIDI, a connection to a MSI db (Mass Spectrometer Identification database) is requiered. But it is possible to create a conenction to all kind of databases and to execute queries on it. | + | In order to use hEIDI, a connection to a MSI db (Mass Spectrometer Identification database) is required. But it is possible to create a connection for all kind of databases and to execute queries on it. |
In the ''Service'' window, | In the ''Service'' window, | ||
- | * expend the ''Drivers'' node | + | * Expand the ''Drivers'' node |
- | * select the database server type hosting your MSIdb | + | * Select the database server type hosting your MSIdb, for example ''PostgreSQL'' |
- | * enter the connection properties in appropriate fields. | + | * Right-click and select ''Connect using...'' in the context sensitive menu in order to enter the connection properties. |
- | {{:connect.png|}} | + | **Connection to a Postgres server** |
- | **Connection to a postgres server** | + | **Note** : |
+ | * :!: **Information that appear in the screen shot below are dummy, ask your system admin for your serverhost/database/user/password in order to connect to your database** :!: | ||
+ | * MSIdb are most often created on postgreSQL databases server and in the ''Advanced'' tab, choose ''public'' as schema | ||
- | **Note** : MSIdb are most often created on postgresql databases server and in advance tab, choose ''public'' as schema | + | |
+ | {{:connect.png|}} | ||