This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
dbconnection [2009/12/16 09:14] 132.168.73.247 effacée |
— (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 | ||