Re: RE: [ADMIN] ODBC connect in ERWin

You have set in your pgsql ODBC driver to open databases in readonly
mode. You should change it to do the 'forward engineer'.

Nelio

Niral Trivedi wrote:
>
> 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@street-light.com]
> Sent: Friday, January 12, 2001 6:11 PM
> To: Niral Trivedi
> Cc: pgsql-general@postgresql.org; pgsql-admin@postgresql.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

--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
+55 11 3365-5863
nelio@ifx.com.br