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

My application is written in C#, and I already use the OLE DB provider.

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


<peregenem@xxxxxxxxxxxx> escribió en el mensaje
news:1126731124.143180.213810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> Francisco Garcia wrote:
>> I get a "Syntax error in CONSTRAINT
>> clause", and the DELETE word is automatically selected
>
> You may need to execute it via the OLE DB provider e.g. in Access2000
> VBA use
>
> CurrentProject.Connection.Execute "ALTER TABLE ..."
>


.

Relevant Pages

  • Re: MultiThreading against a Procedure
    ... In the SQL Server provider? ... I'm really beginning to wonder if there's a bug in the provider. ... You should not have to rebuild or dispose of the Command objects between ... I can't change the procedure to just execute from '1/1/2001' to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Silly Question - SQL conn.execute
    ... There are two versions of the Execute command. ... Long value that indicates how the provider should evaluate the CommandText ... construct a recordset object because the query being executed will not ...
    (microsoft.public.inetserver.asp.general)
  • Re: XP_CmdShell and OLE provider
    ... If I execute the below line in SQL Query Analyzer, ... I am not finding the one I installed: "Microsoft OLE DB Provider for Visual ...
    (borland.public.delphi.database.ado)
  • Re: XP_CmdShell and OLE provider
    ... If I execute the below line in SQL Query Analyzer, ... I am not finding the one I installed: "Microsoft OLE DB Provider for Visual ... Does anyone know how we can make SQL Server aware of the newly installed OLE ...
    (microsoft.public.data.ado)
  • 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)
Loading