topic Re: Accessing SIM DB in Server Management - Systems Insight Manager

Accessing SIM DB

sudesh_5 — Tue, 28 Mar 2006 23:30:43 GMT

Hi ,

I have installed SIM 5.0 on HP-UX. I want to access the SIM DB . Can anyone please provide the steps for accessing the SIM DB.

Regards
Sudesh

Re: Accessing SIM DB

topuli — Wed, 29 Mar 2006 03:42:17 GMT

hi sudesh,

if your hpsimdb is running on a microsoft sql server you can use "sql server manager" zu access the database or you can use odbc to access it (perl/odbc or any other).

have a nice day
t.

Re: Accessing SIM DB

sudesh_5 — Wed, 29 Mar 2006 04:24:37 GMT

Hi ,

Thank you for the reply .
In my case , SIM is installed on HP-UX and its using the postgres , which is a default db installed with HP SIM .
I want to access this DB and execute my own queries . Is this possible ?.

Re: Accessing SIM DB

topuli — Wed, 29 Mar 2006 05:26:24 GMT

there is an odbc driver available under
http://pgfoundry.org/projects/psqlodbc/

and there is a free graphical interface under
http://ns.flex.ro/pgaccess/

Re: Accessing SIM DB

sudesh_5 — Wed, 29 Mar 2006 06:25:08 GMT

Hi ,

Thanks a lot . Now I am able to connect to the SIM DB through command prompt . SIM DB is postgres running on HP-UX , which I wish to access from Win XP .
The link which you have provided is very infomative and right to target for what I was searching .
Wondering is it possible to use pgaccess to connect to postgres running on HP-UX .

Regards
Sudesh

Re: Accessing SIM DB

topuli — Wed, 29 Mar 2006 07:28:47 GMT

it should be possible, but you have to compile the unix sources on your hp-ux machine; this can be trcky sometimes ;)