|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread|
|Messages 1 to 2 of 2 total|
|update DBISAM table via linked server ODBC driver 64bit v4.47|
|Thu, Feb 7 2019 6:19 AM||Permanent Link|
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
set ASSETTAG = NDFOOTPRINTS.ND
FROM OPENQUERY(INTELLIRW, 'SELECT SERIALNUMBER, ASSETTAG, RACKNAME FROM NEWDB.RACKINFORMATION')RI
[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
|Wed, Feb 20 2019 11:48 AM||Permanent Link|
Tim Young [Elevate Software]
Elevate Software, Inc.
<< 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.