From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000707 ] SQLTables SQL_ALL_SCHEMAS duplicate schema names |
Date: | 2006-12-06 16:42:09 |
Message-ID: | 20061206164209.C6223216E91@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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. Should return 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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-12-06 16:42:47 | [ psqlodbc-Bugs-1000706 ] SQLTables SQL_ALL_TABLE_TYPES return code 100 |
Previous Message | noreply | 2006-12-06 16:41:38 | [ psqlodbc-Bugs-1000796 ] client encoding mismatch using ANSI driver with ANSI app |