Subject | Re: MS SQL update Firebird Database |
---|---|
Author | Erik De Laet |
Post date | 2007-10-10T12:48:23Z |
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:
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:
>procedure
> Dear all,
>
> Wondering how to update a table residing in firebird from a
> 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
>