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

[Ian N. <ia...@co...>]

That was it. There seems to be an issue with getting table lists from 
the driver when using a user other than sysdba.

Do I need to raise this as a bug somewhere?

Regards
Ian

Thomas Steinmaurer wrote:
>> 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.
> 
>