Search found 1934 matches

by EgonHugeist
03.11.2020, 06:37
Forum: ZeosLib 7.3/8.0 Forum
Topic: Performance issue using ADO.
Replies: 13
Views: 676

Re: Performance issue using ADO.

Hello Mark, the ADO bridge is a "simple" user front end made by MS. I also noticed those performance penalties using that protocol. Some more infos: Since SQLServer 2005 the protocol talks UCS2/UTF16 only so using FreeTDS with Unicode-Compilers has the side effect that FreeTDS makes W2A co...
by EgonHugeist
29.10.2020, 19:33
Forum: ZeosLib 7.3/8.0 Forum
Topic: Driver loading issue when connecting to PostgreSQL after connecting to Oracle
Replies: 31
Views: 2495

Re: Driver loading issue when connecting to PostgreSQL after connecting to Oracle

@Mark, thanks for confirmation! That's allways helpful. @aehimself all platforms except UNIX such as DARWIN (OSx) ANDROID [ANDROID32,ANDROID64]/Delphi AARACH64/FPC etc. so it's not worth it bypassing the issue by reimplementing the Windows idea of LoadLibrayEx. As i said: We're happy the issue is re...
by EgonHugeist
29.10.2020, 19:20
Forum: ZeosLib 7.3/8.0 Forum
Topic: binary data shifted
Replies: 9
Views: 343

Re: binary data shifted

Still not able to reproduce your ussue. So give me all informations of: 1. Exact Version and ProductName of the Server 2. Exact Version and ProductName of the Compiler 3. Exact Version and ProductName of the library or OLEDB/ODBC version you are using. On my side all tests are passing, that's annoyi...
by EgonHugeist
28.10.2020, 19:11
Forum: ZeosLib 7.3/8.0 Forum
Topic: Driver loading issue when connecting to PostgreSQL after connecting to Oracle
Replies: 31
Views: 2495

Re: Driver loading issue when connecting to PostgreSQL after connecting to Oracle

@both constributors,
i just added a fallback using a define. I'm not aware how to resolve the issue on other platforms except using the default code. Let's wait for a new ticket or forum thread. Anyway thank's for your help and support!
by EgonHugeist
28.10.2020, 18:58
Forum: ZeosLib 7.3/8.0 Forum
Topic: How to handle transactions properly with Zeos?
Replies: 19
Views: 2710

Re: How to handle transactions properly with Zeos?

@Fr0st
Consider the Component isn't depply tested. Could you add some tests, plz?
by EgonHugeist
28.10.2020, 05:56
Forum: ZeosLib 7.3/8.0 Forum
Topic: Driver loading issue when connecting to PostgreSQL after connecting to Oracle
Replies: 31
Views: 2495

Re: Driver loading issue when connecting to PostgreSQL after connecting to Oracle

Thank you both for looking into that issue. I think i was running into same trap long time ago, IIRC.

Hope we did not break anything on the non Windows-targets?!
Thank you both for yours help!
by EgonHugeist
28.10.2020, 05:52
Forum: Oracle
Topic: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object
Replies: 16
Views: 1403

Re: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object

Could you condider to write some more examples for other providers? IIRC are you using MYSQL and SQLServer too. It would be nice to have a valid testcase in our suites for all drivers.
by EgonHugeist
18.10.2020, 10:49
Forum: ZeosLib 7.3/8.0 Forum
Topic: binary data shifted
Replies: 9
Views: 343

Re: binary data shifted

Me again,

What's the TField.DataType? If it's ftBytes than that's done by compiler. I added a testcase to see if Zeos correctly is able to determine BINARY/VARBINARY. Yet no issues to see.
by EgonHugeist
18.10.2020, 08:51
Forum: Oracle
Topic: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object
Replies: 16
Views: 1403

Re: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object

Thanks for the afford and the memory-leak lessons :P. Well i was to many steps forward. My test case was a bit more verbose and did include Open[Connection,Transaction,ResultSet,Lob's]. But yes, you are right, it did not hit your example, which is is the "abnormal case", i think, but needs...
by EgonHugeist
17.10.2020, 11:02
Forum: Oracle
Topic: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object
Replies: 16
Views: 1403

Re: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object

Hmm, what's the ErrorCode returned by zeos? In my case i get an 3113 error. Let me explain: To get the ImmediatelyReleasable logic running the "connection lost" error-code need to be known. That than means if TZOracleConnection.HandleErrorOrWarning get's as first error 3113 or 3114(found i...
by EgonHugeist
17.10.2020, 10:18
Forum: ZeosLib 7.3/8.0 Forum
Topic: Oracle protocol and string params
Replies: 5
Views: 359

Re: Oracle protocol and string params

Hello Mark, thank's for the details. Seems all the features i made are not perfect @all. Should by fixed by https://sourceforge.net/p/zeoslib/code-0/6972/ . Please report your findings. Btw. It's a bad practice using Variable types (strings/bytes) without spezify the maximum size for drivers like Or...
by EgonHugeist
16.10.2020, 17:41
Forum: Oracle
Topic: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object
Replies: 16
Views: 1403

Re: Zeos 7.3-200a1058, Oracle ungraceful disconnect leaks a TZOracleTransaction object

Hi AE yes himself, nice example. Reason for the failing logic was a unknown OCI error code. However: We german say: "Eine Hand spuckt in die Andere", means if you help us we help you. Patch done https://sourceforge.net/p/zeoslib/code-0/6966/ . Iv'e been doing deeper teast than just having ...
by EgonHugeist
15.10.2020, 19:01
Forum: ZeosLib 7.2 Forum
Topic: Access Violation in TZAbstractDatabaseMetadata.Destroy
Replies: 4
Views: 235

Re: Access Violation in TZAbstractDatabaseMetadata.Destroy

@Jan
That would be impossible.
IIRC AB(Arnoud Baouchez) allows a single thread only for Firebird(don't know why). Reject to the mORMot forum. Ask there for help.
by EgonHugeist
15.10.2020, 18:26
Forum: ZeosLib 7.3/8.0 Forum
Topic: I have truble with TZQuery.CachedUpdates := True in my project
Replies: 7
Views: 386

Re: I have truble with TZQuery.CachedUpdates := True in my project

Fixed as suggested (my FPC's didn't show that compilation error). Thanks.
However please take attantion to viewtopic.php?f=50&t=125819 or i'll close the ticket...
by EgonHugeist
15.10.2020, 06:22
Forum: OleDB (Microsoft Windows)
Topic: SQL-Server OleDB TransactIsolationLevel Read../None
Replies: 2
Views: 444

Re: SQL-Server OleDB TransactIsolationLevel Read../None

Hello Norbert, according the TransactionIsolationLevel: tiNone will be mapped to ISOLATIONLEVEL_CHAOS it's documented by Microsoft. SQLServer simply doesn't support that isolation level. Is there a reason why you'r doing that? What do wanna to achieve? IMO just use higher levels, and that just once,...