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

Hi Mark!
Actually, I'm not quite sure what driver am I useing for my linked
server. It just says "Microsoft OLE DB Provider for Oracle", so I
guessed it's the same driver mentioned in the ODBC portion of the
system settings. What would be the best way to find out that driver and
version the linked server is using?

Unfortunatelly, I can't replace the driver that easily as I'm not the
administrator of the server involved.

I'm performing read-only operations in Oracle only, so as far as I'm
concerned, I need no transactions at all (at least for the trigger
segment), but the answer your question - yes, I do have privileges to
update the records from the Oracle table, I guess I also have the
delete permissions but am afraid to try it out since it's the
procudtion enviroment on the Oracle side.
How do I find ou tin whose security context the linked server runs in?

.

Relevant Pages

  • Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... I posted this question in the .server newsgroup yesterday, but apparently my cross-post to this newsgroup didn't made it, so now I post it once more. ... I'm having some troubles setting up an Oracle datasource on a SSIS ... Since this Provider isn't available in the 64-bit version I ... I'd love to uninstall both Oracle clients and then try just to install ...
    (microsoft.public.sqlserver.dts)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... communicate back through IIS to SQL*NET installed for the Oracle Client. ... Microsoft SQL Server 2000 Standard with SP3a installed on same box. ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.iis)
  • Error initializing provider (Microsoft OLE DB provider for oracle)
    ... administrator account in win2k server. ... When Microsoft OLE DB Provider for Oracle is used as new data source ... it gives "An error in initializing provider. ...
    (microsoft.public.sqlserver.olap)
  • Re: Oracle Instant Client and DTS data transformation from Oracle
    ... it could find the drivers on the server. ... I've tried to use Oracle 10g Instant Client driver so I can transport data from Oracle to SQL Server without success so far. ... I was able to see the Oracle Instant Client driver, both from ODBC applets within Control Panel and DTS designer's data source; ... DTSRun: Executing... ...
    (microsoft.public.sqlserver.server)
  • 64-bit: Memory issue with Oracle Provider for OLE DB
    ... When executing "SELECT INTO" queries from linked Oracle servers using the ... Is there a OLE DB Provider for Windows 2003 ... Datacentre Server 64-bit ia64? ... Is there a fix for the memory leak on the ...
    (microsoft.public.data.oledb)