October 12, 2005 at 12:23 pm
Not sure if this a SQL server question or not but here goes...
We have a third party CRM system with a SQL server back-end database. The third party software comes with a set of DLL files that contain functions in them that do a number of things. These functions can be accessed through scripting languages (VB, LotusScript, etc.) and they work very well.
I wanted to know if you can access functions like this in a DLL file from a stored procedure. What I'm looking to do is to call a function that returns string data and assign it to a variable in the stored procedure.
Any ideas...
Thank you
October 12, 2005 at 12:29 pm
Thomas,
Look at the documentation for sp_OACreate stored procedure and all the sp_OA... procedures in the BOL. I think the DLLs will need to be installed on the SQL Server. There are many good examples out on the net.
Norman
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply