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

SQLTables (Windows/libodbc++)

From: Aris Basic <aris(dot)basic(at)silencesoftware(dot)com>
To: psql-odbc(at)postgresql(dot)org
Subject: SQLTables (Windows/libodbc++)
Date: 2004-05-10 16:13:49
Message-ID: 200405101213.50890.aris.basic@silencesoftware.com (view raw or flat)
Thread:
Lists: pgsql-odbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

Im trying to port an application that is wokring with interbase and oracle so 
we can use postgresql as well

however libodbc++ that this application is using is trying to discover the 
tables in dataabse
by using SQLTables call

the call look like its completing correctly however the columns application 
expects in the results set are not there
TABLE_CAT is the first column that this discovery piece wants and it doesnt 
see it in results.

TABLE_SCHEM, TABLE_TYPE, TABLE_NAME are the other ones to which im not comming 
because it fails on TABLE_CAT.

any idea what the problem is or is pgsql not supporting.
im using this with postgres 7.4.2 for cygwin/Windows with i think lates pgodbc 
drivers.

Aris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAn6o+SxHd9YgswYMRAnwuAJ91v8S0xj8QgZ0jAlD9TGFVtyjttQCfXQj8
vHg6SroW0H6bBkuf041mHn8=
=z9vp
-----END PGP SIGNATURE-----

pgsql-odbc by date

Next:From: Peter L.Date: 2004-05-10 17:24:24
Subject: Errors while retrieving text field
Previous:From: Sydney DelieuDate: 2004-05-10 10:00:10
Subject: Re: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL

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