I have a Quantum database that is using Firebird connection on a windows 2003 32 bit. I am trying to connect to the server through ODBC from a server 2008 R2 64 bit but it tells me "Failed to open database xxx connection" every time I click on test connection. I installed the latest 32 bit and 64 bit driver on the 2008 server and upgraded the Firebird diver on the 2003 server to the latest 32 bit driver. What am I missing? I am trying to connect to the database server so I can migrate the database to SQL.
Asked
Active
Viewed 794 times
1
-
Your tags don't match the body of your question... – lc. Feb 18 '14 at 00:50
-
thanks. I changed the tags. – user3314399 Feb 18 '14 at 00:55
-
Is there a firewall in the way? – lc. Feb 18 '14 at 00:58
-
No firewall. Only Symantec endpoint protection on the 2008 server. – user3314399 Feb 18 '14 at 05:03
-
1Check if this [SO question](http://stackoverflow.com/questions/13569933/access-a-32-bit-firebird-database-from-a-64-bit-app-via-odbc) helps you. – Guillem Vicens Feb 19 '14 at 08:54
-
No o already have installed both drivers on the server. – user3314399 Feb 20 '14 at 13:40