Re: RES: [firebird-support] Re: database became broken for any reasons

At 06:01 a.m. 20/05/2014, markovdmi...@yahoo.com [firebird-support] wrote: >I kill fb_inet_server.exe because sometimes database not go into shutdown >state or not go into on-line mode, I don't know what, but something hold >database so no one can work with database. If I kill fb_inet_server.ex

Re: [firebird-support] Updating Firebird

At 06:26 a.m. 21/05/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >Hello. > >I want to update Firebird from 2.5.2.26539 to 2.5.2.26540. > >Should I close all databases and stop de Firebird server? Yes, of course. You will be changing the code that is running for the server. and for

Re: [firebird-support] Updating Firebird

At 02:21 a.m. 23/05/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >Thank you for the answers. > > >>Don't forget to update the client libraries. >What libraries should I update? fbclient.dll on your Windows clients - the 64-bit version for your 64-bit apps, the 32-bit version for

Re: [firebird-support] old CORE-742 for disscussion

At 06:28 p.m. 28/05/2014, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: >Hi, > >http://tracker.firebirdsql.org/browse/CORE-742 >i do not need to spam tracker then i move discussion to group. Move it to Firebird-Architect, please. ^heLen^

Re: [firebird-support] FB database Replication

At 01:36 p.m. 2/06/2014, halim1...@hotmail.com [firebird-support] wrote: >Hello All, >I was looking for a good replication tool to replicate our FB database. I came >across FBReplicator from IBPhoenix. The tools is not that simple to setup but >it works good if setup properly. >The only questio

Re: [firebird-support] (unknown)

At 11:31 p.m. 19/06/2014, suzan kardes logicelectronic...@yahoo.com [firebird-support] wrote: >Hi Everyone, > >I installed a programme and the programme uses firebird database. I take error >message as following when I run application. Please help how I can fix the >problem. > >Thanks in adva

Re: [firebird-support] this keeps happening

At 06:06 a.m. 24/06/2014, MYKS51 my...@telus.net [firebird-support] wrote: >++ >> >> Visit http://www.firebirdsql.org and click the Resources item >> on the main (top) menu. Try Knowledgebase and FAQ links ! >> >> Also search the know

Re: [firebird-support] Cannot Insert Filepath into database

Hello Simon, At 11:00 p.m. 24/06/2014, 'Simon Gallitscher' adun...@gmx.de [firebird-support] wrote: > >I'm trying to insert a filename into my database using a .net firebird >connector. >Unfortunatly the standard escape character '\' is not working. >When i'm trying to insert a path like this:

Re: [firebird-support] Yahoo broken again?

At 08:16 p.m. 27/06/2014, Lester Caine les...@lsces.co.uk [firebird-support] wrote: >I've just been trying to access the list on-line, but it would seem >yahoo have broken everything again? Keeps coming back that the redirect >can not complete? I don't get that at all. >Is the 'VISIT YOUR GROUP

Re: [firebird-support] Can't open firebird database files from a windows service.

>> We're in the process of changing an application that accesses a Firebird >> database file from a regular application to a windows >> service. For legacy reasons this uses the Firebird embedded DLL (fbclient) >> for version 1.5.6. At 09:05 a.m. 10/07/2014, Ivan Přenosil ivan.preno...@sezn

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

At 06:29 p.m. 21/07/2014, Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support] wrote: >Hi Bhavbhuti, > >ASAIK, 32bit ODBC-driver can connect to 32bit Firebird only. Not so. The ODBC driver is part of the client layering. He needs to place the 32-bit Firebird client library in the pat

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

At 07:30 p.m. 21/07/2014, Venus Software Operations venussof...@gmail.com [firebird-suppo wrote: >Yes, I already have a copy of the 32 bit fbclient.dll in my application >folder. Why would the FB ODBC driver expect such an old name of dll? I can >of course rename the fbclient.dll to gds32.dll

Re: [firebird-support] Complete Language Reference

At 08:32 a.m. 23/07/2014, Arnold Levy arnoldjl...@gmail.com [firebird-support] wrote: >Hello! > >Does anyone know where the Complete Language Reference of Firebird 2.5 >is available for download? > >I tried http://www.firebirdsql.org/download/rabbits/dimitr/LangRef.html >but http status 404 - file

Re: [firebird-support] Terminal Services

At 01:05 a.m. 23/07/2014, jk2...@gmail.com [firebird-support] wrote: >I am trying to run an application for the SPCA on a Windows MultiPoint Server >2011 (running 2008 RC2) but it will only work on one terminal at a time. I >have contacted the software vendor and he tells me that the problem is

Re: [firebird-support] Joint result of master (columns) and up to 3 details (detail rows as columns)

At 05:41 a.m. 25/07/2014, patrick_mar...@yahoo.com [firebird-support] wrote: >Hello, > >I hope the title says more or less what I would like to achieve. For a better >overview I've made two screenshots. [... links ...] These links have been reported as a malware site. If you have files to up

Re: [firebird-support] RE: Why nbackup takes very long time for 40G database

At 08:44 a.m. 31/07/2014, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: >Please check the v2.5.2 and v2.5.3 release notes, there were some bug reported >where nbackup got "hung" which were fixed in those releases. Esp. 2.5.3, which has had some major work to reduce the time

RE: [firebird-support] Help!!! - Problem with Firebird Embeded

At 01:05 p.m. 14/09/2014, Adam adam...@gmail.com [firebird-support] wrote: >Hi Alan and thanks for your help. I checked the release notes and started >again. This is my directory structure: > >D:\my_app\myapp.exe >D:\my_app\myapp.FDB >D:\my_app\fbclient.dll What's this file? It should be fbem

Re: [firebird-support] What is the difference between these connection strings?

At 11:50 p.m. 1/10/2014, brucedickin...@wp.pl [firebird-support] wrote: >I know that I can connect to Firebird (on Windows) by specifying connection >string in two ways: > >1. C:\MyDB.FDB >2. localhost:C:\MyFDB.FDB > >I am speaking here about local connection. > >Is there any difference between t

Re: [firebird-support] Re: What is the difference between these connection strings?

At 08:55 p.m. 2/10/2014, brucedickin...@wp.pl [firebird-support] wrote: >Thanks Helen for the nice explanation. > >Out of curiosity I need to check what do you write about connections and these >protocols in your books. :) That's a good idea. ;-) Volume 1 Chapter 3. >The thing is that I am no

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

At 12:59 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote: >Is it safe to assume that, when you were running SuperServer, >you had edited firebird.conf to change the installation default >CpuAffinityMask from 1 to 15 ? (So that it would use all 4 of >your pro

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

>Helen Borrie hele...@iinet.net.au [firebird-support] wrote: >> At 12:59 p.m. 30/10/2014, Geoff Worboys >> ge...@telesiscomputing.com.au [firebird-support] wrote: > >>>Is it safe to assume that, when you were running SuperServer, >>>you had edited firebird.con

Re: Odp: [firebird-support] FB server installation a nd concurrent users limits on Windows Server

At 11:34 a.m. 7/11/2014, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: >Current windows versions of SuperServer and SuperClassic has a limit of >1024 concurrent connections, 2048 since V.2.5.3. Helen

Re: Odp: [firebird-support] FB server installation a nd concurrent users limits on Windows Server

>>>Current windows versions of SuperServer and SuperClassic has a limit of >>>1024 concurrent connections, >> >> 2048 since V.2.5.3. At 08:32 p.m. 7/11/2014, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: >I had missed that this had been backported to 2.5 :) Or up-ported to

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

>i > >> * How does your gbak restore call look like? >> GBak -C -User %1 -Pas %2 G:\FBDump\OCCEasyPos.fbk >> "LocalHost:F:\DB\Kaufmann\Uddannelse\OCCEasyPos.fdb" -v -rep -o >> -FIX_FSS_METADATA ISO8859_1 -fix_fss_data ISO8859_1 -y "G:\FBDump\ >> ;RestoreEasyPos.txt" >> >> At 09:03 a.m. 18/11/2014

Re: [firebird-support] FB 3.0 Beta 1

At 10:10 p.m. 5/12/2014, Werner werner...@gmx.ch [firebird-support] wrote: >I would like to start testing FB 3. > >Does the installer allow installation side by side with FB 2.5? Please take your Fb 3 Beta questions to the firebird-devel list. ^heLen^ (Moderator)

Re: [firebird-support] FB 3 release notes

At 10:21 p.m. 5/12/2014, Werner werner...@gmx.ch [firebird-support] wrote: >I think there is a typo in the section "Execution Modes": > >It states: >Superserver is set up using the configuration SharedDatabase = true and >SharedCache = true > >but I think it should be: >Superserver is set up using

Re: [firebird-support] Like and database entry "-"

At 03:35 a.m. 11/12/2014, Rainer Hamann rai...@hamann-kiel.de [firebird-support] wrote: >"where name like 'Ab%'" returns any entry of the table, where name start with >"Ab" except those ones containing character "-". Using "starting with" or >"containing" the same database entries are missing.

Re: [firebird-support] Re: Firebird 1.5 - CURRENT_TIMESTAMP difference

At 11:14 a.m. 15/12/2014, emad...@yahoo.com.au [firebird-support] wrote: >Unfortunately we're using 1.5 so "NOW" isn't available to us. Wrong. 'NOW' or 'now' was inherited from InterBase. CURRENT_TIMESTAMP came with IB6 or Fb 1.0, afair. Listen to what Sean said: 'NOW' gives you the time at e

Re: [firebird-support] FB 3.0 SQL Error.

Hugo, At 06:25 a.m. 24/12/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >Hello Friends. > >In FB 3.0.0 I received the error message: Name longer than database column >size. Would you please use the firebird-devel or firebird-test list for questions about Fb 3? This support list

Re: [firebird-support] Function - what is it called

At 11:25 p.m. 23/01/2015, michael.vilhelm...@microcom.dk [firebird-support] wrote: >I am looking for a function which are able to add values from a table as >records are fetched. > >Something like this: > >ValueCalculated value > >11 > >23 > >36 > >410 > >515 > >The calculated value is just the

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

At 09:04 p.m. 23/02/2015, SUKHEN DASS sukhend...@yahoo.com [firebird-support] wrote: >please, somone guide me where i am wrong This support list is for the Firebird database. For the .NET providers, you need to subscribe to the firebird-net-provider list: List-Subscribe:

Re: [firebird-support] fdb named parameters

At 10:04 a.m. 24/02/2015, Ernesto Benestante ebenesta...@gmx.net [firebird-support] wrote: >Hi, does FDB support named parameters in queries? Other python database >adapters support specifying a name for the parameters in the SQL string >and passing a dict to execute(), to bind the parameters to

Re: [firebird-support] Error converting 1.5 to 2.5 fdb

At 02:54 p.m. 25/02/2015, you wrote: >Hi, I need some help to convert DB 1.5 to 2.5. I've used gbak 1.5 for backup >and gbak 2.5 for restore operations but I've got error messages. It is a small >sample file, so I would like to attach fdb and fbk files for verification, >but I don't see UPLOA

Re: [firebird-support] unsupported on-disk structure

At 06:25 p.m. 27/02/2015, 'Marius Labuschagne' mjlabuscha...@turnkey-is.co.za [firebird-s wrote: >Hi, > >Can someone please comment on this scenario. > >I have been working on my machine for months, and suddenly this morning >whenever I try to connect to any of my database stored on this mach

Re: [firebird-support] GDS Exception 335544569 Dynamic SQL Error -104

At 10:38 a.m. 28/02/2015, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote: >Hello, > >I have Firebird 2.5.0.26074 database and when you try to insert a row >receives > >GDS Exception 335544569 Dynamic SQL Error -104 > >User SYSDBA Usually means there is a mistake in your DSQL statement t

Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2

At 01:38 p.m. 4/03/2015, you wrote: >bevore my question i have changed the /etc/service file to this: > >gds_db 5143/udp# gds_db (buhl) >gds_db 5143/tcp# gds_db (buhl) > >(without „/„ like the other entrys in this file) > >since this, firebird has stpped/started many times

Re: [firebird-support] Trouble with a Firebird query

At 04:46 a.m. 10/03/2015, Pat Coleman pcole...@foodireland.com [firebird-support] wrote: >Hi > >I am having trouble writing a query in iReport using Firebird SQL > >I can get the query to work in MS Access, but I’m not familiar with Firebird >SQL, seems to be different . Yes, Access "SQL" i

Re: [firebird-support] Re: Oldest transaction don't change

At 03:59 p.m. 16/03/2015, sdnetw...@gmail.com [firebird-support] wrote: >i have done some search and maybe i have a problem with commit reaining but it >still strange ! > >just to be sure about my test : > >1) if i do select count(1) from mon$transactions after the end of my program >and it ret

Re: [firebird-support] Awaiting Garbage Collector

At 08:09 a.m. 19/03/2015, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: >Ask your software vendor to fix their client transaction management. >Using auto commit as default transaction management mechanism is >Firebird's enemy number 1. Not only due to OAT not moving forward

Re: [firebird-support] Read errror 10054

At 05:36 a.m. 20/03/2015, dtav...@yahoo.com [firebird-support] wrote: >No matter what, the Firebird.log file keeps piling up the Read error 10054 >records, sometimes none in a week, sometimes six or seven occurences a day. > >I would greatly appreciate some sound advice on what to check, maybe so

Re: [firebird-support] update Firebird 2.1 to 2.5

At 09:28 p.m. 1/04/2015, miromiros...@yahoo.com [firebird-support] wrote: >Hi, >I have to update my FB 2.1 to 2.5. (32 bit, win xp sp3). >So, I did it. >Now I have some problems with metadata update, any ideas how to resolve this, >please. > >Invalid modify request. >unsuccessful metadata updat

Re: [firebird-support] Re: How do I uninstall Firebird on Mac Yosemite?

At 02:59 p.m. 4/04/2015, ryanash...@hotmail.com [firebird-support] wrote: >Okay, so I did the following: > >1) Opened a Terminal window >2) Typed 'vi remove.sh' [Enter] >3) Typed ':i' [Enter] >3) Pasted the text as above >4) Typed ':wq' [Enter] >5) Closed the Terminal window. When I closed the w

Re: [firebird-support] FB 2.1 on windows 8

At 08:05 a.m. 8/04/2015, moegama...@gmail.com [firebird-support] wrote: >Does FB2.1 run on windows 8 ... > >I installed the last 2.1 version o a windows 8 tablet (8.1) > >In trying to connect to my database with SQL Manager > >I get Connection failed Server is stopped or unproper client library is

Re: [firebird-support] IBReplicator way to force conflicts

At 06:45 a.m. 16/04/2015, Rodrigo Cardoso rcard...@datasystemnet.com.br [firebird-support wrote: >Hi everybody! > >Are there a way to force all conflicts programmatically? Rodrigo, This is the support list for the Firebird RDBMS. For IBPReplicator questions, you need to subscribe to the ibprep

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

At 11:41 p.m. 22/04/2015, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: >If I make all values to null of that column which is of type varchar and then >go for Alter, would you share the sql for it ? Changing the values to null does not change the data type of the column. The

Re: [firebird-support] Generator only seems to increment once...?

At 09:58 a.m. 27/04/2015, brian br...@meadows.pair.com [firebird-support] wrote: >Hi folks, > >Has anything changed with regard to generators after Firebird 1.5? >I've got Helen Borrie's first version as my reference book, and in >there I read > >SELECT GEN_ID(,) FROM RDB$DATABASE; > >as the way

Re: [firebird-support] Re: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)

Steve, At 08:54 a.m. 8/05/2015, sboyd...@gmail.com [firebird-support] wrote: >Had to change the coalesce with all the dates to cast each date individually >or I got a conversion error. Not sure why. > >COALESCE(CAST(OPS_ONBOARD_TIME AS DATE), CAST(OPS_DELIVERED_TIME AS DATE), >CAST(OPS_APPT_LOW

Re: [firebird-support] Connecting to Superserver on CentOS 6

At 10:45 a.m. 12/05/2015, 'David E. Wheeler' da...@justatheory.com [firebird-support] wrote: >Firebirders, > >I have been using the firebird-classic RPM for testing Sqitch, connecting like >so: > > > isql-fb -u sysdba -p masterkey > > >This worked well, but now I’d like to use superserver,

Re: [firebird-support] New to firebird Mac and lost

At 04:47 a.m. 27/05/2015, johnpayton...@btinternet.com [firebird-support] wrote: >Have downloaded Firebird SS2.5.4 and new user was set up but can't access any >commands from either my or Firebird user. Neither will give you access to a Firebird server. To get you started, you need a client a

Re: [firebird-support] Connection issues

At 01:25 p.m. 28/05/2015, 'seanspcpower IT Services' t...@seanspcpower.com [firebird-supp wrote: >The issue is lately the 1 client can no longer connect to the database using >the client application. > > >The application Ostendo and we have the Firebird database runs on an sbs2008 >box. > >It is

RE: [firebird-support] Connection issues

At 01:45 p.m. 29/05/2015, 'seanspcpower IT Services' t...@seanspcpower.com [firebird-supp wrote: >Please see text of the error message and Firebird log file below. > >Database Error heading: A Database or connection error has occurred! >dmSecurity.LicenseDB: >Unsuccessful execution caused by a

Re: [firebird-support] An alternative for ASCII_CHAR() ?

At 07:10 p.m. 4/06/2015, brucedickin...@wp.pl [firebird-support] wrote: >Hello, > >I need to produce delimited text output from my stored procedure, for example: > >23;65;some text; > >The thing is that semicolon ";" might appear in one of the delimited fields >and this will cause some bugs on t

Re: [firebird-support] Rolling back Transaction Doesn't Work with TpFIB Components

At 09:17 p.m. 11/06/2015, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: >Hi All, > >I am not sure whether this question is suitable here or not, but still I would >like to give a try. > >I am using Delphi 2010 with FIB Components like TpFIBDataset, TpFIBTransaction >and TpFIB

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com [firebird-support] wrote: >We were told that backing up with Interbase gbak and restoring with Firebird >gbak was the proper migration procedure, but that is apparently not true? That was true way back at Firebird 1.0 and (margin

Re: [firebird-support] Correct way to stop/restart FB 2.5 CS on Ubuntu 12 LTS 64bit Server

At 08:44 a.m. 14/06/2015, 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] wrote: >Hi All, > >We use Ubuntu 12 LTS 64 bit Server for some of our server installations. > >For the installation of Firebird v2.5.4 CS 64 bit we are using the zipped >tarball package from firebirdsql.org for

Re: [firebird-support] New Firebird 2.54 Win 32 Install

At 05:52 a.m. 20/06/2015, Karl Sandfort ksandf...@optimum.net [firebird-support] wrote: >I am new to Firebird. Was able to install on Windows 7 64-bit no problem. >Immediately after install ran gsec –user ‘SYSDBA’ –password ‘firebird password>’ with no problems. However, on Windows XP Pro SP3,

Re: [firebird-support] Blob concat consume memory - why?

At 07:27 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > >why concating blob consume memory and not leave it until transaction end? > >It looks like some temp buffers are created and not freed until transaction end >Is this bug reported or i should report it

Re: Re: [firebird-support] Blob concat consume memory - why?

At 08:03 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: >Hi Hellen, > >it looks like bug is not fixed only minimized? >I test this with current FB3 snapshot. I see that this fix - not fix reason of the bug - only minimize it? >Should i post this as new bug

Re: [firebird-support] Procedures and Triggers missing

At 08:20 a.m. 25/06/2015, Chris Valentine chrisvalentinem...@gmail.com [firebird-support] wrote: >We have a Firebird 1.5.6 database that we have been using for several years. >Many clients use it, there are rarely any issues. > >One particular client, suddenly is missing triggers and procedur

Re: [firebird-support] Get ID of record with minsort

At 07:18 p.m. 25/06/2015, josef.gschwendt...@quattro-soft.de [firebird-support] wrote: >Hi, > >I have a table with one ID-Column and one Sort-Column. > >I need the ID from the record with the lowest sort-number. >Sortnumbers are not unique (can be doubled). > >Can I do this with one SQL-Statemen

Re: [firebird-support] Downconverting fdb from 2.5 to 1.5 ?

At 08:54 a.m. 26/06/2015, srotyli...@gmail.com [firebird-support] wrote: >Is it possible to convert a 2.5 fdb file to 1.5 ? In the past, it was usually achievable to "go back" one ODS at a time by the following - using 2.1 back to 1.5 as an example -- 1. With 2.1 server running, 2.1 to 2.0 -

Re: [firebird-support] Missing fbclient.lib

At 11:21 a.m. 27/06/2015, t...@boyers.org [firebird-support] wrote: >I'm taking over maintenance and development on a Windows application written >in C++. Unfortunately I have to do it without any help from the previous >developer, and without a full copy of his build directory. I seem to have

Re: [firebird-support] Firebird 3 and Gbak

At 05:49 a.m. 17/07/2015, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >Hello. > >I am trying to use my application while gbak makes backup, but a message >is raised 'File alredy in use by another'. > >Running on Vista. This question is about a beta and is off-topic on firebird-support.

Re: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4

At 11:42 p.m. 22/07/2015, 'stwizard' stwiz...@att.net [firebird-support] wrote: >Greetings All, > >I’m needing to get underway way with preparing my Firebird 1.5.3 database for >migration to 2.5.4. Firebird 1.5.3 to 2.5.4 is not a migration, it is an upgrade. Actually, you don't even *absolu

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Using 2.5.4 FB Client to access a 1.5.3 DB database (Follow-Up)

At 08:36 a.m. 30/07/2015, 'stwizard' stwiz...@att.net [firebird-support] wrote: >The new Windows 2012 R2 64 bit server will have the 64 bit Firebird server >v2.5.4 install on it (But alternately may have Firebird 32 bit server >installed instead based on the answers given below). > >All client w

Re: [firebird-support] Multiple instances of firebird not working

At 12:45 p.m. 31/07/2015, prescha...@yahoo.com.au [firebird-support] wrote: >I have an 3rd party application running firebird 1.5. > > >I want to install firebird 2.5 instance, with my application, without >affecting the other app. > >instsvc install -auto -superserver -guardian -name secondse

Re: [firebird-support] UserNames connected to my database

At 11:25 p.m. 28/07/2015, blumy2...@yahoo.com [firebird-support] wrote: >Hi. I have a problem. I use a Firebird 1.5.6 Server for a lot of applications, >5 databases on the same server. > >I need to find the number of connection for a single database, and the names >of the users. For this i used

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined

At 07:31 a.m. 8/08/2015, 'stwizard' stwiz...@att.net [firebird-support] wrote: >Correction: > > > >I met to say I then installed FreeAdhocUDF not FreeUDFLib library. You said: >I verified that the function is defined with the following: > >select * from rdb$functions where upper(rdb$function_name

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined

At 08:20 a.m. 8/08/2015, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: >OK, when you restored your database, all of the old function declarations were >restored too. So you need to list out the names of the functions as they are >declared in the database (print them

Re: [firebird-support] Problem with AUTONOMOUS TRANSACTION

At 02:51 p.m. 8/08/2015, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [f wrote: >Hello everybody > >Do you know why this simple trigger "hang-up" the database? > >CREATE TRIGGER TRANSACCION_INICIA >ACTIVE ON TRANSACTION START >POSITION 0 >AS >BEGIN >Â Â >Â Â IN AUTONOMOUS TRAN

Re: [firebird-support] How safe is to use SS and embedded version in the same time

At 07:26 p.m. 10/08/2015, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: >Please,any advice there! >I'm my application I'm using FB superserver for main data. >I have some local data for application settings,different data (only for read) >that can be updated on application update and

Re: [firebird-support] Re: unable to complete network request localhost

At 07:52 a.m. 25/08/2015, thirdshiftco...@yahoo.com [firebird-support] wrote: >I have one more curiosity... I lied actually many more- > >why is fedora insisting in package manager to install embedded. Even when i >try to get rid of it fedora chooses to uninstall other files which I canceled >a

Re: [firebird-support] Is it possible to deactive a trigger from within a stored procedure?

At 08:21 a.m. 11/09/2015, 'stwizard' stwiz...@att.net [firebird-support] wrote: >Firebird v1.5.3 > >Is it possible to deactive a trigger on a table, then process some code inside >the stored procedure and then reactivate the trigger when done? All in a stored procedure? No. ALTER TRIGGER is D

Re: [firebird-support] HUGE Log File

At 10:14 a.m. 15/09/2015, chubmast...@mac.com [firebird-support] wrote: >Im no IT guy so bear with me. I have a 2009 iMac running os x 10.8It has >a 640 gb hard drive. Firebird.log is taking up 424 gb. I have a digital >X-ray program that uses firebird as it's framework. They deny they

Re: [firebird-support] HUGE Log File

At 11:58 a.m. 15/09/2015, chubmast...@mac.com [firebird-support] wrote: >Actually its a 424 gb log file that increased by 300 gb since sept 10, 2015 Yes, sorry, I noticed that after I posted. ;-) It won't do any harm to open your new log file in a day or two, and see just what is happening i

Re: [firebird-support] FBServer.exe terminates unexpectedly Code: 335544741, Error: connection lost to database

At 09:55 a.m. 16/09/2015, Saravana Pitchaimuthu saravana.pitchaimu...@citrix.com [firebir wrote: >Hi, >FBServer.exe terminates unexpectedly after few hours of operation with the > error mentioned above. Any idea on how to proceed with debugging the issue or > any resolutions available? >

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

At 11:34 p.m. 21/09/2015, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: >Thanks for the link. >Without specifically setting a new value, how can I check what setting is >currently in use? In Firebird's ..\bin directory, in a shell, do gstat -h path\to\database Look at the Attr

Re: [firebird-support] Firebird 3 PSQL Features

At 06:49 p.m. 24/09/2015, rgilland1...@gmail.com [firebird-support] wrote: >Hi > > >I am really interested in Firebird 3 new PSQL Features, other language support. > > >Is there anywhere I could see a listing of them? As usual for a Beta and a new release - in the release notes. You can downloa

Re: [firebird-support] invalid request BLR 623; LTRIM not defined; entrypoint not found.

At 05:44 p.m. 29/09/2015, s hj senthile...@gmail.com [firebird-support] wrote: >Occasionally (not always) I get the following error when I run some stored >procedures or views (database objects) that use the LTRIM function: > >--

Re: [firebird-support] For embedded is it enough to just include fbembed.dll in our own install?

At 02:51 p.m. 29/09/2015, Mark Patterson mark.aurel...@gmail.com [firebird-support] wrote: >Hi > >We are translating an accounting application from using MySQL to being single >user. We have tried a couple of other embedded database systems, but they have >limitations that multiply the work we

Re: [firebird-support] How do you hook up Zeos to FB embedded?

At 08:53 p.m. 29/09/2015, Mark Patterson mark.aurel...@gmail.com [firebird-support] wrote: >Hi > >I have put all the DLLs in the same directory as the EXE I am producing.I have >copied fbembed.dll to both fbclient.dll and gds32.dll. I have a TZConnection >with protocol = 'firebird-2.5' Â and w

Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar

At 10:09 a.m. 3/10/2015, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > >I’m using integer IDs for primary keys in my tables. What if I would use >varchar fields instead? Will I lose performance in that case, especially for >big tables? Will joins still work as fast as they

Re: [firebird-support] Using Zeos 7 and FB 2.5, how do you see in main thread changes made in background thread

At 02:05 p.m. 9/10/2015, Mark Patterson mark.aurel...@gmail.com [firebird-support] wrote: >Hi > >I am using Zeos 7.1.4 stable, and FB 2.5 embedded. I am processing a directory >full of SQL scripts to generate a database. All the tables are getting created >in a background thread, but after tha

Re: [firebird-support] basic cursor and firebird psql question

At 06:43 a.m. 13/10/2015, thirdshiftco...@yahoo.com [firebird-support] wrote: >I have 2 questions from the code below. > >Where do you come up with RDB$FIELD_NAME? It is a column in the system table RDB$RELATION_FIELDS. The RDB$-- tables exist in all Firebird databases. They store your metadat

Re: [firebird-support] High CPU use after restore

Re: [firebird-support] Temporary disable FK constraint

Hello Scott, Saturday, November 7, 2015, 4:01:48 AM, you wrote: > I have a feeling that the answer is 'no', but... > In a FB2.5 system is there a way to temporarily disable foreign key > constraints? i.e. something like 'ALTER INDEX ... INACTIVE' Constraints and their indexes, no. A constraint

Re: [firebird-support] Running gfix and gbak from windows service

Re: [firebird-support] How does LIST() work?

Re: [firebird-support] Cannot Connect to FireBird Database from network workstation

Re: [firebird-support] Backaup&Restore error

Re: [firebird-support] Replication SW experience

Sunday, November 29, 2015, 2:08:01 AM, Slavomir Skopalik skopa...@elektlabs.cz wrote: > Thank you, > I was try (IBP Replicator) and I found few problems. This list is for Firebird. Questions about third-party applications are off-topic here. For help with IBP Replicator, please subscribe to th

Re: [firebird-support] How much percentage of a database space is a table contents taking.

Re: [firebird-support] RDB$ADMIN ROLE in security databese

Hello Neagu, Monday, November 30, 2015, 3:58:51 PM, you wrote: > Hi > Firebird 2.5 introduces the RDB$ADMIN ROLE. In the security database, > it means, the ability to create, drop and alter user accounts. For this > we can use SQL command CREATE or ALTER USER with parameter GRANT/REVOKE > ADMI

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote: > That information is also available on the database header page, > which can be extracted by gstat -h Unfortunately, that information is absent from gstat -h, hence my advice to use isql SHOW DATABASE. I can't think why it is mis

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

Re: [firebird-support] What is more effective execute block or select?

Re: [firebird-support] system table behaviour

Re: [firebird-support] I need help.

Re: [firebird-support] how to suppress dashes in query results

Re: [firebird-support] Help to install FB 64 bit

  1   2   3   >