Thread

1. PgSQL 7.1 beta 3 breaks ODBC

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-02-13T17:32:53Z

   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 connect to) 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
   
   
   

2. Re: PgSQL 7.1 beta 3 breaks ODBC

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-02-13T23:39:36Z

   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
   
   

3. Re: PgSQL 7.1 beta 3 breaks ODBC

   Josh Berkus <josh@agliodbs.com> — 2001-02-14T00:09:30Z

   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
   
   

4. Re: PgSQL 7.1 beta 3 breaks ODBC

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-02-14T00:12:56Z

   >> 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