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.