Unable to insert data into odbc-linked dbf files

[Eric Bouchard-Lefebvre]

Hello everyone,

I need to interact with a clipper application (using .dbf data files) from a
sqlserver 2000 environement.

After creating the my dsn (using the Microsoft dbase v5.0 driver), I went to
sqlserver and created a linked server using the MSDASQL provider.

From there, I am able to correctly retrieve data from the dbf files using
either

select * from AVANTAGE.[D:\CAFEFARO\ACCOUNTING]..COLOR
or
select * from OPENQUERY(AVANTAGE,'SELECT * FROM COLOR')

techniques.

However, I am completely UNABLE to modify data. I found this article
http://support.microsoft.com/default.aspx?scid=KB;en-us;q270119 proposing 3
techniques to interact with server-linked data.

UPDATE AVANTAGE.[D:\CAFEFARO\ACCOUNTING]..COLOR SET BORDER='W'
UPDATE OPENQUERY(AVANTAGE,'SELECT * FROM COLOR') SET BORDER='W'
SELECT * FROM OPENQUERY(AVANTAGE,'SELECT NULL UPDATE COLOR SET BORDER=''W''
')

All these query return

Server: Msg 7390, Level 16, State 1, Line 6
The requested operation could not be performed because the OLE DB provider
'MSDASQL' does not support the required transaction interface.

What am I doing wrong?

Thanks,

-------------------------------------------------------------
Eric Lefebvre
Associé, Solutions Wizbusiness inc.
www.wizbusiness.net
messenger: eric_boucha...@hotmail.com

[Umachandar Jayachandran]

Set the "NonTransactedUpdates" property to True for the provider. You
can do this while creating the linked server.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )