Re: delete and update operation on linked server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Kass (skass_at_drew.edu)
Date: 07/31/04


Date: Sat, 31 Jul 2004 01:06:05 -0400

Whether you can delete or update depends on the provider. You can in
some cases, and you may need a primary key on the table. If you have
tried and gotten an error message, post what you've tried and the exact
error message.

Steve Kass
Drew University

mak wrote:

>hi all
> can i perform delete ,update operations on linked server.
>i am able to select rows from linked server but how can i update or delete rows which r thre in linked server suppose say(oracle8i).
>any help on this
>
>TIA
>mak.
>
>



Relevant Pages

  • The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
    ... While trying to access a linked server, I'm getting the error message: ... The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. ...
    (microsoft.public.sqlserver.setup)
  • Re: Linked server to as400 - for the love of god please help.
    ... > There is an ODBC DSN on the server machine. ... Creating a linked server using ... > OLE DB provider 'MSDASQL' reported an error. ... > So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)
  • RE: Problems with ACE OLEDB provider
    ... Excel sheets created as linked servers from SQL Server via the ACE ... OLEDB provider version 12 fail on table updates. ... I have this worksheet defined as a linked server in SQL Server via this ...
    (microsoft.public.excel.programming)
  • Re: Linked server from SQL Server to Access db on network share?
    ... What it looks like is this: SQL can create a linked server to a file on a remote share, but you can't query against it using Query Analyzer from any system other than the one hosting SQL... ... EXEC sp_tables_ex 'OLDSQL' ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
    (microsoft.public.sqlserver.msde)
  • Re: Errors in connecting Visual Fox Pro as linked server in 2005 - HEL
    ... Here's what works for me in SQL 2005 using the Linked Server dialog: ... Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro ... It turns out that MDAC 2.8 SP2 for Windows Server ...
    (microsoft.public.sqlserver.connect)