Thread: ODBC connect in ERWin

ODBC connect in ERWin

From
Niral Trivedi
Date:
All,

Yesterday, I have seen some postings regarding connecting to Remote
PostgreSQL DB using ERWin. And I am having similar question here.

We have PostgreSQL DB on UNIX box. And it is running fine without any
problem. Now, I have ERWin and PostgreSQL ODBC driver from Insight Dist
installed on my local WinNT machine.

Now, I have created a sample reverse engineered an access DB using 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:

host    niral   MY_IP_ADDR   MASKING_ADDR   password
test_niral_users.dat

I have also checked out the 'greatbridge.com' site but couldn't find any
solutions.

So, if anybody has any idea, please help me..

Thanks in advance...

Niral

Re: [ADMIN] ODBC connect in ERWin

From
Warren Vanichuk
Date:
> 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


Re: ODBC connect in ERWin

From
Ed Loehr
Date:
Not sure about your pg_hba/ODBC setup, but ERwin takes pg_dump output in
as Ingres 1.x script and does pretty well (of course, it doesn't
recognize PL/pgSQL, etc), maybe with a few minor tweaks.  I didn't have
any RI in my dump, so I wrote a perl script to add it so that I'd get the
relationships (I had hundreds of tables and a very standardized naming
convention), but I think it can infer from indices or names in some
manner.

Regards,
Ed Loehr


Niral Trivedi wrote:
>
> All,
>
> Yesterday, I have seen some postings regarding connecting to Remote
> PostgreSQL DB using ERWin. And I am having similar question here.
>
> We have PostgreSQL DB on UNIX box. And it is running fine without any
> problem. Now, I have ERWin and PostgreSQL ODBC driver from Insight Dist
> installed on my local WinNT machine.
>
> Now, I have created a sample reverse engineered an access DB using 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:
>
> host    niral   MY_IP_ADDR   MASKING_ADDR   password
> test_niral_users.dat
>
> I have also checked out the 'greatbridge.com' site but couldn't find any
> solutions.
>
> So, if anybody has any idea, please help me..
>
> Thanks in advance...
>
> Niral

Re: Re: [ADMIN] ODBC connect in ERWin

From
Ed Loehr
Date:
> > 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'

Oh, and I do recognize those error messages as the same that occur when
you are configured for SSH port forwarding but forgot to connect the SSH
session first.

Regards,
Ed Loehr

Re: Re: [ADMIN] ODBC connect in ERWin

From
"rob"
Date:
I'm going to ask the obvious, but  . . .

Can you ping the Unix box from the ER workstation?

Did you start the postmaster with -i to allow remote connections?

Does the same ODBC DSN  work from another program? (i.e. linking a Pg table
to an Access DB)


--rob

----- Original Message -----
From: "Ed Loehr" <eloehr@austin.rr.com>
Cc: "Niral Trivedi" <niral.trivedi@insage.com>;
<pgsql-general@postgresql.org>; <pgsql-admin@postgresql.org>
Sent: Friday, January 12, 2001 7:13 PM
Subject: Re: 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'
>
> Oh, and I do recognize those error messages as the same that occur when
> you are configured for SSH port forwarding but forgot to connect the SSH
> session first.
>
> Regards,
> Ed Loehr
>