Re: 'MSDAORA' was unable to begin a distributed transaction - why?! (SQL <-> Oracle)

I would want my Oracle client version on the SQL Server box to match
the target Oracle database version if possible. The Oracle clients are
free and available for download off technet: http://otn.oracle.com.

Does the Oracle username (ID) being used in the linked database
definition have the delete object privilege for the table in question?
And whose security context does the linked database run in?

HTH -- Mark D Powell --

.

Relevant Pages

  • Re: Read from database, write to another database, simultaneously
    ... interacting with the database not streaming large quantities from one ... All you need is a simple way to pipe the output from Oracle into ... Just run the oracle client and start dumping to the ...
    (comp.lang.python)
  • MSDAORA connection from Excel macro
    ... a connection to an Oracle database. ... Looking on the Internet I have found that this users the "Microsoft OLE DB ... and if you use oracle's advanced security on the oracle client to ...
    (microsoft.public.data.oledb)
  • Re: tnsnames not working. tnsping picks sqlnet.ora
    ... My oracle client has been working fine till today. ... I triend to tnsping the new database and any other old database and I ... configuration assistant) to add the entry again. ...
    (comp.databases.oracle.misc)
  • RE: ADO and Oracle Serwer problem
    ... > I've started using ADO technology ana Visual C++ compilator. ... > Provider for ADO to Access to Database. ... > read documentation for OleDBC I find out, that I must install Oracle Client ...
    (microsoft.public.data.ado)
  • Re: Oracle Client for 32 bit and 64 bit coexist
    ... programs on x64 Windows require Oracle client for 64 bit installed. ... Oracle client on the same server so that different programs could talk ... The application should not run on the same server as the database. ... On an app where I tested this, ...
    (comp.databases.oracle.misc)