ADOX question

From: Daniel Secci <daniel.secci_at_kriko.com>
Date: Fri, 18 Jan 2002 17:15:00 +0100
Message-ID: <a29h3r$b40$1@news.magnet.ch>

Hi all,

Did someone already manage to create a table with primary key using ADOX and OraOLEDB Provider ?

The following code doesn't work (but does with SQL Server) and throws me an exception (the table is created without the PKey :

---

// create new table

TESTHR(table.CreateInstance(__uuidof(ADOX::Table)));

table->PutName((LPCTSTR)(_bstr_t) newTable.bstrVal);
table->Columns->Append("DATUM", ADOX::adDBTimeStamp, 0);
table->Columns->Append("ZEIT", ADOX::adChar, 10);

sprintf(pkName, "PK_%s", (LPCTSTR)(_bstr_t) newTable.bstrVal);
// create new primary key

TESTHR(key.CreateInstance(__uuidof(ADOX::Index)));

key->Name = pkName;
key->Columns->Append("DATUM", ADOX::adDBTimeStamp, 0);
key->Columns->Append("ZEIT", ADOX::adChar, 10);
key->PutPrimaryKey(-1);
key->PutUnique(-1);
key->PutIndexNulls(ADOX::adIndexNullsDisallow);

table->Indexes->Append(_variant_t((IDispatch*) key));
// add table

catalog->Tables->Append(_variant_t((IDispatch *) table));

---

Exception thrown :

---

Error by adding table TAB1 : Object or provider is not capable of performing requested operation.
Error number 800a0cb3 : Unknown error 0x800A0CB3

---

Thanks,
Daniel Received on Fri Jan 18 2002 - 10:15:00 CST