Hi,
I've built a SQL CLR stored-procedure which return a resultset containing system drives on a given machine. I've chose CLR sproc instead of CLR TVF, as it has the ability to bubble up exception from the managed code, via the server, to the client.
My problem is to react on the error on the QV side. I'm using OLE DB and as such i'm getting only generic error "General OLEDB Error" when error occurs. This however doesn't get me much...
I have to question:
1. How can I "dive" deeper to the error? Is it possible to get information such as SQL error code, Source, ect?
2. Other than IF-trapping the error following the "vulnerable" statement, is there more robust error handing mechanism?
Appreciate your help,
Dror
