Accessing SIM DB

[sudesh_5]

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

[topuli]

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.

[sudesh_5]

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 ?.

[topuli]

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/

[sudesh_5]

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

[topuli]

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