Re: Query to add Foreign Key constraint to existing tables?


Francisco Garcia wrote:
> My application is written in C#, and I already use the OLE DB provider.

Which one? With Microsoft.Jet.OLEDB.4.0 it should work even for a Jet
3.51 file format but with Microsoft.Jet.OLEDB.3.51 it will fail.

> I've also tried to execute the command from within Access 2000, but it
> doesn't work either...

But did you use Microsoft.Jet.OLEDB.4.0 ...?

.

Relevant Pages

  • Re: OleDbConnection
    ... > An OLE DB Provider was not specified in the ConnectionString. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: how to reinstall Oracle provider for OLE DB?
    ... Thanks, i just had to find the oracle installer, deinstall and reinstall the ... OLE DB provider ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Cant edit Linked Server General Properties after saving
    ... source", etc properties can always be modified for any OLE DB Provider, ... recreating the linked server), you shoud try creating a linked server ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)
  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.data.oledb)