Re: ADOX question

Thanks Steffen.

I just used another method. I created a stored procedure with params and called it from the application.

Regards,
Daniel

"Steffen Ramlow" <s.ramlow_at_gmx.de> schrieb im Newsbeitrag news:a2gpke$10uvqd$1_at_ID-54600.news.dfncis.de...
> well - if the driver does not support this operation then it does not
> support it. period.
> so u need another driver or another solution
>
> what adox can do via an ole/db provider u can do via direct ddl too -
maybe
> even with the same syntax for all ur databases
>
> its always
>
> create table bla (
> ...
> )
>
> maybe ur datatypes r different, just use variables 4 em
>
>
> "Daniel Secci" <daniel.secci_at_kriko.com> wrote in message
> news:a2ghsf$62b$1_at_news.magnet.ch...
> > Thanks Steffen.
> >
> > The problem is I have to write an application which works with several
> > DBMS (mainly SQL Server / Oracle and Access). I have to dynamically
> > create tables, that's why I use ADOX. The piece of code works with
> > SQL Server but not with Oracle. I really have to find a way...
> >
> > Daniel
> >
> > "Steffen Ramlow" <s.ramlow_at_gmx.de> schrieb im Newsbeitrag
> > news:a2c2j2$1070e9$1_at_ID-54600.news.dfncis.de...
> > > not all providers must support all methods, the error says that the
> > provider
> > > cannot do this
> > > u can "ask" the provider if it provides a method (dunno the calls now)
> > >
> > > btw.: i would never manage DB structure via ADOX...
> > >
> > > better use native sql
> > >
> > > p.s.
> > >
> > > c++ is sick :-)
> > >
> > >
> > > "Daniel Secci" <daniel.secci_at_kriko.com> wrote in message
> > > news:a29h3r$b40$1_at_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 Mon Jan 21 2002 - 05:11:41 CST