Thread: 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 ODBCHi Dave,What is a problem for this odbc driver?
The new Redhat compiler (GCC) has a very long version string which overflows a buffer in the ODBC driver. I fixed it in the snapshot, and am looking to release it properly before we then do a pgAdmin release.
Regards, Dave.
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.