Hi Nick,
I have only ever managed this when I have 2 x connections to 2 different database, had one transaction shared between them and managed to kill the connection before a commit or rollback completed. This was doing replication over dial up, so there were lots of lost connections and it happened, but rarely.
From what you say, is there a chance that you are using the same transaction across the 2 database connections (to the same database)? This could theoretically cause the problem.
I have not seen: "Transaction description item unknown", but there again, I haven’t seen a dial up connection in a few years.
Cheers,
Jason Chapman
JAC2 Consultancy Limited
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAJa8MdkNV8UaGxdbsC%2BS1CYZ6meYVc-Nxsdq%2Bd3-N7tt345Jxg%40mail.gmail.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/006701d6faa7%247e07c850%247a1758f0%24%40jac2.co.uk.
What I did was to have a special folder somewhere (on same or different hard disk) and have a path in THE table. For file name I use unique ID from the table with original extension, there are no duplicate names in that folder.
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/em759072c8-faeb-4317-b392-021ede252bb7%40tibi.
We used to have second databases. We had to get 10M (wild estimate) documents into a Interbase 5.6 DB on windows NT – 1990’s. We used a proprietary image compression and all images went into the main DB. There was a background process on the server to move them to archive DB’s over time and the main DB tracked which one they were in.
Worked really well and you decide how to sort out the archive DB’s that just have images in them. You find that some of the DBs over time hardly ever got opened. In that system the client app got the DB info from the main connection and opened the image DB’s as it needed to.
+ have you ever tried to move 1M smallish image files from one machine to another. Copying one large DB a lot quicker..
Jason Chapman
JAC2 Consultancy Limited
From: firebird...@googlegroups.com <firebird...@googlegroups.com> On Behalf Of tiberiu...@gmail.com
Sent: 06 February 2021 07:18
To: firebird...@googlegroups.com
Subject: [firebird-support] Pictures in external table
Hi all,
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/em759072c8-faeb-4317-b392-021ede252bb7%40tibi.