Hello.
Im an experienced SQL Server DBA. I am currently on a financial project that will allow for some complicated financial routines. I know that most of these functions are accessible from VB and Excel. For instance, one such function that will come into play is the IRR function.
I've read information on OLE Automation that says I can reference these VB functions from within my SQL Server program (if I create the necessary COM object). I have used COM with ASP to interact with SQL SErver. I've never created COM and then called it within SQL Server.
Can anyone point me in the right direction? Any tips or code samples would help as well?
thanks
Jim
Im an experienced SQL Server DBA. I am currently on a financial project that will allow for some complicated financial routines. I know that most of these functions are accessible from VB and Excel. For instance, one such function that will come into play is the IRR function.
I've read information on OLE Automation that says I can reference these VB functions from within my SQL Server program (if I create the necessary COM object). I have used COM with ASP to interact with SQL SErver. I've never created COM and then called it within SQL Server.
Can anyone point me in the right direction? Any tips or code samples would help as well?
thanks
Jim
