Re: [INTERFACES] SQLStatistics problem

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