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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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
*************************************************

Browse pgsql-odbc by date

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