> I need to copy/move some Unicode data (mot much) from SQL Server 2005 to
> Firebird 2.1 (latest version).
>
> In older SQL Server versions the import/export wizard supported ODBC so
> I could use that to copy the data into Firebird using the Firebird ODBC
> driver.
>
> But SQL Server 2005 export/import wizard only supports OLE DB, and I
> can't find a free OLE DB provider for Firebird.

With some googling, I found: http://sourceforge.net/project/showfiles.php?group_id=72859
However it is from 2006, so I don't know what compatibility it has with Firebird 2.x

According to this article (part of the Server 2008 books online), there is also a OLEDB provider for ODBC included in (or downloadable for) SQL Server 2008 (and as far as my google skills can tell me, also in Server 2005):
http://msdn.microsoft.com/en-us/library/ms191462.aspx

Mark
--
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01