| Subject | Accessing MS SQL Srv from IB Stored Proc |
|---|---|
| Author | frank_nestle |
| Post date | 2004-08-31T15:34:23Z |
Hello, I am new here with the following question:
I want to establish an interface transferring data from a MS SQL
Server to an Interbase Server 6.0. I am thinking of a stored proc (in
the IB DB) accessing the MS SQL Server DB (via a MS SQL ODBC driver
on the IB machine). Can anybody tell me how to use an ODBC data
source from within an IB stored proc, or is there a better way to
implement this daily interface?
Thanks for help, Frank.
I want to establish an interface transferring data from a MS SQL
Server to an Interbase Server 6.0. I am thinking of a stored proc (in
the IB DB) accessing the MS SQL Server DB (via a MS SQL ODBC driver
on the IB machine). Can anybody tell me how to use an ODBC data
source from within an IB stored proc, or is there a better way to
implement this daily interface?
Thanks for help, Frank.