Post reply

Linked SErver

  • April 5, 2004 at 12:56 pm

    #101948

    How do you do an update, insert, delete statement using a linked server connection from sql2000 to an oracle9i database? 

    I am able to query, join tables, and run a DTS from sql to oracle successfully.

  • April 5, 2004 at 1:29 pm

    #501797

    have you tried

    delete from openquery(linkedserver, statement)

    ??


    Shamless self promotion - read my blog http://sirsql.net

  • April 6, 2004 at 6:20 am

    #501849

    You may also try using four-part naming.  Four-part names are linked-server-name, catalog, schema, and table.  Would look something like this:

    insert into ORACLE9i_DB.DBO.SCHEMA_NAME.TABLE_NAME values (....)

    Hope this helps

  • April 7, 2004 at 8:12 am

    #502000

    It worked.  Thank you so much.

  • April 12, 2004 at 12:35 pm

    #502455

     I need to find a way to execute a procedure stored in an Oracle database using a DTS package in SQL Server 2000.  I can query, insert, and update using a linked server, but I need to be able to run a remote procedure also

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply