[firebird-support] Re: fbtracemgr and embedded
--- In firebird-support@yahoogroups.com, Mike Ro wrote: Mark, since v2.5 it is possible to use Firebird embedded without install of full CS package. All you need is to create the almost the same folders layout as with full Firebird package, including bin, intl, lib, plugin, UDF folders and its contents. Create simlink lib/libfbembed.so.2.5 pointing to the lib/libfbembed.so.2.5.2 Remove not needed binaries from bin folder, if necessary Set FIREBIRD to the root folder. Set LD_LIBRARY_PATH to the lib folder (not to the root !) this is all. Good luck, Vlad
[firebird-support] Uninstall of firebird 1.5
Good Afternoon, I have installed firebird 1.5 with a zip file and delete the bat files. I need to uninstall and download a newer version, in order for Omni accounts to work. Regards [cid:imagef1886d.PNG@e1c7da50.47af1cd7] Elize Faber Creditors Clerk Mpact Plastics Tel: (MPSA) +27 (0)11 418 6000 Fax: (MPSA) +27 (0)11 827 6842 Cell: Cnr Dekema and Lantern Road, Wadeville Gauteng 1428 efa...@mpact.co.za www.mpact.co.za Please note: All @mondigroup.co.za email addresses for Mpact Ltd will no longer be available as of the 31st of January 2013. Please make use of the @mpact.co.za email address this email has been sent from or contact your email recipient for more details This e-mail as well as any files transmitted with it is confidential and may well contain information which is legally privileged. It is intended solely for the use of the individual or the entity to whom it is addressed. If you are not the intended recipient of this e-mail, you are hereby on notice of this status. Any disclosure, copying, distribution, dissemination or publication of the information contained therein is strictly prohibited, unless you have been permitted thereto by the sender, and might be a breach of confidence. If you are not the intended recipient, please return this e-mail immediately to the sender and then delete this message from your system. The sender is not liable for the proper transmission of this information nor for any delay in its receipt. [Non-text portions of this message have been removed]
[firebird-support] RE: Uninstall of firebird 1.5
I have installed firebird 1.5 with a zip file and delete the bat files. I need to uninstall and download a newer version, in order for Omni accounts to work. Hi Elize, You need to follow the Omni upgrade instructions we gave you. And follow instructions received from Omni support, not a general Firebird newsgroup. Maya
Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in
On Thu, 14 Mar 2013 10:00:17 -0500, SoftTech mi...@softtechks.com wrote: Greetings All, I would like to pass in a string and a substr and the position of where the x occurrence is. Example: String: Then the big red fox jumped over the flowing stream. SubStr: the occurrence: 2 Would return 34 which is the starting position of the second the found in the string passed in. Anything like this available anywhere? You can use POSITION(...) http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-position.html but you will need to keep track of the number of occurrences yourself. Mark
Re: {Disarmed} Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in
Thanks Mark, Guess I should have stated that I need this for Firebird 1.5 Mike - Original Message - From: Mark Rotteveel To: firebird-support@yahoogroups.com Sent: Thursday, March 14, 2013 10:05 AM Subject: {Disarmed} Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in On Thu, 14 Mar 2013 10:00:17 -0500, SoftTech mi...@softtechks.com wrote: Greetings All, I would like to pass in a string and a substr and the position of where the x occurrence is. Example: String: Then the big red fox jumped over the flowing stream. SubStr: the occurrence: 2 Would return 34 which is the starting position of the second the found in the string passed in. Anything like this available anywhere? You can use POSITION(...) http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-position.html but you will need to keep track of the number of occurrences yourself. Mark -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. [Non-text portions of this message have been removed]
Re: {Disarmed} Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in
On Thu, 14 Mar 2013 10:29:56 -0500, SoftTech mi...@softtechks.com wrote: Thanks Mark, Guess I should have stated that I need this for Firebird 1.5 I'd say: starting migrating ;) You could look at FreeAdhocUDF. It has several functions that are similar to POSITION (for example F_SUBSTR ), see http://freeadhocudf.org/documentation_english/dok_eng_string.html Mark
[firebird-support] Stored Procedure or Function to find a carraige return in a string
Firebird 1.5 Anything available to find an ASCII_CHAR(13) in a given string and return the position of it? Thanks, Mike
Re: [firebird-support] Stored Procedure or Function to find a carraige return in a string
On Thu, 14 Mar 2013 10:47:57 -0500, SoftTech mi...@softtechks.com wrote: Firebird 1.5 Anything available to find an ASCII_CHAR(13) in a given string and return the position of it? I think the answer is the same as my answer to your previous question :) Mark
[firebird-support] gbak restore error
Does anyone know what this error from gbak is? Done with volume #1, /mnt/usb/firebird/clone.fbk Press return to reopen that file, or type a new name followed by return to open a different file.
Re: [firebird-support] gbak restore error
Rick, No space left on the disk. Regards, Alexey Kovyazin IBSurgeon Does anyone know what this error from gbak is? Done with volume #1, /mnt/usb/firebird/clone.fbk Press return to reopen that file, or type a new name followed by return to open a different file. [Non-text portions of this message have been removed]
RE: [firebird-support] Using Firebird SuperClassic and Embedded (SC) v2.5 on same server
LS External applications use a normal users, our internal LS applications use SYSDBA. We want to even control our own LS applications from accessing the database Single shutdown mode allows only one connection (from SYSDBA or OWNER), so if you are able to assure that your maintenance app will put the DB in Single Shutdown mode and be the first one to connect to it just after that, you would be safe. Thanks for the reminder. There are other reasons why we want to have both instances installed. I am looking for *details about the gotchas* (I think I recall a post about an environment variables for the lock manager), not about the alternate approaches. Sean
Re: [firebird-support] Stored Procedure or Function to find a carraige return in a string
Thanks Mark, You are correct that works. - Original Message - From: Mark Rotteveel To: firebird-support@yahoogroups.com Sent: Thursday, March 14, 2013 10:50 AM Subject: {Disarmed} Re: [firebird-support] Stored Procedure or Function to find a carraige return in a string On Thu, 14 Mar 2013 10:47:57 -0500, SoftTech mi...@softtechks.com wrote: Firebird 1.5 Anything available to find an ASCII_CHAR(13) in a given string and return the position of it? I think the answer is the same as my answer to your previous question :) Mark -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. [Non-text portions of this message have been removed]
[firebird-support] Install Firebird SS in Ubuntu Linux by apt-get or tar.gz /install.sh
I'm installing Firebird Super Server version 2.5.2 on Linux Ubuntu. 1. Install by apt-get or 2. Download the file FirebirdSS-2.5.2.26539-0.i686.tar.gz and install by ./install.sh Which option do you recommend? Which option most used in business?