Search found 1934 matches
- 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...
- 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...
- 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...
- 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!
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!
- 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?
Consider the Component isn't depply tested. Could you add some tests, plz?
- 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!
Hope we did not break anything on the non Windows-targets?!
Thank you both for yours help!
- 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.
- 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.
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.
- 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...
- 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...
- 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...
- 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 ...
- 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.
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.
- 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...
However please take attantion to viewtopic.php?f=50&t=125819 or i'll close the ticket...
- 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,...