SQLStatistics problem

From: "Robert Lintner" <rlintner(at)etm(dot)co(dot)at>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: SQLStatistics problem
Date: 2000-01-25 15:28:21
Message-ID: 00Jan25.162822cet.115202@fwetm.etm.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ken J. Wright 2000-01-25 15:55:05 Re: [INTERFACES] Re: ODBC drive strange behavior
Previous Message Jose Soares 2000-01-25 15:18:25 Re: [INTERFACES] Re: ODBC drive strange behavior