Subject | RE: [firebird-support] Integrating FB and SQL |
---|---|
Author | Nigel Weeks |
Post date | 2005-07-25T04:00:40Z |
>You can't do it directly, you'll need glue between the two.
> I mean interact n the need to trasfer data from and to SQL
> Server from stored procedures (something like linked serves,
> opendatasource and openrowset) because we need to manage
> quantities and costs, and the new system will be used to
> track quantities and the costs are in the ERP
>
If MS SQL can open ODBC data sources, you could setup Firebird to listen to
ODBC, and pump data between the two that way.
If you need to pull data from MS SQL into Firebird, you might need a
table(in Firebird) to indicate your request. MS SQL then looks at this
request table(via ODBC), processes requests, and pushes results back into
your Firebird DB (via ODBC)...
There's lots of ways of doing it! Let us know how you go!
Nige.