[firebird-support] Re: RES: Version number
22.11.2012 10:57, Maya Opperman wrote: I thought I would only START to see the problem if I went from 2.5.1 to 2.5.2 (without rebuilding). This is also possible, but only if you migrate not to the official v2.5.2 release but to some earlier snapshot build. Dmitry
[firebird-support] Parameter in select statement possible?
Hello, is it possible to use parameters within the select statement? Something like select cast (:PATH || FILENAME as varchar(255)) as FILEPATH from SOME_TABLE Best regards, Patrick
Re: [firebird-support] Parameter in select statement possible?
is it possible to use parameters within the select statement? Something like select cast (:PATH || FILENAME as varchar(255)) as FILEPATH from SOME_TABLE Yes, but I guess you will get an error at prepare time. You explicitely have to specify what data type the :PATH parameter is, e.g. with: select cast (:PATH as varchar(255)) || FILENAME as filepath from SOME_TABLE -- With regards, Thomas Steinmaurer http://www.upscene.com/
[firebird-support] Re: Parameter in select statement possible?
Hi, question is where are you using this? stored proc .. Karol Bieniaszewski --- In firebird-support@yahoogroups.com, patrick_marten patrick_marten@... wrote: Hello, is it possible to use parameters within the select statement? Something like select cast (:PATH || FILENAME as varchar(255)) as FILEPATH from SOME_TABLE Best regards, Patrick
Re: [firebird-support] Re: RES: Version number
This is also possible, but only if you migrate not to the official v2.5.2 release but to some earlier snapshot build. Dmitry One question Dimitry. We have some quite large databases and cannot do a backup restore cycle. Also rebuild indices may take so much time. What kind of indices has to be rebuilded? All? Compound indices? Compound indices with nullable fields? If not doing backup/restore, rebuild PK indices is complicated. [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird connection from win 7 home basic
On 21-11-2012 14:37, Federico wrote: Hi All, I have a firebird 2.1.2 database running on a Windows 2003. I already have windows xp clients, also windows 7 64 bits profesional, all logged into the same domain as the server and every one using ODBC conections. But I want to connect a Win 7 64 bits home basic to that firebird database. Using Firebird Client (ODBC) I cannot open a conection to the firebird server. I also tried Flamerobin with no success... I can get access to the shared, but not to the database. did anyone had this problem before? Is this because of the domain restriction of win7home? Is there any tool to help me diagnosing this issue? thanks a lot!! It looks like my comment on the stackoverflow question http://stackoverflow.com/questions/13495273/firebird-odbc-windows-7-home already solved the issue. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird on Windows 8
On 21-11-2012 20:40, heineferreira wrote: Hi Do you have any plans to put Firebird and the database drivers and flamerobin into the windows 8 app store? Aparantly there are major issues with sideloading in windows 8. You can install Firebird and Flamerobin without issue on Windows 8. The only thing I encountered was a little more severe warning because the Firebird installer isn't signed. As far as I know, sideloading only refers to installing Windows Metro (aka Modern UI) applications, not to normal Windows applications like Firebird and Flamerobin. Mark -- Mark Rotteveel
Re: [firebird-support] Re: RES: Version number
This is also possible, but only if you migrate not to the official v2.5.2 release but to some earlier snapshot build. Dmitry One question Dimitry. We have some quite large databases and cannot do a backup restore cycle. Also rebuild indices may take so much time. What kind of indices has to be rebuilded? All? Compound indices? Compound indices with nullable fields? I would say nullable compound indices, but Dmitry might have the ultimate answer. ;-) If not doing backup/restore, rebuild PK indices is complicated. The following used to work rebuilding a PK index: alter index pk_index active; The trick is to set the index active, even if it is already active. ;-) -- With regards, Thomas Steinmaurer http://www.upscene.com/
[firebird-support] Re: RES: Version number
22.11.2012 14:35, Thomas Steinmaurer wrote: I would say nullable compound indices, but Dmitry might have the ultimate answer. ;-) Absolutely correct. Dmitry
Re: [firebird-support] Firebird on Windows 8
Hi, At November-22-12, 6:31 AM, Mark Rotteveel wrote: On 21-11-2012 20:40, heineferreira wrote: Hi Do you have any plans to put Firebird and the database drivers and flamerobin into the windows 8 app store? Aparantly there are major issues with sideloading in windows 8. You can install Firebird and Flamerobin without issue on Windows 8. The only thing I encountered was a little more severe warning because the Firebird installer isn't signed. We encountered the same thing with our application. Now that our installer is signed, we no longer have an issue. As far as I know, sideloading only refers to installing Windows Metro (aka Modern UI) applications, not to normal Windows applications like Firebird and Flamerobin. You are correct in stating that it only relates to Modern UI apps and not Desktop apps. The only edition of Windows 8 that allows sideloading of Modern UI apps is with the Enterprise edition(which is only available via volume licensing). And, the confusion might come from the requirements to be able to have a desktop application listed on the Windows App Store, where the application has to be compiled using the SEH compiler option(to pass the test). Yet, the listing on the App Store is only a link to the application's website to download the installer. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com)
[firebird-support] Backup problem when different client libraries connected to DB?
Hi there, We have a Linux server (64 bits OS) running Firebird 1.5.6 (32 bits) serving a 2GB Firebird database. We have a variety of legacy and recent client applications connecting to the database, some using Borland's BDE, other use the Firebird DotNet provider, we have IBExpert and some others clients use Zeos components. At any given moment we have around 100 concurrent users connected to the database. I've noticed that when I run a backup from the Linux console using gbak, the backup does not end normally, it crashes with an error message. But if I try the backup after hours when only two or three users connected to the database, the backup ends normally. We have a second Windows 2008 server running a similar setup(Fb 1.5.6, around 100 client connections, 2GB+ database.) In this server, IBexpert does not have any problems backing up the database, regardless of the number users connected to it. I can't recall where did I read that the problem might lie in the connection libraries, IIRC, if there are many different client libraries connected, the linux libraries used by gbak might have a problem backing up the database. Might this be the case here? Any thoughts or opinions are welcome. Best Regards, -Jorge P.S. We know we should upgrade to Fb 2.5, unfortunately our main legacy system does not support it right now. We have a migration plan for the next 6 months to accomplish this though.
RE: [firebird-support] firebird process hangs every aprox 10 days
susi (Server) Tue Nov 20 15:42:27 2012Modifying procedure SP_CARGA_LIQ_HABERES_DET which is currently in use by active user requests I don't know anything about this part of Firebird, but the error message above sounds like someone is doing some data definition (ALTER PROCEDURE SP_CARGA_LIQ_HABERES_DET ...) whilst the procedure is in use (i.e. data manipulation) and to me that is like trying to fix the motor whilst the car is driving... What is your system doing? Set
RE: [firebird-support] Re: DB w/ 16kb page site and BLOB fields size w/ content just 40bytes by record
22.11.2012 1:16, Leyne, Sean wrote: If that size is less than the free space on the data page, then the blob would be stored with the data, taking only 40 bytes. I'd say it gonna take 8 bytes per blob id + up to 8 bytes per alignment (both compressed) + 28 bytes per blob header (uncompressed) + 40 bytes of data (uncompressed). Picky, picky, picky ;-] I never knew that a blob had up to 44 bytes of overhead, which needs to be considered when thinking about if the blob can fit on the data page, and not need its own blob page(s). Sean
[firebird-support] Re: Backup problem when different client libraries connected to DB?
22.11.2012 19:38, Benton Quest wrote: I've noticed that when I run a backup from the Linux console using gbak, the backup does not end normally, it crashes with an error message. What is the error message? What is the gbak command line? Dmitry
[firebird-support] I want to store encrypted passwords in a VARCHAR(50) field
I am using Delphi 7 and CryptoPressStream. When encrypted, the encrypted string could include control type characters that I'm worried could mimic an End of Record character. Is there any danger that the encrypted password string, when stored in the DB, could corrupt the table or DB? Should I use a different field type than VARCHAR(50) ? (Not sure if I want to use a BLOB SUB_TYPE 0 field for this... seems overkill) Thanks in advance for any help you can provide.