Exception handling with Delphi7

[vortex77]

Hi,
i'm working on app. that uses myDAC (v4.3) and Delphi7 and have question regarding myDAC except handling.
How to override myDAC exception handler? I would like to make my own handler (mostly to show my messages like 'wrong password, try again'), but in my try block myDAC already handles exceptions and my except block can't see any exception.
One example would be - entering wrong password or username while trying to connect to DB.

[RH]

Hi

one way arround this would be to disable LoginPrompt:

try
MyConnection1.LoginPrompt:= false;
MyConnection1.Connect;
except
on E: exception do
showmessage(E.Message);
end;

then you can itercept the exception. If login prompt is enabled, then I have the same problem too. Hope this helps

[kpowick]

Hi,
How to override myDAC exception handler?

You can easily do this with a product like madExcept (http://www.madshi.net).

It allows you to register your own handlers for specific exceptions, thus giving you full control over the exception handling process. It's a nice product, inexpensive, great support and you can download a free trial.

--
Kevin Powick

[vortex77]

thanks.
I've tryed LoginPrompt off but it doesnt help. I'm yet to download madExcept so i hope it'll work.

[Antaeus]

Try handling MyConnection.OnError event. This event is raised on all errors that concern working with server.