Firebird ODBC Windows 7 Home

firebirdodbcwindows 7

I have a Firebird 2.1.2 database running on a Windows 2003.
I already have Windows XP clients, also Windows 7 64-bit Profesional, all logged into the same Windows domain as the server and every one using ODBC connections.

But I want to connect a Windows 7 64-bit Home Basic to that Firebird database. Using Firebird Client (ODBC) I cannot open a conection to the Firebird server. I also tried FlameRobin with no success… I can get access to the shared, but not to the database.

Did anyone had this problem before? Is this because of the domain restriction of Windows 7 Home?
Is there any tool to help me diagnosing this issue?
Thanks a lot!!

Best Answer

Answer based on my comment that solved the issue

The most likely cause is missing libraries or incorrect bitness of various components. If your application is 32 bit, then you need to make sure that

  • The ODBC driver is 32 bit
  • The installed Firebird client library is 32 bit
  • If you use a DSN: that the DSN is created using the 32 bit ODBC administrator

The same applies if your application is 64 bit, but then of course all components need to be 64 bit. Mismatch in bitness will simply mean that the application doesn't see the library. Of course if one of the above is missing entirely it won't work either.

Related Topic