> 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"

your table (below) is defined as "STATE", you cannot select from state - do
you have another table in that DB named "state"?
Can you execute

"select ISD, offname, DCODE from "STATE" where dcode like '%000'
order by 1"
?
Alan

> 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