thanks for the tip ..
it is working now like this:
on the windows box with ip 10.42.0.150 the path to the database is:
c:\Users\elvis\Documents\VAS.fdb
# using fdb only
con = fdb.connect(dsn='10.42.0.150:/Users/elvis/Documents/VAS.fdb',
user='sysdba', password='thekey')
# using sa
engine =
sa.create_engine('firebird+fdb://SYSDBA:thekey@10.42.0.150:3050/Users/elvis/Documents/VAS.fdb')
in both cases the port is not needed, but can be used.
robert
On 17.05.2016 17:00, Mike Bayer wrote:
firebird is very obscure / esoteric. I'd get a straight fdb DBAPI
working first then we can work backwards to get the right URL.
On 05/17/2016 10:42 AM, robert rottermann wrote:
Hi there,
I try to access a firebird db on windows from my ubuntu box.
I have a gui-tool (FlameRobin), from which this works nicely. Therefore
it is not a firewall or access problem.
Now I would like to do it using python and sqlalchemy.
So far I failed..
This is the connection string I use:
engine =
sa.create_engine('firebird+fdb://SYSDBA:thekey@10.42.1.150:3050///c:\\Users\\elvis\\Documents\\VAS.fdb')
I tried many combinations of the part after the port.
thanks for your hints
robert
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.