Post reply

Problems with INSERT..EXEC to Linked Sybase server

  • February 20, 2004 at 11:17 am

    #359117

    When attempting to use INSERT #Temp EXEC SybaseServer...MyStoredProc I get: (see reply - forum not working)

  • February 20, 2004 at 11:22 am

    #494981

    Server: Msg 7391, Level 16, State 1, Line 2 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. I'm using the ODBC driver for Sybase, the system is 11.9.2. I saw somewhere on Google that there is an OLEDB driver available for Sybase system 12, and it is supposed to help with this (working with MSDTC). Does anyone have experience in using the Sybase OLEDB driver? Can it work with 11.9.2 also? (I really hate the way the forum is forcing me to enter this post into a single scrolling line. What's going on????)

Viewing 2 posts - 1 through 1 (of 1 total)

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