Would you submit a patch against the ODBC sources to fix this? Thanks. ---------------------------------------------------------------------------
Farid Zidan wrote: > > The following bug has been logged online: > > Bug reference: 1422 > Logged by: Farid Zidan > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: Windows 20000 > Description: ODBC SQLTables SQL_ALL_TABLE_TYPES no resultset > Details: > > ::SQLTables( hstmt, > ( SQLCHAR * ) "", // szTableCat, > ( SQLSMALLINT ) 0, //cbTableCat, > ( SQLCHAR * ) "", //szTableSchem, > ( SQLSMALLINT ) 0, //cbTableSchem, > ( SQLCHAR * ) "", //szTableName, > ( SQLSMALLINT ) 0, //cbTableName, > ( SQLCHAR * ) SQL_ALL_TABLE_TYPES, //szTableType, > ( SQLSMALLINT ) sizeof( SQL_ALL_TABLE_TYPES) ); > > get result code 100 ( SQL_NO_DATA_FOUND ) > > ODBC documentation for SQLTables: > If TableType is SQL_ALL_TABLE_TYPES and CatalogName, SchemaName, and > TableName are empty strings, the result set contains a list of valid table > types for the data source. (All columns except the TABLE_TYPE column contain > NULLs.) > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
