ODBC and Frontpage2000 - Mailing list pgsql-odbc

From David Horwitz
Subject ODBC and Frontpage2000
Date
Msg-id 3B668E19.BF84FA66@ched.uct.ac.za
Whole thread Raw
List pgsql-odbc
Ok first I'm using psqlodbc-07_01_0005 on a WindowsNT4 running IIS4 and
the
frontpage2000 server extensions to connect to a PSql Db ver. 7.0.2
running on a
Linux box (RedHat 7.01)

When using the frontPage wizards to generate a ASP page the ASP wizard
doesn't
return an error but is unable to read the table/query structure (ie it
seems to
believe the query contains no columns).

M$ seem to have documented the error as it relates to SQL server6.5 and
they
have a fix/workaround:
http://support.microsoft.com/support/kb/articles/Q229/2/85.ASP

Essentially they seem to have a patch (INSTCAT.SQL) that needs to be run
on the
server to enable the ODBC driver to return the correct info. its
documented
here:
http://support.microsoft.com/support/kb/articles/Q137/6/36.ASP

IS there any way of fixing/working around this in Postgres

Thanks

David Horwitz
        pgsql-odbc@postgresql.org

--
****************************************************
David Horwitz                  University of Cape Town
IT Officer                     Private Bag
Multimedia Education Group     Rondebosch
                               7701
dhorwitz@ched.uct.ac.za        SOUTH AFRICA
Tel:+27 21 650 3841            Fax:+27 21 650 5045
http://www.meg.uct.ac.za
*************************************************



pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: S1002: Invalid column number in ColAttributes
Next
From: Jussi Jääskeläinen
Date:
Subject: Re: odbc and bit-field