FirebirdSQL/python3-driver

Multiple Firebird instances on same machine

eko234 opened this issue · 1 comments

I'm developing a web service where I need to connect to different databases depending on the request, said databases are in different firebird versions and are listening on different ports, the thing is I can't seem to find a way to even connect to one because I got an error saying:

FileNotFoundError: Could not find module 'fbclient.dll' (or one of its dependencies). Try using the full path with constructor syntax.

I'm using windows and when I run this function before the connection:

load_api("C:/Users/luis/Liquidador_IYC/fbclient.dll")

I get a [WinError193] 1% saying that this is not a valid win32 application.

So the question is, is there a recommended way to handle multiple firebird instances?, and can I connect using something like "127.0.0.1:por>/db-path" dinamically?.

First, this is an support issue. Most likely you are using 32-bit application (Python) with 64-bit Firebird. You should either use 64-bit Python, or 32-bit Firebird, or at least install 32-bit Firebird client.