Steffen Goeldner wrote: > > Attached are some results for the Oracle ODBC Driver 08.01.0704, > generated with MS ODBC Test 03.00.2301 (Odbcte32.exe). > > The last result is wrong: tst.c2 should not appear in the result set. > I created a TAR at Oracle MetaLink. They accepted it as a bug: > > BUG# 2008554 SQLFOREIGNKEY() BRINGS BACK WRONG RESULTS > > They'll fix that in the next release (8.1.7.5).
Oracle ODBC 8.1.7.5 is available and the bug is fixed. Steffen
Oracle ODBC Driver 08.01.0705 ----------------------------- SQLForeignKeys: In: StatementHandle = 0x008A1860, PkCatalogName = SQL_NULL_HANDLE, NameLength1 = 0 PkSchemaName = "TST" , NameLength2 = 3 PkTableName = "P1" , NameLength3 = 2 FkCatalogName = SQL_NULL_HANDLE, NameLength4 = 0 FkSchemaName = "TST" , NameLength5 = 3 FkTableName = "C1" , NameLength6 = 2 Return: SQL_SUCCESS=0 Get Data All: "PKTABLE_CAT", "PKTABLE_SCHEM", "PKTABLE_NAME", "PKCOLUMN_NAME", "FKTABLE_CAT", "FKTABLE_SCHEM", "FKTABLE_NAME", "FKCOLUMN_NAME", "KEY_SEQ", "UPDATE_RULE", "DELETE_RULE", "FK_NAME", "PK_NAME", "DEFERRABILITY" <Null>, "TST", "P1", "K1", <Null>, "TST", "C1", "K1", 1, <Null>, 3, "FK_C1", "PK_P1", <Null> <Null>, "TST", "P1", "K2", <Null>, "TST", "C1", "K2", 2, <Null>, 3, "FK_C1", "PK_P1", <Null> 2 rows fetched from 14 columns.