Home Forums SQL Server 7,2000 T-SQL Problems with INSERT..EXEC to Linked Sybase server RE: Problems with INSERT..EXEC to Linked Sybase server

  • 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????)