I have a new 64-bit Windows 2003 server that is to be put into use as a BI system server running QlikView 9.0 Server/Publisher. I am trying to set up the Firebird ODBC driver, but no matter what combination of things I try, when I try "Test Connection" from the Firebird ODBC Setup control panel on the 64-bit box, I get the error message in the subject line immediately. The Firebird DB is also on a Win 2003 server, but it is still running on a 32-bit machine. Firebird SS version 2.0.1.12855. Both machines are running on the same domain, the 64-bit machine is brand new and only has the new QlikView 9.0 64-bit Server and Publisher running on it.

I can connect to the database in the same manner from the existing BI server, also running 32-bit Win2003 Server. On the 64-bit Bi machine, I have tried using the same ODBC driver we have installed on the 32-bit machine (v1.02.00.69), the newer 64 & 32-bit versions, all with the same result. I have also tried every combination of pth notation I could find documented in the ODBC help, as well as a few others that I made up on the fly with the exact same result.

Questions:
1) Which ODBC version should I use to connect from 64-bit Win2003 Server to a 32-bit FB v2.0.1 DB on 32-bit Win2003?

2) What should be the correct path notation?

3) What else am I missing?

Thanks - I've pretty much exhausted everything I can think of!

Scott Moon