I run the following pass-through query:
SELECT Charge.TxnID, Charge.TxnNumber, charge.RefNumber FROM Charge NOSYNC where charge.txnid = '7C46C-1162231634'
and it returns a record. When I run the following pass-through query:
update charge set refnumber='2222' where charge.TxnID= '7C46C-1162231634'
I get the following message:
Pass-through query with ReturnsRecords property set to True did not return any records.
The returns records property IS set to True. When I change it to No, it no longer recognizes the connection string.
What am I doing wrong? |