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