Thread: PgSQL 7.1 beta 3 breaks ODBC

Josh Berkus (josh@agliodbs.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
PgSQL 7.1 beta 3 breaks ODBC

Long Description
I'm running:
Postgres 7.1 beta 3 on SuSE Linux 7.0
on the server, and

Windows 98 O.E.
MS Access 97 SR 2a
MDAC 2.5 and DCOM 98
Postgres ODBC 6.50.00
on two workstations.

Postgres ODBC, whcih workes fine when the Postgres server runs 7.0.3, does not work when the server runs 7.1 beta 3.
Specifically,with 7.1 running, I can connect to the server using Postgres ODBC, but I can't browse (and thus can't
connectto) any tables.  The table list comes up blank. 

-Josh Berkus

P.S. The ##DELETED problem mentioned by another user is a Microsoft ODBC problem, and not isolated to Postgres.


Sample Code


No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> Windows 98 O.E.
> MS Access 97 SR 2a
> MDAC 2.5 and DCOM 98
> Postgres ODBC 6.50.00
  ^^^^^^^^^^^^^^^^^^^^^
> on two workstations.

> Postgres ODBC, whcih workes fine when the Postgres server runs 7.0.3,
> does not work when the server runs 7.1 beta 3.

Try it with the beta version's ODBC driver ...

            regards, tom lane

>> Try it with the beta version's ODBC driver ...

>         How do I get it?  I looked through the Development
> version FTP filetree, and can't find the ODBC driver
> anywhere.  Link ... pretty please?  <flutter eyelashes>

Darn if I know, I don't do Windows.  Dave Page might have
a precompiled .dll available.

            regards, tom lane

Tom,

        Thanks for the quick response.

> Try it with the beta version's ODBC driver ...

        How do I get it?  I looked through the Development
version FTP filetree, and can't find the ODBC driver
anywhere.  Link ... pretty please?  <flutter eyelashes>

         Second, I've also discovered that Postgres ODBC
6.50 and Microsoft's MDAC 2.5 are incompatible ... making it
hard to connect from the same workstation to both Postgres
and MS SQL Server servers.  However, I don't know that you
can do anything other than post an advisory on this;
Microsith is hardly going to give us their proprietary code
so that we can make compatible drivers.  :-(

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco