[firebird-support] Re: FB252 with PHP5.4.10 Apache 2.2.22 gives PHP Warning: PHP Startup: Unable to load dynamic library C:\Program Files (x86)\PHP\ext\php_interbase.dll

2012-12-30 Thread tomsee7
Hi, These two links may help: http://www.sitepoint.com/forums/showthread.php?676233-php_mysqli-dll-is-not-a-valid-Win32-Application http://board.phpbuilder.com/showthread.php?10371443-RESOLVED-php-and-mysql-wont-talk-to-each-other HTH, Tom --- In firebird-support@yahoogroups.com, nenhumpois

[firebird-support] Re: FB252 with PHP5.4.10 Apache 2.2.22 gives PHP Warning: PHP Startup: Unable to load dynamic library C:\Program Files (x86)\PHP\ext\php_interbase.dll

2012-12-27 Thread tomsee7
Hi Nenhum, We had this problem once and found that by putting the fbclient.dll in the same folder as php.exe fixed it. Kind regards, Tom --- In firebird-support@yahoogroups.com, Nenhum Pois é nenhumpois@... wrote: Hello, I am trying to use Firebird 2.5.2.26539 with: Windows 8

[firebird-support] Comparing databases using scripts generated from isql -extract?

2012-10-13 Thread tomsee7
Hi, Does anyone of any tools for comparing databases using scripts generated from the isql -extract command? This seems to be the most convenient way (i.e. comparing scripts) and must be a common need. The ones that I've come across seem to want you to be connected to one or more of the

[firebird-support] Re: unable to allocate memory from operating system

2012-05-21 Thread tomsee7
Hi John, Something to look at is any heavy use of blobs and long-running transactions within the application as these may point to your problem. HTH, Tom --- In firebird-support@yahoogroups.com, dr_john_mp dr.john@... wrote: Our main database is Firebird 2.1 running on a windows 2k8 server

[firebird-support] Re: selecting between dates with timestamps fields

2012-02-06 Thread tomsee7
--- In firebird-support@yahoogroups.com, Sergio H. Gonzalez shg_sistemas@... wrote: Hello! I have a timestamp field with an index how can I select the fields from a given date, but using the index? If I do: where ((cast (MyTimeStamp as date)) between :from_date and :to_date) I

[firebird-support] Use of indexes

2011-12-27 Thread tomsee7
Can anyone explain why FB uses all 3 in the OR query yet only 2 in the AND query (See definitions below)? Thanks, Tom CREATE INDEX I_TARGET_COMPANY ON TARGET COMPUTED BY (UPPER(COMPANY)); CREATE INDEX I_TARGET_FIRSTNAME ON TARGET COMPUTED BY

[firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread tomsee7
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe kjell.rilbe@... wrote: Den 2011-11-09 10:31 skrev canacourse såhär: Kjell, Doesn’t using the dot separator imply that non us date formats are being

[firebird-support] Re: How to update this table?

2011-10-07 Thread tomsee7
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On 7-10-2011 11:12, tomc777 wrote: There's no way subselects can be materialized, at least doing .. My use of the term 'materialized' may have been misunderstood, it was meant to relate to whether/how the