Обсуждение: 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