Search found 5 matches

by MN7
13.09.2019, 17:49
Forum: ZeosLib 7.2 Forum
Topic: Can't open old database with Firebird 1.5-2.1
Replies: 2
Views: 263

Re: Can't open old database with Firebird 1.5-2.1

I'm use embedded dll (x86). My DB is test DB from book about Delphi 7. My code was 'ZConnection.HostName := 'localhost';'. When I change HostName to '' (empty) Zeos can open that DB. (FB 1.5 and 2.1 tested). But. My second DB is test DB from book about Delphi 5. And Zeos raise same error! Changing H...
by MN7
13.09.2019, 17:41
Forum: ZeosLib 7.2 Forum
Topic: Firebird BYTES data type not compatible with TBlobStream
Replies: 4
Views: 356

Re: Firebird BYTES data type not compatible with TBlobStream

XE4. But test from scratch get new info. procedure Test; var ZC: TZConnection; ZQ: TZQuery; BlobStream: TStream; B: TBytes; begin ZC := TZConnection.Create(nil); try ZQ := TZQuery.Create(ZC); ZQ.Connection := ZC; ZC.Protocol := 'interbase'; ZC.User := 'SYSDBA'; ZC.Password := 'masterkey'; ZC.LoginPr...
by MN7
11.09.2019, 11:13
Forum: ZeosLib 7.2 Forum
Topic: Firebird BYTES data type not compatible with TBlobStream
Replies: 4
Views: 356

Re: Firebird BYTES data type not compatible with TBlobStream

For me works "f.AsBytes".
But "BlobStream := FZQuery.CreateBlobStream(f, bmRead);"
just crashed, not raise EZNotSupported or so (for example).
by MN7
09.09.2019, 11:42
Forum: ZeosLib 7.2 Forum
Topic: Can't open old database with Firebird 1.5-2.1
Replies: 2
Views: 263

Can't open old database with Firebird 1.5-2.1

Zeos can't open old database with old Firebird (2.0 for example). Tables can be acquired with ZConnection.GetTableNames. But next Zeos can't get data with ZQuery or ZTable: raise EZSQLException: SQL Error: Dynamic SQL ErrorSQL error code = -206Column unknownB.RDB$FIELD_PRECISIONAt line 1, column 249...
by MN7
09.09.2019, 11:22
Forum: ZeosLib 7.2 Forum
Topic: Firebird BYTES data type not compatible with TBlobStream
Replies: 4
Views: 356

Firebird BYTES data type not compatible with TBlobStream

BYTES field raises error 'Exception TZAbstractCLob in module Test.exe at 00000000007623A6.' in this code: BlobStream := FZQuery.CreateBlobStream(f, bmRead); try BlobSize := BlobStream.Size; BlobStream.Read(BlobMem^, BlobSize); finally BlobStream.Free; end; BYTES data field have for example security3...