Subject Re: MS SQL update Firebird Database
Author Erik De Laet
Can you link an SQL-server to a Firebird database ?

If so, could someone please explain how.

If this is off topic in this list, please email me directly at erik
[dot] delaet [at] edelcom [dot] be.

I am going to migrate a Sql-server 2000 to a Firebird 2 database in
the near future, and this would help me a lot.

Thanks,
Erik De Laet



--- In firebird-support@yahoogroups.com, Mikhail Harith
<mharith@...> wrote:
>
> 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
>