Hi Frank,

> 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).

Nope, doesn't work - no can do. Sorry, nope, out of the question.

>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?

Only a client app can do this.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com