Using Delphi XE2 to write a 64-bit UDF with BLOBs
We are upgrading a product to Interbase XE (x64) and we use a UDF with BLOBs (written in Delphi).
Previously (in x86 land) we have used the TBlob definition in IBExternals to allow GetSegment and PutSegment with blobs in the UDF, but in this causes an AV when we build a the UDF as a Win64 DLL in Delphi XE2 for Interbase XE (64-bit on Win7 Pro).
All the other UDF functions work correctly. The TBlob definition from XE2 is below - what is wrong?
TISC_BlobGetSegment = function(BlobHandle: PInt;
...Interbase XE 32 bits on windows 64 bits
I have my database which was built with Interbase XE 32 bits. Can it run
with no problem if I install it on a computer with windows 64 bits and
Interbase XE 64 bits?
EKPINI Arsene Mamert wrote:
> I have my database which was built with Interbase XE 32 bits. Can it run
> with no problem if I install it on a computer with windows 64 bits and
> Interbase XE 64 bits?
Yes the .ib/gdb file does not care if the server using it is 32 or 64 bit. The
DB itself is bit neutral.
UDF dlls though will need to match the bitness of the server.
Jeff Overcash (TeamB)
...Bug in Interbase XE 32 bits Update 3 on Windows 64 bits platform
On Interbase XE 32 bits Update 3 (WI.10.0.3.566) on 64 bits Windows platforms.
If you have a big VARCHAR field (like VARCHAR(4096)) in a table and for exemple read this table row by row with the same query that you prepare only on the first time you execute it, IB return no record half the time !
_*To reproduce the bug :*_
*1 - Create a simple DB with the folowing SQL script :*
SET SQL DIALECT 3;
SET NAMES ISO8859_1;
CREATE DATABASE 'C:\Temp\IBBugPrepare.GDB'
USER 'SYSDBA' PASSWORD 'masterkey'
DEFAULT CHARACTER SE...Interbase XE3 and Interbase XE
On Embarcadero online shop I see there is the *Interbase XE3 server* and the *Interbase XE server*. What's the difference? Maybe one is 64 bit and the other 32 bit?
Roberto Colpani wrote:
> On Embarcadero online shop I see there is the *Interbase XE3 server* and the *Interbase XE server*. What's the difference? Maybe one is 64 bit and the other 32 bit?
> Thank yow.
XE3 is the latest version, XE is the version before it. Both come in both 32
and 64 bit.
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
And so I ...Setting Page Buffers in Interbase XE 64-bit
We have a Interbase XE 64-bit server with 8Gig of ram. We will be running only a single database on this server, using a page size of 16K.
I see in the documentation that the maximum page buffers for 64-bit XE appears to be 75 million pages. (up from 750,000 in previous editions).
If we want to use a large amount of ram, say 4 gig for page buffers, could we set the page buffers at 262144?
(i.e. page buffers 262144 * page size 16384 = 4gigabytes)
Is there some other system limitation that would prevent this? I saw that there used to be CPU problems with setting the page buffers up to...InterBase XE 64 bit edition now available!
Seems like a major milestone to me that we have finally delivered a 64
bit version! The trial and developer editions are available for download.
Note that InterBase XE developer edition serial numbers work for both 32
bit and 64 bit. These serial numbers come with multiple registrations.
InterBase XE trial edition comes with separate serial numbers for 32 bit
and 64 bit editions as trials only allow for 1 registration.
New or upgrade purchasers of InterBase XE get 1 serial number which can
be used with either the 32 bit or 64 bit edition, both of which are
included with your...UDF date functions in Interbase XE3 64-bit
I'm having trouble with date UDF functions in Interbase XE3 64-bit. We
have used the 32-bit version of FreeUDFLib.dll for years, and I'm trying
to get all of the functions working on 64-bit. I have replaced all
PChar with PAnsiChar, etc. to make the string functions such as Upper()
These all work fine, except when I add a date function to the export
section, such as AddMonth(), which takes a parameter of type PISC_QUAD.
It compiles just fine, but when I try to use it it gives me the error:
invalid request BLR at offset 59.
function F_ADDMONT...Has anyone used 64-bit ODBC Driver with Interbase XE
Have seen a few people refer to the possibility of using a 64-bit ODBC driver (such as the Easysoft driver) with Interbase XE.
Am interested to know if anyone here has actually used this or another 64 bit driver and what the results were. (Performance gains, recoding needed if any, etc...)
(The only other 64-bit ODBC driver I'm aware of is the one for Firebird and haven't used that yet either.)
Any comments appreciated,
Dale Gunter wrote:
> Have seen a few people refer to the possibility of using a 64-bit ODBC driver (such as the Easysoft driver) ...32 bit Service
I'm trying to get my 32 bit Service interact with Interbase 64 bit.
The installation suucceded. But when i start the Service I got the following
What have I missed?
Faulting application name: StoreXMLtrlog.exe, version: 188.8.131.52, time stamp:
Faulting module name: KERNELBASE.dll, version: 6.1.7601.17651, time stamp:
Exception code: 0x0eedfade
Fault offset: 0x0000b9bc
Faulting process id: 0x1294
Faulting application start time: 0x01cce7104d829c00
Faulting application path:
Faulti...Backup-Restore needed when migrating from Interbase 2009 to XE 64-bit? [Edit]
We want to migrate our database from Interbase 2009 to Interbase XE 64-bit.
I have noticed that Interbase XE can connect directly to the file from Interbase 2009 (without backup-restore), but would anyone advice us not to do that?
The reason why it would be nice not to have to do backup-restore is 1) that the size of the database grows from around 27 GB to around 34 GB, and 2) the time we have to take down the system for doing this (around 12h)
(BTW, it was necessary to run the readmeta.sql found in examples\security in order to be able to get a working DB-file after the backu...Interbase XE Connection from PHP 5.3 ibase_connect on Linux 64 Bit
we trying to connect from a Linux 64 bit maschine via PHP 5.3 ibase_connect to an external Interbase XE Server.
A connection isn't possible. Username and password are wrong the server replies. But they are correct on the Interbase Server.
What have we to do to connect to the server?
Mike Schaller wrote:
> we trying to connect from a Linux 64 bit maschine via PHP 5.3 ibase_connect to an external Interbase XE Server.
> A connection isn't possible. Username and password are wrong the server replies. But they are correct on the Interbase Server.
Look to see what...InterBase XE 64 Bit server crashes on some SQL statements
Testing InterBase XE 64 Bit on a Windows 2008 64 bit system, from a Delphi client on Windows 7 (64 bit) and Windows 2000 (32 bit), I found that some SQL statements always caused the server to terminate.
TSSQLSVR (Server) Wed Dec 15 14:08:34 2010
SELECT POS_TEXT FROM LOADLIST_RECH_POS WHERE FK_SQLNR=? AND FK_POSTENART=?
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the InterBase server
to terminate abnormally.
CREATE TABLE LOADLIST_RECH_POS (
LOADLIST_RECH_POS_ID...Interbase server name in Interbase XE
I am trying in code to get connected to Interbase XE.
To do so , I used to the following in C++ Builder XE :
//User creation in Interbase
myIBSecurity->ServerName = "Local Server";
myIBSecurity->LoginPrompt = false;
myIBSecurity->Active = true;
where myIBSecurity is an instance of TIBSecurityService.
This code is giving me an error message, it cannot find the server name "Local Server".
In Interba...IBX (Delphi XE), Interbase XE and character set UTF8
I'm trying to get Interbase and IBX running with an UTF8 database. I'm using Delphi XE and Interbase XE.
I'm creating the database like this:
aIBDatabase.DatabaseName := 'test_utf8.ib'
aIBDatabase.Params.Add('DEFAULT CHARACTER SET utf8');
The fields in the tables were created as VARCHAR.
The database really seems to use character set utf8, because with IBExpert I'm able to set and r...