Re: [firebird-support] Recording Update statements and User that executed

2013-02-26 Thread Thomas Steinmaurer
Marius, > [Marius Labuschagne] "Hi, > > Is it possible to record any UPDATE statement that is executed against a > database, from the database level? > > Something very strange happened to one of my Clients databases, where one > field in a table was set to another field in the same table (both do

[firebird-support] Re: Firebird, IBReplicator, or Windows Permissions?

2013-02-26 Thread Justin
Many thanks on suggesting WNET connections strings as being the cause. Your reasoning was very interesting too. Unfortunately though, the servers that the solution was installed on seem to have other issues (probably relating to hardware), so we are looking to start from scratch with new hardw

RE: [firebird-support] Recording Update statements and User that executed

2013-02-26 Thread Marius Labuschagne
[Marius Labuschagne] "Hi, Is it possible to record any UPDATE statement that is executed against a database, from the database level? Something very strange happened to one of my Clients databases, where one field in a table was set to another field in the same table (both double precision fields

[firebird-support] Recording Update statements and User that executed

2013-02-26 Thread Marius Labuschagne
Hi, Is it possible to record any UPDATE statement that is executed against a database, from the database level? Something very strange happened to one of my Clients databases, where one field in a table was set to another field in the same table (both double precision fields). I suspect that thi

Re: [firebird-support] Re: Firebird, IBReplicator, or Windows Permissions?

2013-02-26 Thread Carlos H. Cantu
h> --- In firebird-support@yahoogroups.com, "Carlos H. Cantu" wrote: >> >> h> Don't use WNET connection strings, especially on Win7. >> >> I never use WNET, but I'm curious: why not? h> And why yes ? :) h> Not, because: h> a) NetBEUI is deprecated by MS since WinXP (iirc) h> b) it requires a

RE: [firebird-support] -104 Token unknown - line 1, column 497 ?

2013-02-26 Thread Varga Balázs
I have renamed the parameter names, but I get the same error. Btw. I have another queries, where I use the same parameter many times. Changing the query is unfort. not an option. To: firebird-support@yahoogroups.com From: svein.erling.tysv...@kreftregisteret.no Date: Tue, 26 Feb 2013 09:15:49 +

[firebird-support] Re: Firebird, IBReplicator, or Windows Permissions?

2013-02-26 Thread hvlad
--- In firebird-support@yahoogroups.com, "Carlos H. Cantu" wrote: > > h> Don't use WNET connection strings, especially on Win7. > > I never use WNET, but I'm curious: why not? And why yes ? :) Not, because: a) NetBEUI is deprecated by MS since WinXP (iirc) b) it requires additional security

[firebird-support] Firebird 2.5.x x64 Windows - terminated abnormally (4294967295)

2013-02-26 Thread Roland Turcan
Hello all once again, I have spent quite long time with analyzing firebird.log files on many different servers I can access today. All servers I checked are running on Windows 7/2008R2 and they have in firebird.log very often logged this problem: "C:\Program Files\Firebird\Firebird_2_5\bin\fbser

RE: [firebird-support] -104 Token unknown - line 1, column 497 ?

2013-02-26 Thread Svein Erling Tysvær
>I have this query with some parameters: > >"INSERT INTO " & _ >"szamlaegyenlegek(szamlaszam, halmt, halmk, halme, > uzleti_ev, alperiodus_kod, datum, targyt, targyk, targye, kpnem) " & _ >"SELECT DISTINCT " & _ >"szamlaegyenlegek.szamlas