RE: ODBC connect in ERWin

All,

Thank you all for your response to my previous post. And You were right. I
had now our postgreSQL started with -i option and I am able to connect to it
from my local NT machine.

But now I am getting another problem.. When I go for 'Forward Engineer' the
current physical model, I am getting following error:

Connection is readonly, only select statements are allowed.;
Unrecognized key passed to SQLGetInfo.
Execution Failed!

I have tried to connect using the postgres superuser as well. But no luck. I
have also tried to change my 'pg_hba.conf' file to allow connection as
'trust' so anybody can connect from the specified IP address. But still
getting the same error.

Anybody has any idea??

Thanks again for your continuing support.

Niral

-----Original Message-----
From: Warren Vanichuk [mailto:pyber(at)street-light(dot)com]
Sent: Friday, January 12, 2001 6:11 PM
To: Niral Trivedi
Cc: pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] ODBC connect in ERWin

> But When I am trying to forward engineer that to my Remote PostgreSQL db I
> am getting ODBC error saying:
> 'Could not connect to the Server'
> 'Could not connect to remote socket'
>
> Now, I have already added 'host' line in 'pg_hba.conf' file to give access
> to the db from my machine as follows:

Have you added the -i option to the postmaster startup to tell it to use
TCP/IP sockets, rather than just the local sockets it sets up by default?

See: http://www.postgresql.org/docs/faq-english.html#3.7

Sincerely, Warren