Re: [Firebird-odbc-devel] SQL Server 2000 DTS

[Thomas S. <ts...@ib...>]

> I'm trying to transfer data from SQL Server to firebird using a DTS
> package. I've done this in the past to firebird 1.5 with no problems.
> 
> When I try to do the same thing with firebird 2.1 (64 bit) no errors are
> given but no tables are listed in the transformation destination
> dropdown. I have tried the latest snapshot version of the driver but no
> luck so far.
> 
> I have tried installing the firebird 2.1.2 client on the machine and
> changed the system dsn to use that instead of the 1.5 one but to no avail.
> 
> Any ideas anyone?

Are you using SYSDBA for the connection?

I've seen various problems (e.g. not listing tables, ...) with 
third-party tools using the Firebird ODBC driver when you aren't 
connected as SYSDBA.


-- 
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/