Connecting to Firebird with ODBC

I've trying to connect to a Firebird database with an ODBC connection with a Gemni driver.

But when I try and setup the ODBC connection, I keep getting an error that say 'connection failed, cannot find library'.

Has anyone set this up, and what am I missing. I really need to get this working.

Thanks in advance,

kb

Probably you miss gds32.dll the Interbase/Firebird client library.
Otherwise check the ODBC driver available from www.ibphoenix.com

Also I've seen something about a missing msvcp60.dll or something.

Exellent, that was what the problem was. I was missing the gds32.dll file. Thank you very much

I've managed to get the ODBC connection to work, and I've setup a linked server in SQL.

I can see the tables and views that are within the database. But, I cannot seem to query on them. It doesn't recongnise the table name as an object.

In the past when I have used linked servers in SQL, when querying a table I had to specify the linked server name, the database name, the schema, and finally the name of the table.

In this case, I know the linked server name, the name of the table I'm hitting, but there is no schema associated with the table and the GDB file for the database can also not be seen. There is a space in the database name which I don't like as well.

Any ideas on how to query the information??

Can anyone help me with the above problem? I know there has to be someone out there that is linking to a firebird database with an ODBC connection.

Did you check Gemini's bug database?

Do you use case in your table names?

eg: Table1 instead of TABLE1

It might be that you created your objects case sensitive:

CREATE TABLE "Table1"

This means that you need to use the double quotes always. A pain.

Hmm, I'm not sure. I'll try your suggestions. I'm really stuck. I can parse the query and it works, it's just when I try and run it, it fails.

Here's the query:

Select *
From CAMALOT."TEST DATA.GDB".TAXPASSOFF

Which returns an invalid object name error.

What is "CAMALOT"?

you can't cross query two databases... if CAMALOT is the server and TEST DATA.GDB is the database and TAXPASSOFF is a table you should connect to database and then:
SELECT * FROM TAXPASSOFF

in my opinion the ODBC driver available from www.ibphoenix.com in a good choise

You can cross query from two different servers normally. I do it now in SQL with other databases. The only difference with those is that they are both SQL databases.

Appararently it's supposed to be possible with this driver, but I'm not quite sure why it's not working. I've looked at the tips and tricks for the driver, and turned on the Case-Insensitive feature as well, but it made no difference.

Frost,

I assume that you mean MS SQL Server databases if you say "SQL databases" and that you mean "from within MS SQL Server" if you say "in SQL".

This is very confusing.

SQL is a query language. MS SQL Server is a product.

If you created a MS SQL Server "linked server" entry to a Firebird ODBC datasource, does it help if you use the following:

Select *
From CAMALOT.TAXPASSOFF

(assuming that "CAMALOT" is the linked server, and "TAXPASSOFF" isn't created case sensitive)

what is "linked server" entry to a Firebird ODBC datasource ?

A "linked server" is, as far as I can remember and without trying, a remote/outside datasource definition in MS SQL Server.