We are trying to update a DBISAM table from SQL Server.

OS Windows server 2008 64bit
Standard DBISAM ODBC 64bit v4.47

here is the query we are using
update RI
set ASSETTAG = NDFOOTPRINTS.ND
FROM OPENQUERY(INTELLIRW, 'SELECT SERIALNUMBER, ASSETTAG, RACKNAME FROM NEWDB.RACKINFORMATION')RI
inner join
[PEMIS].dbo.NDFOOTPRINTS on NDFOOTPRINTS.FOOTPRINT = RI.SERIALNUMBER AND NDFOOTPRINTS.RACKNAME = RI.RACKNAME

It says it has updated xxx rows, but nothing is updated. Any help would be greatly received

Sean,

<< here is the query we are using >>

Unfortunately, you can't insert into, update, or delete rows from DBISAM tables with the OPENQUERY() pass-through query functionality in SQL Server.

Tim Young
Elevate Software
www.elevatesoft.com