Search found 5 matches
- 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...
- 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...
- 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).
But "BlobStream := FZQuery.CreateBlobStream(f, bmRead);"
just crashed, not raise EZNotSupported or so (for example).
- 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...
- 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...