[firebird-support] Re: Random operating system directive MapViewOfFile failed messages

2019-06-06 Thread eadbha...@yahoo.com.mx [firebird-support]
With a Dot Net Provider based application, that is the only messages that surfaces at the application level: FirebirdSql.Data.FirebirdClient.FbException Message : operating system directive MapViewOfFile failed StackTrace : at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()

[firebird-support] Random operating system directive MapViewOfFile failed messages

2019-06-06 Thread eadbha...@yahoo.com.mx [firebird-support]
Hi there, We started seeing this error from client applications two days ago. They appear randomly during the day. "operating system directive MapViewOfFile failed" We have to close the client application with Windows task manager and restart it, most of the time this silences the

[firebird-support] Firebird 2.5 transaction counters

2019-04-25 Thread eadbha...@yahoo.com.mx [firebird-support]
Hi there, I am sharing the gstat results for one of our databases below. Can anyone please help on how far or close we are of reaching the transaction counter limits of Firebird 2.5 please. Database header page information: Flags0 Checksum12345

[firebird-support] Configure a timeout to rollback transactions of dead connections

2018-11-16 Thread eadbha...@yahoo.com.mx [firebird-support]
Hi there, We have been suffering blackout problems lately. Our Firebird database server stays on but all client computers with applications just die. Due to this, some database records end up being "locked up" by the server and when the power returns, client applications cannot continue

[firebird-support] COUNT DISTINCT issue in Fb 2.5

2017-09-04 Thread eadbha...@yahoo.com.mx [firebird-support]
Hi there, I have this query: select a.num_part, a.cve_prov, a.cve_impo, a.des_merc from ctrac_clasif a where a.num_part = '0630039046'; It yields this results: NUM_PART CVE_PROV CVE_IMPO DES_MERC = = = == 0630039046 3400. 19 CUBIERTA

[firebird-support] External Data Source Authentication Issue

2017-08-23 Thread eadbha...@yahoo.com.mx [firebird-support]
I there, I am trying the statement below on a FB 2.5 for Windows test environment. I am pretty sure that USER and PASSWORD are correct, in fact, I can connect to the same database from IBExpert using those values with no issues. But when the code below runs, I get this error: Unsuccessful