From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: Robert Lintner <rlintner@etm.co.at>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] SQLStatistics problem
Date: Wed, 26 Jan 2000 23:23:17 -0500
Message-ID: <388FC835.F64ACB6F@home.com> (raw)
References: <00Jan26.115034cet.115201@fwetm.etm.at>
Robert Lintner wrote:
>
> 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
>
> ************
I'm not sure how this 3.0 call gets translated to 2.5, but I would have
thought it would work. Is there any error in the driver's logfile.
Also, if you do a odbc trace you might see something.
Byron
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: byron.nikolaidis@home.com, rlintner@etm.co.at
Subject: Re: [INTERFACES] SQLStatistics problem
In-Reply-To: <388FC835.F64ACB6F@home.com>
* 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