Skip site navigation (1) Skip section navigation (2)

ODBC and Frontpage2000

From: David Horwitz <Dhorwitz(at)ched(dot)uct(dot)ac(dot)za>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC and Frontpage2000
Date: 2001-07-31 10:53:13
Message-ID: 3B668E19.BF84FA66@ched.uct.ac.za (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org

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



pgsql-odbc by date

Next:From: Jussi JääskeläinenDate: 2001-07-31 11:30:21
Subject: Re: odbc and bit-field
Previous:From: Hiroshi InoueDate: 2001-07-31 04:08:05
Subject: Re: S1002: Invalid column number in ColAttributes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group