[firebird-support] firebird 1.5

2016-05-10 Thread robert rottermann rob...@redcor.ch [firebird-support]
Hi friends in firebird, I got a database that was created with a firebird 1.5 on windows. Now I installed Firebird-1.5.2.4731-Win32.exe an a windows 7 and on a windows 10 machine. I copied also the following files into the UDF folder: MD5 UdfArithmetic UdfArithmetic.dll UdfControl UdfC

[firebird-support] accessing firebird on windows from linux

2016-05-17 Thread robert rottermann rob...@redcor.ch [firebird-support]
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: en

Re: [firebird-support] firebird 1.5

2016-05-17 Thread robert rottermann rob...@redcor.ch [firebird-support]
Thanks Helen for this thorough explanation. I decided to keep the db running on windows and try to access it from linux. robert On 10.05.2016 22:25, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > Hello robert, > > Wednesday, May 11, 2016, 3:47:19 AM, you wrote: > >> I got a databa

Re: [firebird-support] Character sets and collations of columns

2016-08-26 Thread robert rottermann rob...@redcor.ch [firebird-support]
I have no idea at on how to fix it "correctly", but would it not be an idea just to dump the tables with weird character into a text file, and search replace them. The wrong chars are probably uniformly wrong, so you should be able to fix them using sed or some such tool (on linux, I am not wel

[firebird-support] unpacking backup with firebird version 1.5 (windows 7)

2017-07-24 Thread robert rottermann rob...@redcor.ch [firebird-support]
Hi there, we are in the process of restructuring a system running on windows XP. It uses firebird version 1.5. The person that created the system is not available anymore .. some times ago, i got the database and installed it on a win7 box. Now I would like to get the newest data from the dail

Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)

2017-07-28 Thread robert rottermann rob...@redcor.ch [firebird-support]
Hi there, I proceded as Helene suggested I executed gbak. However this produced zillions of warnings of the form gback: do not recognize table attribute 0 -- continuing this goes on now for some 15 minutes. A database VAS.FDB I can open it from my linux box using flamerobin. The tables seem to

Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)

2017-07-28 Thread robert rottermann rob...@redcor.ch [firebird-support]
Hi there, I proceeded as Helene suggested I executed gbak. However this produced zillions of warnings of the form gback: do not recognize table attribute 0 -- continuing this goes on now for some 15 minutes. A database VAS.FDB was created I can open it from my linux box using flamerobin. The ta

Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)

2017-07-28 Thread robert rottermann rob...@redcor.ch [firebird-support]
Thank you Helen, I had a disk crash so I was absorbed restoring .. gbak -c d:\vas_db\/VAS.bak localhost:d:\vas_db\VAS.fdb -user sysdba -password yourpwd your proposal seems to work. the restore operation is running now for some minutes. However I get very many (some thousand ??) messages of th