Search found 784 matches
- 17.11.2024, 16:57
- Forum: Oracle
- Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
- Replies: 34
- Views: 2540
Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Can you narrow it down to the exact record or column that causes the problem? I don't know how much you changed the buffer logic, but previously it was not possible. It was not one record, but the amount of data handled UNTIL a specific number of records... I remember changing the order by, adding ...
- 17.11.2024, 13:49
- Forum: MySQL
- Topic: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp
- Replies: 3
- Views: 67
Re: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp
Searching around pops different error messages for the same source file in .net so I'm not sure in which direction to go. It would be nice to have a full exception message and a stack trace. I suspect a .net issue - my guess is the new library was written in that. As you are connecting to MariaDB, c...
- 14.11.2024, 09:13
- Forum: Oracle
- Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
- Replies: 34
- Views: 2540
Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Unfortunately the result is the same, returned value is still truncated.
- 14.11.2024, 08:09
- Forum: User Patches
- Topic: GetSequence metadata for Oracle
- Replies: 2
- Views: 64
Re: GetSequence metadata for Oracle
I may be misunderstanding, but for Oracle catalog should be empty and schema should be the SEQUENCE_OWNER column of ALL_SEQUENCES. I started my journey with MySQL and MSSQL and things were a lot more easy to understand there. I will be completely honest, I am totally lost in this Oracle naming madn...
- 12.11.2024, 22:21
- Forum: MySQL
- Topic: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp
- Replies: 3
- Views: 67
Re: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp
Seems to be a Windows 11 and old lib library issue: https://stackoverflow.com/questions/706 ... und-in-the
What version is your server and client DLL?
What version is your server and client DLL?
- 12.11.2024, 17:43
- Forum: User Patches
- Topic: GetSequence metadata for Oracle
- Replies: 2
- Views: 64
GetSequence metadata for Oracle
Hello,
Since I needed it and it was not yet implemented I added the sequence collection for Oracle.
Unfortunately I was unable to find how I can connect a sequence to a catalog and a schema (if it can be at all) so those fields are left empty.
Pull request is available on GitHub as usual.
Cheers!
Since I needed it and it was not yet implemented I added the sequence collection for Oracle.
Unfortunately I was unable to find how I can connect a sequence to a catalog and a schema (if it can be at all) so those fields are left empty.
Pull request is available on GitHub as usual.
Cheers!
- 12.11.2024, 17:37
- Forum: Oracle
- Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
- Replies: 34
- Views: 2540
Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Unfortunately it seems that while Mark's fix indeed makes things better, does not solve the actual issue. While I was implementing sequence metadata for Oracle I was greeted with: [2024. 11. 12. 17:31:16] db: Prepare Statement 33 : SELECT * FROM ALL_TRIGGERS [2024. 11. 12. 17:31:16] db: Prepare Stat...
- 17.10.2024, 16:52
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: How to replace TZParam.LoadFromFile
- Replies: 2
- Views: 74
Re: How to replace TZParam.LoadFromFile
A quick google search will give you the knowledge you are looking for. No, it does not mean you have to type "overload", but to use an other, overloaded version. The error message means the method you are calling is deprecated and possibly will be deleted soon. So you should call other met...
- 16.10.2024, 23:40
- Forum: Oracle
- Topic: How to connect to Oracle without TnsNames.ora?
- Replies: 12
- Views: 1543
Re: How to connect to Oracle without TnsNames.ora?
because I feel it is counterintuitive for users to explicitly enable Zeos to use easy connect syntax? You are absolutely right. If we find a way to reliably make it automatic it makes sense to be on by default. But is it a breaking change to introduce this? From a Zeos perspective the behavior is u...
- 05.10.2024, 15:04
- Forum: Oracle
- Topic: How to connect to Oracle without TnsNames.ora?
- Replies: 12
- Views: 1543
Re: How to connect to Oracle without TnsNames.ora?
I am sorry to resurrect this thread but I wonder why we don't add a possibility for Zeos to internally create a correct connection string? Something like: if HostName <> '' then begin ConnStr := '//' + HostName; if Port <> 0 then ConnStr := ConnStr + ':' + IntToStr(Port); if Database <> '' then Con...
- 14.09.2024, 20:59
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: TZAbstractConnection.ConnectionLost issue
- Replies: 2
- Views: 108
Re: TZAbstractConnection.ConnectionLost issue
It won't be false, if a custom exception is raised and handled WITHIN the event handler itself... like Procedure TConnection.OnLost(Sender: TObject); Begin Raise Exception.Create('Connection to the database server was lost, please call 911'); End; If no custom exception was raised we create and rais...
- 12.09.2024, 20:24
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: AbortOperation issue
- Replies: 9
- Views: 213
Re: AbortOperation issue
I would also like to recommend a change of code in TZDbcPooledConnection.AbortOperation , The way it works now is that if it doesn't have a connection it obtain one only to abort it immediately. This is a waste. It should first check whatever the connection IsClosed and if not try to abort it. if i...
- 11.09.2024, 20:34
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: AbortOperation issue
- Replies: 9
- Views: 213
Re: AbortOperation issue
I use Firebird on a daily basis. What tests should I do? Jan, This is the comment I put in .AbortOperation for Firebird: // This is a mess and probably doesn't work as intended. cIStatus_RESULT_OK is 0, which means it doesn't matter what // getState returns, anything AND 0 will be 0. Therefore, 0 <...
- 09.09.2024, 09:50
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
- Replies: 15
- Views: 962
Re: Lazarus - TZUpdateSQL not bringing its update fields selected
Since it is 100% Delphi 7 compatible I issued a pull request on GitHub. I don't have any real-world application to test it on though so I'll leave that to the community :)
- 08.09.2024, 14:35
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
- Replies: 15
- Views: 962
Re: Lazarus - TZUpdateSQL not bringing its update fields selected
I did a minimal example and I can confirm that 1, Under Delphi 7 TListBox has .Selected[], .TopIndex and .SelectAll methods 2, Setting .Selected[] or invoking .SelectAll indeed moves the node in question to be visible (they do scroll the scrollbox) So, the below code is the most efficient and fool-p...