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