pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

SQLStatistics problem
3+ messages / 2 participants
[nested] [flat]

* SQLStatistics problem
@ 2000-01-25 15:28  Robert Lintner <rlintner@etm.co.at>
  0 siblings, 0 replies; 3+ messages in thread

From: Robert Lintner @ 2000-01-25 15:28 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* SQLStatistics problem
@ 2000-01-26 10:50  Robert Lintner <rlintner@etm.co.at>
  0 siblings, 1 reply; 3+ messages in thread

From: Robert Lintner @ 2000-01-26 10:50 UTC (permalink / raw)
  To: 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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] SQLStatistics problem
@ 2000-01-27 04:23  Byron Nikolaidis <byron.nikolaidis@home.com>
  parent: Robert Lintner <rlintner@etm.co.at>
  0 siblings, 0 replies; 3+ messages in thread

From: Byron Nikolaidis @ 2000-01-27 04:23 UTC (permalink / raw)
  To: Robert Lintner <rlintner@etm.co.at>; +Cc: pgsql-interfaces



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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2000-01-27 04:23 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-25 15:28 SQLStatistics problem Robert Lintner <rlintner@etm.co.at>
2000-01-26 10:50 SQLStatistics problem Robert Lintner <rlintner@etm.co.at>
2000-01-27 04:23 ` Byron Nikolaidis <byron.nikolaidis@home.com>

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