Subject | MS SQL update Firebird Database |
---|---|
Author | Mikhail Harith |
Post date | 2007-10-10T06:50:26Z |
Dear all,
Wondering how to update a table residing in firebird from a procedure
in sql server.
Linked server already exists, and i can query fine.
However, when i run an update a.k.a.
UPDATE TESTDB...TEST SET TEST = 'Text Testing'
toad for sql server tells me command successful, however a query
using IB Expert results in an empty table.
Anyone see what I'm doing wrong?
Rgds,
Mikhail
Wondering how to update a table residing in firebird from a procedure
in sql server.
Linked server already exists, and i can query fine.
However, when i run an update a.k.a.
UPDATE TESTDB...TEST SET TEST = 'Text Testing'
toad for sql server tells me command successful, however a query
using IB Expert results in an empty table.
Anyone see what I'm doing wrong?
Rgds,
Mikhail