This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dbconnection [2009/12/16 07:50] 132.168.73.247 |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== How to creata a connecting 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. | ||
| - | |||
| - | ===== Create a connection on database ===== | ||
| - | |||
| - | In the ''Service'' window, | ||
| - | * expend the ''Drivers'' node | ||
| - | * select the database server type hosting your MSIdb | ||
| - | * enter the connection properties in appropriate fields. | ||
| - | |||
| - | {{:connect.png|}} | ||
| - | |||
| - | **Connection to a postgres server** | ||
| - | |||
| - | **Note** : MSIdb are most often created on postgresql databases server and in advance tab, choose ''public'' as schema | ||