Re: Visual FoxPro OLE DB Provider error 0x80040e46 (Unknown)

Unfortunately, I don't have enough expertise with C++ or ADOX to help you
further.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com


"Jan Horník" <NO_SPAMJHR_hornik@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23IoZizdQGHA.6084@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
Thanks for your reply.
I created table before that with SQL, but I need one way to create tables
and insert data to Paradox, Sql server, Oracle, Excel, Acess, Text tables
... . the SQL syntax depends on nationale and providers. We need computing
program to China, Italy, Portugal, ... and SQL syntax is troublesome.

"Cindy Winegarden" <CindyWinegarden@xxxxxxxxxxxxxxxx> pí¹e v diskusním
pøíspìvku news:%23SQhEquPGHA.2256@xxxxxxxxxxxxxxxxxxxxxxx
Hi Jan,

Have you tried creating a table with the standard SQL Create Table
statement? Have you tried creating a table that does not have any
nullable columns?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com


"Jan Horník" <NO_SPAMJHR_hornik@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OyqvzhcPGHA.1360@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
thanks for your reply.
I downloaded and installed Microsoft OLE DB Provider for Visual FoxPro
9.0 SP1. Table was created as part of database container :
Connection string : _T("Provider=VFPOLEDB;Data
Source=c:\\MyDb.dbc;Mode=ReadWrite|Share Deny None;Password=;Collating
Sequence=general;");
pCatalog->Create(sSql.AllocSysString());
table is created :
CString strTableName;
strTableName = _T("MyDb.dbf");
pTable->Name = strTableName.AllocSysString();
pTable->ParentCatalog = pCatalog;
strTableField[0] = _T("Index");
pTable->GetColumns()->Append(strTableField[0].AllocSysString(),adox::adInteger,0);
pTable->GetColumns()->GetItem(_variant_t(strTableField[0].AllocSysString()))->Attributes
= adox::adColNullable; ...






.

Relevant Pages