Le 26/11/2013 07:37, [email protected] a écrit : > I am trying to access a firebird 1.5.3 database remotely from python using > pyfirebirdsql. (access from Ubuntu precise 64 bit to Firebird running on > Windows) > > I can connect to the database locally using a username/password with a > defined role (using FlameRobin) but the connection string for pyfirebirdsql > doesn’t seem to allow a role to be defined so that I can use this same > username. Have I missed something? > something like : firebirdsql.connect(dsn='host:/path/database.db', user='limited_user', password='pass', role='MORE_POWERFUL_ROLE')
should work but it seems that the code don't use role : https://github.com/nakagami/pyfirebirdsql/blob/master/firebirdsql/fbcore.py you should report it here https://github.com/nakagami/pyfirebirdsql or better propose a patch > I have tried to install KinterbaseDB but it needs Firebird client installed > and I couldn’t get all the relevant dependencies for Firebird 1.5 to install > properly on my Ubuntu system so gave up on that option. > KInterbasDB is obsolete use fdb https://pypi.python.org/pypi/fdb/ > If I only want read access will fdb work or is there some other option I > have missed? fdb need firebird client but it will work
