Dear Friends,

I am trying to implement a demo version of my program that uses the
embedded server on a USB drive.
System is Windows XP.
The application runs fine using superserver 1.5.0.4231.
To run it with the embedded server, I put a copy of the Delphi exe file on
the USB drive in F:\SpedDemo, along with a copy of fbembed.dll 1.5.2.4731
renamed to gds32.dll.
Also as detailed in Helen's book, page 18, I have copied firebird.conf into
F:\SpedDemo\fb and aliases.conf into F:\SpedDemo, Firebird.msg into
F:\SpedDemo\fb also fbintl.dll and fbudf.dll in their own subdirectories..
Firebird.conf contains the line "RootDirectory = F:\SpedDemo\fb"

When I run the main app using the embedded server two other TIBOQuerys open
OK, but when I open a TIBOQuery with the SQL
"select ISD, offname, DCODE from state where dcode like '%000' order by 1"
I get the EAccessViolation with message 'Access violation at address
00E4B6ED in module 'gds32.dll'. Read of address 00000000'.

To isolate this problem installed a copy of IB_SQL into F:\SpedDemo. The
table is
CREATE TABLE "STATE" (
ISD CHAR( 2 ) NOT NULL
, DCODE CHAR( 5 ) NOT NULL
, OFFNAME VARCHAR( 50 ) NOT NULL
, CONSTRAINT PK_STATE
UNIQUE ( ISD, DCODE )
)

On the cursor tab of IB_SQL I put the same SQL above. When I prepare this
query I get an Access Violation at 00C3B6ED read of address 00000000,
IB_SQL hangs and has to be killed.

The query "select ISD, offname, DCODE from state " runs OK.

But "select ISD, offname, DCODE from state where dcode > '03000'" results
in an AV at 00C3BB99 read of address 00000000

Also "select ISD, offname, DCODE from state where dcode like '%000' "
results in a Firebird message:

ISC ERROR CODE:335544321

ISC ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation
Implementation of text subtype 21 not located.

What am I doing wrong here? Please help, this is driving me crazy.

Thanks,
Walter



/*
C. Walter Ogston
ogstoncw@...
*/