× Components and Libraries for Database Development, discussions, problems and suggestions

Question Trying to get actual error message with TIBConnection & TZConnection

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11842 by Md. Shariful Alam Khan
I am trying to get actual error message on connecting to Firebird database with TIBConnection & TZConnection. But both gives me overall error message, please check the attached images. For TZConnection I need to put firebird.msg on the library path. How can I get actual error message like if I enter wrong password it will provide actual firebird error message.

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 years 4 months ago #11843 by Sternas Stefanos
Thanks Sir
my suggestion is to check your Firebird database installation

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11848 by Md. Shariful Alam Khan
I download zeos stable 7.2.4 and installed it in Delphi Tokyo 10.2.3 and it gives me perfect error message. So there is no issue with my Firebird installation. I think CT's code for zeos has some problem.

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 years 4 months ago #11849 by Sternas Stefanos
Please post to ZEOS DB Forum
for more help

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11850 by Md. Shariful Alam Khan
I got the problem, if you set LibraryLocation on Database Settings it will not show actual error message.

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11851 by Md. Shariful Alam Khan
pl_zeos 7.3.0-alpha has some issues. With pl_zeos 7.2.4-stable I got actual error messge in Delphi. How can I set pl_zeos to 7.2.4-stable?

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 years 4 months ago - 3 years 4 months ago #11852 by Sternas Stefanos
We use for CT only trunk ZEOS version
but you can use/try and these:

1) ZEOS 6.6.1 form Lab CT 6.6
2) ZEOS old version 7.20-4

PilotLogic Architect and Core Programmer
Last edit: 3 years 4 months ago by Sternas Stefanos.

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11853 by Md. Shariful Alam Khan

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 years 4 months ago - 3 years 4 months ago #11854 by Sternas Stefanos
Sorry :blush:

please re-download pl_ZeosDBO_720-4.zip

ZEOS old version 7.20-4

PilotLogic Architect and Core Programmer
Last edit: 3 years 4 months ago by Sternas Stefanos.

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11855 by Md. Shariful Alam Khan
Please see attached error message after downloading pl_ZeosDBO_720-4.

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 years 4 months ago #11856 by Sternas Stefanos
Try and pl_ZeosDBO 6.6

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11857 by Md. Shariful Alam Khan
Though pl_ZeosDBO 6.6 did connect but not actual error message. Please see comparision:
CT 6.5 with pl_ZeosDBO 6.6
SQL Error: connection lost to database
StatusCode:
ErrorCode:-901


Delphi Tokyo with pl_ZeosDBO 7.24 stable
SQL Error: I/O error during "CreateFile (open)" operation for file "E:\TAUTUA.FDB645" Error while trying to open file The system cannot find the file specified. . Error Code: -902. can't format message 13:98 -- message file C:\WINDOWS\SYSTEM32\firebird.msg not found

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 years 4 months ago #11858 by Sternas Stefanos
Sir
we don't have any Delphi version in our LAB :)

My suggestion is to post at ZEOS forum

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11862 by Md. Shariful Alam Khan
You don't need Delphi for testing. Test with CT and see what I am talking about.

Please Log in or Create an account to join the conversation.

  • Md. Shariful Alam Khan
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 4 months ago #11863 by Md. Shariful Alam Khan
After installing zeos 7.2.4-stable my problem resolved. You need to update CT accordingly.

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
3 years 4 months ago - 3 years 4 months ago #11864 by Sternas Stefanos
Thanks Sir

PilotLogic Architect and Core Programmer
Last edit: 3 years 4 months ago by Sternas Stefanos.

Please Log in or Create an account to join the conversation.