firebird-python - Fwd: Python cannot find path to fbclient

Subject	Fwd: Python cannot find path to fbclient
Author	Philip Godkin
Post date	2018-08-26T19:13:05Z

Windows Server 2012

Firebird 2.5

Python3.6.5

Hope someone can help, I can am trying to connect to a database on my server i keep getting this message, i have checked windows/system32 and windows/sysWOW64 and both have the fbclient.dll file, this file is also in the bin of the Firebird. I am running this code on the server as well

code

import fdb

con = fdb.connect(

host='C://', database='C://ITServer//dbname.FDB',

user='sysdba', password='masterkey',charset = 'none')

cur = con.cursor()

cur.excute("select * from ADDRESSCOUNTIES")

print(cur.fetchone)

Result

Traceback (most recent call last):

File "C:\Users\Administrator\Desktop\Python\Firebird\Test.py", line 6, in <module>

user='sysdba', password='masterkey',charset = 'none')

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\lib\site-packages\fdb\fbcore.py", line 784, in connect

load_api(fb_library_name)

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\lib\site-packages\fdb\fbcore.py", line 220, in load_api

setattr(sys.modules[__name__], 'api', ibase.fbclient_API(fb_library_name))

File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\lib\site-packages\fdb\ibase.py", line 1386, in __init__

raise Exception("The location of Firebird Client Library could not be determined.")

Exception: The location of Firebird Client Library could not be determined.

thanks in advance

Regards

Philip Godkin