Platform: Laz 1.8.1 Fpc 3.0.5, IBX 2.1.0 on Windows Server Essentials 2016
I am building a small database management utility, and I need to test a combination of Host/Port settings to ensure they will work (I want to do this before allowing database registrations and connections to that server in my utility).
I am trying to use the TIBServerProperties component for this purpose. Even though the TIBServerProperties component has a Params property, where I programmatically put the USER_NAME=SYSDBA, and PASSWORD=masterkey parameters (with Login Prompt := False).
When I set .Active := True, the TIBServerProperties component will connect (or, at least will not throw an error). I thought I was making progress, however, the .Active := True will succeed even with the wrong password. This is not quite what I want.
If I omit the parameters completely, OR if I go Login Prompt := True and enter the wrong password, I get the following raw error message:
[Window Title]
Connection Problem
[Content]
Unable to connect. Raw error message from DB: Cannot attach to services manager
service 3050:service_mgr is not defined
[OK]
Should I be using a different component just to test basic host/port connectivity? If indeed TIBServerProperties can be used for this purpose, how do I get it to fail when the user enters the wrong SYSDBA password?
Thanks in advance for any help you can provide.