e.as exception

Trying to make an error web service that I can reference in other web services.  Having issues with the e. as exception part in the ErrorLog asmx.vb. as you can see from the commented code I have tried several ways but the only thing that loads into my DB is from the class insert statement. I am a newbee and I am over my head right now. Any suggestions will be greatly appreciated. Not sure if my issues is on the SQL , or vb?

See attached
Trying-to-make-an-error-web-serv.doc
RVivo33Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

inthecurveCommented:
Not sure what the errors are that you might be having, but you need to consider that the Exception you are attempting to pass to the web service is not what would be considered a simple type.  It requires additional processing to make this call work properly, but it can be done.
0
RVivo33Author Commented:
I have the attached 2nd function that creates the error with a (x * 0) what I am trying to do is log the error into another database that collects only errors from all applications.  I know I am connecting to the errors DB but the only thing that enters is from my insert statement and not from my             'CallWebRef.LogErrorToDB("ProdLibWS.FGInvSummaryPGWTD", ex, "App_CodeCustServDAL #3 FGInvSummaryPGWTD (Week to Date) - " & AppSettings("Server")) in the function (2nd Attachment) I think I am 1/2 way there but not sure why my ex as exception is not working right.  
Public-CallWebRef-As-New-LogErro.doc
0
RVivo33Author Commented:
The error I get is value of type string can not be converted into system exception.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

RVivo33Author Commented:
solution not solved by expert exchange
0
RVivo33Author Commented:
The answer to this question is you can not use e.exception with a webservice  or optional arguments with a web service.
0
inthecurveCommented:
The very first post answers the question, I object to a refund.  The very answer that the Author posted is in affect what I said in the first post.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.