Remote stored procedure

From: nivek (eckart_612_at_hotmail.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 10:12:03 -0600

I am trying to run a stored procedure on a remote server and insert the
output into a table on the local machine.

The two servers are linked and I am using the code as follows

BEGIN DISTRIBUTED TRAN
insert into ServerA.Database.dbo.drv_total
exec ServerB.master.dbo.xp_fixeddrives

COMMIT TRAN

The MSDTC is started on both machines.

I am getting this error:

Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]

Any thoughts?

TIA,
nivek

Relevant Pages

  • Copy Project Help Needed
    ... on my local machine using my local IIS. ... I now want to upload or copy this to a remote server. ... When using frontPage as the web access method, ... "Unable to create Web project 'ABC'. ...
    (microsoft.public.dotnet.faqs)
  • Copy Project
    ... located on my local machine using my local IIS. ... I now want to upload or copy this to a remote server. ... When using frontPage as the web access method, ... "Unable to create Web project 'ABC'. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Using ASP.NET Configuration Tool Remotely?
    ... I have never been able to get the Asp.net configuration web application to ... work on a remote server. ... It's really designed only for local machine ... You can also write your own "admin" app that performs a lot of these ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Need a script spanning two servers suggestion.
    ... > What i'm thinkin of is having all the work done on the local machine. ... If it's MySQL it easy to ... > get this done...once u have the necessary rights on the remote machine. ... I think the mySQL database on the remote server is called "localhost," ...
    (comp.lang.php)
  • Re: [PHP] Connection error on URI
    ... I'm working on someone else's code that tries to read an XML transaction ... from a remote server with the following code. ... "Some men are born to greatness, some achieve greatness, ...
    (php.general)