Message-ID: <388FC835.F64ACB6F@home.com>
Date: Wed, 26 Jan 2000 23:23:17 -0500
From: Byron Nikolaidis <byron.nikolaidis@home.com>
Organization: @Home Network
MIME-Version: 1.0
To: Robert Lintner <rlintner@etm.co.at>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] SQLStatistics problem
References: <00Jan26.115034cet.115201@fwetm.etm.at>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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