Subject ODBC problem
Author yolisqlmax
Hello,

I'm using Firebird 1.0.3 under Windows 2003.

I'm trying to program a DTS in a MS SQL Server 2K to insert the data
generated in de SQL Server into my Firebird.

I've tried to do this with an OLEDB connection, I've tried the
IBProvider, but it doesn't work.

I've also tried to connect with sibprovider, but when I registered
the dll this dll has expired. I've seached a new dll but I haven't
found it.. :(

After this I've tried the ibphoenix odbc, and I can connect to my
firebird database, but when I want to generate a query for a user
table I get this error:

Dynamic SQL Error
SQL Error code=-204
Table unknown PERSONAL
At line 1, column 24

The table exists!

If I make the same query for a system table I don't get any error
message, it works fine. And the same occurs if I create a new table
as the destiny for the new data.

Any idea about what's happening?

Thanks in advance.

Best regards.

Yoli