Hello everybody, I've tried to write with Freepascal a UDF for Firebird. library udf_upper; {$mode DELPHI}{$H+} {$PACKRECORDS C} uses Classes { you can add...
... For the archive: The firebird2.0 packages essentially work on Debian. I just had to re-run the package configuration as for some reason the database admin...
Good day to everyone and all the best for 2008. I have a connection problem or an aliases.conf problem. When connecting to a database on the server using the...
Additionally, when you declare the UDF as FREE_IT you must have allocated the return buffer with the ib_util_malloc method. If you remove FREE_IT from the...
Svend Meyland Nicolai...
news@...
Jan 2, 2008 9:19 am
91426
... Yup. The alias has to be a filesystem path alias, not an alias for the whole connection string. Define as: PORTMAN = F:\DATABASES\PORTMAN.FDB And have the...
Now that I reread it I can't see it either. I got fooled by udf compared to utf. You get the same error if Firebird can't find the UDF DLL. Where have you ...
Svend Meyland Nicolai...
news@...
Jan 2, 2008 1:21 pm
91430
... Sorry, I overlooked the subject, that said you were writing it in FreePascal. So maybe the syntax for your exports statement is OK (I just don't know,...
I'm using Firebird 2.0.3 in an OpenSuse 10.3 environment. I use Freepascal 0.9.24 and placed the file in /opt/firebird/UDF Klaus ... compared to ... have you...
Well I don't have any experience with neither OpenSuse nor Free Pascal but: *) Have you checked the UdfAccess setting in firebird.conf? *) What is the filename...
Svend Meyland Nicolai...
news@...
Jan 2, 2008 4:49 pm
91433
Hi Guys, I'm trying to troubleshoot a poor performance issue with a firebird DB based app for a client. They are running a 15 GB database, ~40 users, on a...
Richard Ap-Thomas
RichardA@...
Jan 3, 2008 7:00 am
91434
... Raid5 on a single drive? Howzat? Are there external drives not mentioned? If you *really* have only one drive, disable the Raid5 driver, in case it is...
I have a table with ID field defined as PK. ID is integer, i have a generator, and putting a value for ID manually from the client application. Now i need to...
Hi, ... You can drop the primary key by ALTER TABLE <mytable> DROP CONSTRAINT <name> Then add the new PK by using ALTER TABLE <mytable> ADD CONSTRAINT...
We have a program that regularly generates an error when executing the update SQL below when running overnight and its the only active program/connection...
Hi, I am running Firbeird 1.54 on opensuse linux 10.2. Open of my databases has corrupted (I assume) and give the following error when I attempt to access it: ...
Hi Richard! Just to be certain - you have checked the queries of the app itself? Poor design (e.g. asking for all too many rows or count to show a progress...
... completed ... another application (such as isql or some other tool)? Helen Borrie and Edwin Pratomo --- Since I started this thread back in November 2007,...
Replies inline... (resending, dont think the last couple got through) ... Yes sorry I meant a single raid5 drive as seen by the OS, 3 physical drives (thanks...
Richard Ap-Thomas
RichardA@...
Jan 3, 2008 11:17 pm
91443
... Unfortunately I'm no DBA and wouldn't know how to even start. We are however hassling the software company who's app it is and they are looking at/fixing...
Richard Ap-Thomas
RichardA@...
Jan 3, 2008 11:17 pm
91444
Here is the gstat info... Database header page information: Flags 0 Checksum 12345 Generation 911108 Page size...
Richard Ap-Thomas
RichardA@...
Jan 3, 2008 11:21 pm
91445
... Er...no...it's 24576000 bytes, or 23 MB per process!! I wrote "Something around 300K would be the maximum". Chop the cache size back to 75 pages and see...
... DBAs can't fix bad application code. Still, if you're not the creator of the application or the database, it's not a great idea to be fiddling around with...
... Sorry I was just doing the conversion exactly as you quoted and didn't ... Page size 8192 Page buffers 3000 8192 x 3000 / 1024 = 24000 ... I honestly wish...
Hey, thanks for the answer! I haven't set UdfAccess in my firebird.conf. That's why all others didn't work. I still couldn't get it to work because the string...
