From: Robert Lintner <rlintner@etm.co.at>
To: pgsql-interfaces@postgresql.org
Subject: SQLStatistics problem
Date: Wed, 26 Jan 2000 11:50:34 +0100
Message-ID: <00Jan26.115034cet.115201@fwetm.etm.at> (raw)
Hi,
i've got a problem with ODBC command SQLStatistics ( and SQLColumns).
I am using PostgreSQL Driver v06-40-0006 und postgresql 6.5.3
I try to retrive some table informations with
sqlRet = SQLStatistics(
statment_handle,
0L, 0, // All catalogs
0L, 0, // All schemas
(SQLTCHAR *) tableName, strlen(tableName),
SQL_INDEX_ALL,
SQL_QUICK ); // table
and get sqlRet == SQL_ERROR (-1)
When I try to get errror information with
ret = SQLGetDiagRec( SQL_HANDLE_STMT
, statment_handle
, 1
, Sqlstate
,&NativeError
, MessageText
, 512
,&TextLengthPtr );
I've got ret == SQL_NO_DATA and no error information :-(
The same statements work with Oracle and M$-Access ODBC-Driver correctly.
Is this feature not supported ?
or do I have to use it in a differnt way ?
Thanks in advance
Robert
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rlintner@etm.co.at
Subject: Re: SQLStatistics problem
In-Reply-To: <00Jan26.115034cet.115201@fwetm.etm.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox