This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
how_to:dbconnection [2010/01/04 17:17] 132.168.74.230 |
how_to:dbconnection [2016/08/24 15:38] 132.168.73.77 |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== How to create a connection 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: ''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|}} | ||