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
