Обсуждение: pgAdmin Crashes with ODBC

Hi,
I installed the latest version of the ODBC (7.2.5) and pgAdmin II
1.4.12. The  ODBC driver
has been configured in the Admin Tools / Data Sources under WinXP. Also
Postgres
ver. 7.3 (RH 9.0 rpm) is installed with ODBC driver enabled / installed.

Now, whenever I run the pgAdmin tool and try to connect to the DSN the
application crashes.
The same is true if I try to connect to the database via MS Excel XP.

I noticed the following on pgAdmin.

1. In the upgrade wizard, the ODBC drive is not listed as installed
2.In the connection debugging  tool,  in the ODBC tab I can find  and
select the Postgres  driver /source

Is there a probelm with the ODBC driver ?

I used older versions of the applications including postgres 7.2x in the
past and it worked.

Thanks for any help on that
Alex

> -----Original Message-----
> From: Alex Paulusberger [mailto:alexp@meta-bit.com]
> Sent: 08 May 2003 11:10
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] pgAdmin Crashes with ODBC
>
>
> Hi,
> I installed the latest version of the ODBC (7.2.5) and pgAdmin II
> 1.4.12. The  ODBC driver
> has been configured in the Admin Tools / Data Sources under
> WinXP. Also
> Postgres
> ver. 7.3 (RH 9.0 rpm) is installed with ODBC driver enabled /
> installed.
>
> Now, whenever I run the pgAdmin tool and try to connect to
> the DSN the
> application crashes.
> The same is true if I try to connect to the database via MS Excel XP.

Hi,

Please upgrade to the snapshot ODBC driver from
http://www.geocities.jp/inocchichichi/psqlodbc/. That should fix this
issue.

Regards, Dave.

-----Original Message-----
From: frank_lupo [mailto:frank_lupo@email.it]
Sent: 08 May 2003 13:21
To: Dave Page
Cc: alexp; pgadmin-support
Subject: Re: [pgadmin-support] pgAdmin Crashes with ODBC

 

Hi Dave,

 

What is a problem for this odbc driver?

 

Dave,
I installed the new dll and now the Admin Tool is able to connect to the
database. There are still two open issues.

A) when I try to connect to postgres via Excel, I get the error "unable
to obtain list of tables from data source"
B) minor issue; in the upgrade menu, the installed odbc drive still does
not show up.

Any ideas what the couse of the problem A) could be?

Will there be a new odbc driver release soon that fixes these problems
and is save to use in a production environment ?

Thanks and Regards
Alex

Dave Page wrote:

>
>
>>-----Original Message-----
>>From: Alex Paulusberger [mailto:alexp@meta-bit.com]
>>Sent: 08 May 2003 11:10
>>To: pgadmin-support@postgresql.org
>>Subject: [pgadmin-support] pgAdmin Crashes with ODBC
>>
>>
>>Hi,
>>I installed the latest version of the ODBC (7.2.5) and pgAdmin II
>>1.4.12. The  ODBC driver
>>has been configured in the Admin Tools / Data Sources under
>>WinXP. Also
>>Postgres
>>ver. 7.3 (RH 9.0 rpm) is installed with ODBC driver enabled /
>>installed.
>>
>>Now, whenever I run the pgAdmin tool and try to connect to
>>the DSN the
>>application crashes.
>>The same is true if I try to connect to the database via MS Excel XP.
>>
>>
>
>Hi,
>
>Please upgrade to the snapshot ODBC driver from
>http://www.geocities.jp/inocchichichi/psqlodbc/. That should fix this
>issue.
>
>Regards, Dave.
>
>
>
>

Hi Alex,

> -----Original Message-----
> From: Alex Paulusberger [mailto:alexp@meta-bit.com]
> Sent: 09 May 2003 06:07
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAdmin Crashes with ODBC
>
>
> Dave,
> I installed the new dll and now the Admin Tool is able to
> connect to the
> database. There are still two open issues.
>
> A) when I try to connect to postgres via Excel, I get the
> error "unable
> to obtain list of tables from data source"

That's somewhat outside the scope of the pgAdmin support list...

> B) minor issue; in the upgrade menu, the installed odbc drive
> still does
> not show up.

Even if you are connected to a database when you run the Upgrade Wizard?
If that's the case then there's something wrong. Do you have another
copy of the DLL around that might be being found first?

> Any ideas what the couse of the problem A) could be?

No, it works fine for me using Excel XP. I have pretty much default ODBC
settings...

> Will there be a new odbc driver release soon that fixes these
> problems
> and is save to use in a production environment ?

I hope to release a new version soon (he says with his PostgreSQL hat
on...).

Regards, Dave.