Обсуждение: Installation problem with psqlodbc-08_00_0100.zip

I'm trying to install the latest psqlodbc-08_00_0100.zip to connect Access to
PostgreSQL 8.0 running on OpoenBSD.

I've download and installed the MSI installer package.  The installer
successfully finishes, but when I go to the ODBC Data Source, I don't see a
Postgresql driver anywhere.  I've tried on Windows 2000 server and on Windows
XP.

Because I need to connect to PostgreSQL with Access, I uninstalled the version 8
driver and re-installed the version 07_03_0200 driver which used to work on both
machines.  This older driver works fine on the Windows 2000 machine but it now
will not work on the XP machine by failing to connect to the database.

My PostgreSQL logs do not even show a connection attempt, until I click out of
the two error message thrown up by Access.  Then it apparently connects, runs
the first query (table view) and exits.

I'd rather get the newest version working, so if anyone knows how I can get the
ODBC driver available to Access through the ODBC control panel I'll be
delighted.

Failing that, getting the 07_03_0200 driver to connect would be great.

Thanks,

Jeff Ross

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of jross@wykids.org
> Sent: 04 March 2005 23:43
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Installation problem with psqlodbc-08_00_0100.zip
>
> I've download and installed the MSI installer package.  The installer
> successfully finishes, but when I go to the ODBC Data Source,
> I don't see a
> Postgresql driver anywhere.  I've tried on Windows 2000
> server and on Windows
> XP.

Ack, sorry - bug in the new installer. I've just uploaded 08.00.0101 (to
ftp.postgresql.org) which corrects this - it'll take a day or so to
reach the mirrors.

Please let me know if it works asap as I intend to unsubscribe from this
list in the next couple of days and want to be sure the installer is OK
before I go...

Regards, Dave.

Quoting Dave Page <dpage@vale-housing.co.uk>:

>
>
>> -----Original Message-----
>> From: pgsql-odbc-owner@postgresql.org
>> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of jross@wykids.org
>> Sent: 04 March 2005 23:43
>> To: pgsql-odbc@postgresql.org
>> Subject: [ODBC] Installation problem with psqlodbc-08_00_0100.zip
>>
>> I've download and installed the MSI installer package.  The installer
>> successfully finishes, but when I go to the ODBC Data Source,
>> I don't see a
>> Postgresql driver anywhere.  I've tried on Windows 2000
>> server and on Windows
>> XP.
>
> Ack, sorry - bug in the new installer. I've just uploaded 08.00.0101 (to
> ftp.postgresql.org) which corrects this - it'll take a day or so to
> reach the mirrors.
>
> Please let me know if it works asap as I intend to unsubscribe from this
> list in the next couple of days and want to be sure the installer is OK
> before I go...
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
> !DSPAM:42299ff5323911244421408!
>
>


This fixed the installation problem.

I still can't connect to Access, though, but I reckon that's another thread.

Thanks for fixing the installer.

Jeff Ross