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?

I used the 32-bit driver and was able to connect to an AMD/Linux system from WinXP; I have little experience with Win2003. The driver has to match the architecture of the system it is on; 32-client = 32-bit ODBC or 64-bit client = 64-bit ODBC. There may be exceptions, but I have been successful sticking to that rule and not mixing 32-bit drivers on a 64-bit system.

2) What should be the correct path notation?
3) What else am I missing?

I would set up an alias on the server (find aliases.conf where you installed firebird). The examples in the *conf file are pretty straight forward.
EX:
MyDB = d:\db_prod\dbfilename.gdb

This makes the connection string MUCH easier to manage. Once the alias is set up, your connect string is as follows:
IP:ALIAS
or
192.168.10.110:MyDB


Sorry I couldn't be more help with the ODBC stuff.
Kurt.
----------------------------------------
Never underestimate the Power of Denial.

>
>From: Scott Moon <smoon63@...>
>To: firebird-support@yahoogroups.com
>Sent: Saturday, July 25, 2009 11:53:19 AM
>Subject: [firebird-support] Open database 'IP_Address:d:\db_prod\dbfilename.gdb' failed
>
>
>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
>
>
> > >

[Non-text portions of this message have been removed]