executinga sp using linked server gives an error

anonymous_at_discussions.microsoft.com
Date: 04/07/04 

Date: Wed, 7 Apr 2004 12:13:58 -0700

Linked servers are connected using following syntax..
EXECUTE [test].databasename.dba.PickupWeight_SP
>-----Original Message-----
>I get the following error when I tried to execute a sp
using linked server(test) as follows:
>
>BEGIN DISTRIBUTED TRANSACTION
>EXECUTE test..dba.PickupWeight_SP
>COMMIT TRAN
>GO
>
>I checked the box on the server to allow distributed
transactions(MTS). Any help would be appreciated.
>
>Server: Msg 7391, Level 16, State 1, Line 2
>The operation could not be performed because the OLE DB
provider 'MSDASQL' does not support distributed
transactions.
>[OLE/DB provider returned message: [Sybase][ODBC Driver]
Driver not capable]
>.
>

Relevant Pages

  • SYSREMOTE_PRMARY_KEYS
    ... I have some linked servers; i execute a local stored procedure;in this ... transaction; but in a SYSREMOTE_PRIMARY_KEYS ... can not start distributed transaction! ...
    (microsoft.public.sqlserver.server)
  • Re: Creating a Trigger which updates a linked server
    ... BEGIN DISTRIBUTED TRANSACTION ... INSERT INTO LNK_SRVDB.MY_BASE.DBO.TABLE_TEST VALUES('TOTO','TEST TOTO') ... > So i can use select command, execute store procedure, update, insert> and any command to read,update or write data. ... > I said Coool :-) I could put arrival data from one database to the> other database by using a trigger!!! ...
    (microsoft.public.sqlserver.programming)
  • Re: Passing Parameters through a linked server?
    ... Are you able to execute this without linked servers in picture? ... > @ID int OUTPUT ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Linked Server : SQL Server 2000
    ... Is the Distributed Transaction Coordinator running? ... A discussion of linked servers can be found in the article "Linked Servers ...
    (microsoft.public.sqlserver.security)
  • executinga sp using linked server gives an error
    ... I get the following error when I tried to execute a sp using linked serveras follows: ... BEGIN DISTRIBUTED TRANSACTION ... COMMIT TRAN ... The operation could not be performed because the OLE DB provider 'MSDASQL' does not support distributed transactions. ...
    (microsoft.public.sqlserver.programming)