[ psqlodbc-Bugs-1000707 ] SQLTables SQL_ALL_SCHEMAS duplicate schema names

Bugs item #1000707, was opened at 2006-08-14 21:10
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000707&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Hiroshi Inoue (hinoue)
Summary: SQLTables SQL_ALL_SCHEMAS  duplicate schema names

Initial Comment:
Executing SQLTables with SQL_ALL_SCHEMAS tabletype parameter the resultset has repeating/duplicate schema names.
Shouldreturn one row for each schema in the database 

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2006-12-04 16:39

Message:
This now works. Also [#1000706] works.  Thanks.

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-04 03:31

Message:
Please try the attached dll.
Please try it for [#1000706] also.

regards,
Hiroshi Inoue

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2006-12-01 13:59

Message:
I am calling SQLTables:

    rc = ::SQLTables( pSQL->Gethstmt(),
                     ( SQLCHAR * )   "", //szTableCat,
                     ( SQLSMALLINT ) 0, //cbTableCat,
                     ( SQLCHAR * )   "%", // SQL_ALL_SCHEMAS
szTableSchem,
                     ( SQLSMALLINT ) 1, //cbTableSchem,
                     ( SQLCHAR * )   "", //szTableName,
                     ( SQLSMALLINT ) 0, //cbTableName,
                     ( SQLCHAR * )   "", //szTableType,
                     ( SQLSMALLINT ) 0 /*cbTableType*/ );

return code is 0, but then you get SQL_NO_DATA_FOUND when
fetching the resultset rows

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-01 06:56

Message:
How are you calling SQLGetInfo concretely ?

regards,
Hiroshi Inoue

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2006-12-01 05:08

Message:
Driver 8.02.02.00 Now returns no rows at all

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-08-19 00:30

Message:
Please try the dll at
 http://www.geocities.jp/inocchichichi/psqlodbc/index.html .

regards,
Hiroshi Inoue

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000707&group_id=1000125