Re: delete sql syntax for linked notes table

Yes, I dont think I can use this syntax.

select * from [Notes_DRS_CaseName DEV].[CaseName].[dbo].[case_name]

delete from [Notes_DRS_CaseName DEV].[CaseName].[dbo].[case_name] where
CaseNum='PROD055344'

Returns:

Server: Msg 7312, Level 16, State 1, Line 1
Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A
four-part name was supplied, but the provider does not expose the
necessary interfaces to use a catalog and/or schema.
OLE DB error trace [Non-interface error].

.

Relevant Pages

  • Custom Provider Crystal Asking for wrong Table
    ... I'm writing my own OLE DB provider for use in Crystal Reports and other ... If I connect to my OLE DB Provider in Visual ... Studio it shows the schema correctly. ...
    (microsoft.public.data.oledb)
  • Re: delete sql syntax for linked notes table
    ... Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Custom Provider Crystal Asking for wrong Table
    ... Try setting the restriction in RowsetViewer and see if your provider ... > Try calling IDBSchemaRowset using the OLE DB Rowset Viewer. ... >> Studio it shows the schema correctly. ...
    (microsoft.public.data.oledb)
  • Linking to MySQL
    ... MySQL tables with no Schema Name ... Invalid schema or catalog specified for provider 'MSDASQL'. ...
    (microsoft.public.sqlserver.connect)
  • Linked server to Oracle
    ... I have setup a linked server to an oracle server. ... Invalid use of schema and/or catalog for OLE DB ... the provider does not expose the necessary interfaces to ...
    (microsoft.public.sqlserver.programming)