Transoft Linked Server update

[mkell1]

I am hoping someone can possibly help me out. I have a linked server created that uses a Transoft ODBC Driver. I am able to run a select query against this linked server via Query Analyzer. However, when I attempt to run the following update query:

Update OPENQUERY(Unibol, 'Select * From EGV_FMA_REC1') SET MRDTE = 40928 WHERE MORD = 56638

I receive the following error:

Server: Msg 7390, Level 16, State 1, Line 1
The requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface returned 0x80004002].

Is this basically telling me that the driver I am using can not perform update functions? Or might I have written the query incorrectly? Any guidance would be greatly appreciated as I am new to linked servers and need to find a way to update data to a non-SQL database from a SQL database based on certain criteria.

Thanks!

 

[jamestayla]

Hello,

Are you still having this problem? I'm using T/SQL as well, though I don't do any writes (only selects). Have you tried selecting the 'Non transacted updates' option when you set the linked server up? (in the new linked server dialog of enterprise manager, select the ODBC provider and click 'provider options'). Note that this option can only be changed when creating a linked server (you can create a temp one in order to change the option since it applies to all linked servers using the odbc provider, then delete it afterward).

Hope this helps.

James